Hi, i have run the code but output didn't come as desired. Question asked : Obs. Number name score N 1. 1 David. 54. 1 2. 1. David. 75 2 3. 2. Sam. 24. 1 4. 2. Ram. 35. 1 Please find my code. data x; input number name $ score; cards; 1 David 75 2 Sam 24 2 Ram 35 1 David 54 ; run; proc sort data=x; by name score; run; data want; set x; by name score; if first.name then N=1; else N+1; if N<=2;run; Output after running above code: Obs. Number name score N 1. 1 David 54 1 2. 1. David 75 2 3. 2. Ram 35 1 4. 2. Sam 24 1
... View more