topic Keep observations using a condition in SAS Programming

Keep observations using a condition

ali_far — Wed, 01 May 2019 08:16:30 GMT

Hi ,

my question is how I can only keep the IDs with the highest value of A

data have;
input id A B C;
cards;
1 2 3 4
1 4 2 5
1 5 3 12
1 7 34 3
2 5 5 5
2 6 12 0
2 9 3 2
2 11 3 1
3 7 6 5
3 23 3 2
3 12 12 44
4 4 23 33
4 9 6 1
5 5 7 2
6 7 8 1
run;

data want;
input id A B C;
cards;
1 7 34 3
2 11 3 1
3 23 3 2
4 9 6 1
5 5 7 2
6 7 8 1
run;

Thanks

Re: Keep observations using a condition

Jagadishkatam — Wed, 01 May 2019 08:35:42 GMT

Please try

proc sort data=have;
by id a;
run;

data want;
set have;
by id a;
if last.id;
run;

Re: Keep observations using a condition

Jagadishkatam — Wed, 01 May 2019 08:43:24 GMT

by proc sql

proc sql;
create table want as select a.* from have as a 
inner join 
(select id, max(a) as maxa  from have group by id) as b  on a.id=b.id and a.a=b.maxa;
quit;

Re: Keep observations using a condition

FreelanceReinh — Wed, 01 May 2019 08:45:34 GMT

Hi @ali_far,

Another option is PROC SUMMARY:

proc summary data=have;
by id;
var a;
output out=want(drop=_:) max= maxid(a(b c))=;
run;

Re: Keep observations using a condition

ali_far — Wed, 01 May 2019 08:46:55 GMT

Thanks Jag,
both codes work well!
appreciate your time

Re: Keep observations using a condition

ali_far — Wed, 01 May 2019 08:48:17 GMT

Thanks a lot.
Your code also works well and it is so cool...