Abu Musa Ashari reported,

Saad fell ill in Makkah, and the Prophet ﷺ came to visit him. Saad asked him, "Messenger of Allah, do you not dislike that a man should die in the land from which he emigrated?"He replied, "Yes, but perhaps Allah تبارك وتعالى will raise you up so that through you He may harm some people and benefit others."

Azami 9962

Hasan

عن أبي موسى قال

مرض سعد بمكة، فأتاه النبي ﷺ يعوده، فقال له: يا رسول الله، أليس تكره أن يموت الرجل في الأرض التي هاجر منها؟ قال: بلى، ولعل الله تبارك وتعالى يرفعك فيضر بك قوما وينفع آخرين بك.

الأعظمي 9962حسن
Contents
Reference
Commentary
Ayat
Collection
Jami al-Kamil
Book
Virtues of the Companions and reports about them
Chapter
Virtues and reports of Saad bin Abu Waqqas
Section
Prophet's ﷺ saying to Saad, "Some people will benefit through you and others will be harmed through you"
Numbering
Jami al-Kamil 9962 (2nd edition)
Azami 9962