Saad bin Abu Waqqas reported,

The Messenger of Allah ﷺ visited me during the Farewell Pilgrimage when I was suffering from an illness that had brought me to the brink of death. He mentioned the story of the will, then I said, "Messenger of Allah, will I be left behind after my companions have gone?"He replied, "You will not be left behind to perform any deed by which you seek the face of Allah without it increasing you in rank and elevation. Perhaps you will be left behind so that some people may benefit through you and others may be harmed by you. O Allah, complete my companions' migration for them and do not turn them back on their heels. But the unfortunate one is Saad bin Khawla." The Messenger of Allah ﷺ grieved for him because he died in Mecca.

Azami 8651

Sahih

عن سعد بن أبي وقاص قال

عادني رسول الله ﷺ في حجة الوداع من وجع أشفيت منه على الموت فذكر قصة الوصية ثم قال: يا رسول الله! أخلف بعد أصحابي؟ قال: إنك لن تخلف فتعمل عملا تبتغي به وجه الله إلا زادت به درجة ورفعة، ولعلك تخلف حتى ينفع بك أقوام، أو يضر بك آخرون. اللهم أمض لأصحابي هجرتهم، ولا تردهم على أعقابهم، لكن البائس سعد بن خولة رثى له رسول الله ﷺ أن توفي بمكة.

الأعظمي 8651صحيح
Contents
Reference
Commentary
Ayat
Collection
Jami al-Kamil
Book
Biography of the Prophet ﷺ
Chapter
Emigration of the Prophet ﷺ and his companions from Makkah to Madinah
Section
Supplication of the Prophet ﷺ for his companions for emigration
Numbering
Jami al-Kamil 8651 (2nd edition)
Azami 8651