I want to dedupe the duplicate codes based on their Score, the highest score stays followed by sorting high to low of score. But, if the score is the same & reason codes are different, I want to maintain the order of reason codes. The dedupe only happens across one id, ID - 1 would *not* look for duplicates in ID - 2   Example -    HAVE -  data have; input id name $ score code $; datalines; 1 John 23 A05 1 John 26 A02 1 John 26 A03 1 John 26 A01 2 Mark 21 A05 2 Mark 22 A05 2 Mark 23 A07 ; run;   ID NAME SCORE CODE 1 John 23 A05 1 John 26 A02 1 John 26 A03 1 John 26 A01 2 Mark 21 A05 2 Mark 22 A05 2 Mark 23 A07   WANT -    ID NAME SCORE CODE 1 John 26 A02 [ Same Order as HAVE ] 1  John 26 A03 1 John 26 A01 1 John 23 A05 2 Mark 23 A07 2 Mark 22 A05     ... View more

Hi! I would like to store the top 3 values of every id & create a column out of it. And let's say there are only two values present, the columns should be blank data haveOne; input id value $; datalines; 1 ABC 1 EFG 1 XYZ 1 UVW 2 GHJ 2 XYZ 3 ABC; run;   ID Value 1 ABC 1 EFG 1 XYZ 1 UVW 2 GHJ 2 XYZ 3 ABC WantOne ID Value_1 Value_2 Value_3 1 ABC EFG XYZ 2 GHJ XYZ . 3 ABC . .   Any kind of help would be appreciated, thanks!  ... View more