Hello,   New SAS user here. I have a dataset with ID, date, and different diagnoses given on that date. I would like to transform this dataset from long to wide as seen in the example below. But I am having trouble using do-loop.   The first table is the dataset I have. The second table is what I want. Any help would be appreciated.  Thank you   ID Date Diagnosis1 Diagnosis2 Diagnosis3 Diagnosis4 Diagnosis5 1 1/20/19 F123 F124       1 1/21/19 F284 F124 F3     1 1/22/19 F156         1 1/23/19 F189         2 2/1/19 F98         2 2/2/19 F78         3 3/1/19 F56         3 3/2/19 F57         3 3/3/19 F10 F11 F12 F13 F14 1 3/20/19 F17         3 9/1/19 F124               ID  Date1 Diagnosis1 Date2 Diagnosis2 Date3 Diagnosis3 Date4 Diagnosis4 Date5 Diagnosis5 Date6 Diagnosis6 Date7 Diagnosis7 Date8 Diagnosis8 1 1/20/19 F123 1/20/19 F124 1/21/19 F284 1/21/19 F124 1/21/19 F3 1/22/19 F156 1/23/19 F189 3/20/19 F17 2 2/1/19 F98 2/2/19 F78                         3 3/1/19 F56 3/2/19 F57 3/3/19 F10 3/3/19 F11 3/3/19 F12 3/3/19 F13 3/3/19 F14 9/1/19 F124 ... View more