Hi my dataset looks like this right now:
clear
input long mrn str10 date str11 diagnosis long date_n float(CAD CHF CKD CVA ESKD HLD HTN OSA obesity RAS T1DM T2DM tobacco)
1558 "9/13/2011" "CKD" 18883 . . 1 . . . . . . . . . .
1558 "9/28/2011" "ESKD" 18898 . . . . 1 . . . . . . . .
1558 "1/9/2018" "HLD" 21193 . . . . . 1 . . . . . . .
1558 "3/8/2012" "HTN" 19060 . . . . . . 1 . . . . . .
1558 "6/17/2013" "KTR" 19526 . . . . . . . . . . . . .
1558 "12/15/2012" "Obesity" 19342 . . . . . . . . 1 . . . .
1558 "6/11/2013" "T2DM" 19520 . . . . . . . . . . . 1 .

I wanted each mrn to have one row only. Right now they have multiple rows because the dates for different diagnosis are listed separately. Can I have the data look somewhat like this?

ID date CKD CAD CVA but only one row for each.
I hope I am able to make sense.
Please help me out I am new to STATA.

Ushma