topic Re: sorting by multiple variable and getting the first observation in SAS Programming

sorting by multiple variable and getting the first observation

USHAKS — Mon, 09 Mar 2020 23:49:35 GMT

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 — Tue, 10 Mar 2020 00:01:50 GMT

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 — Tue, 10 Mar 2020 17:53:30 GMT

Yes.

novinosrin — Tue, 10 Mar 2020 17:54:49 GMT

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