sorting by multiple variable and getting the first observation

[USHAKS]

data work.resiSorted;
set work.resi;
by ID Career descending Term;
run;

I am having many columns in work.resi.

My data get sorted as I wish.

When I want to get the 1st ID/career/Term details of the observation:-  it is not working;

proc sort data= work.resisorted;

by ID;

if first.id;

[novinosrin]

Hi @USHAKS  Do you mean you are after this by any chance

proc sort data=work.resi out=resi_sorted;
by id career descending term;
run;


data work.want;
set work.resi_sorted;
by ID ;
if first.id;
run;

[USHAKS]

Yes.

[novinosrin]

Okay good, I'm glad we figured the need. Thanks!