Hi Everyone, Can anybody help me with the below issue? -> wanted to convert the following datastep (containing first. last. functionality) into Proc sql data readin;
input ID Name $ Score;
cards;
1 David 45
1 David 74
2 Sam 45
2 Ram 54
3 Bane 87
3 Mary 92
3 Bane 87
4 Dane 23
5 Jenny 87
5 Ken 87
6 Simran 63
8 Priya 72
;
run;
proc sort data=readin; by ID Name; run;
data b;
set readin;
by ID Name;
if last.ID or last.Name then output;
run;
... View more
