keep highest value using proc sort

RebeccaJW — Fri, 10 May 2019 04:26:31 GMT

data raw; set rawdata;
     keep day year title number;
proc sort data=raw nodupkey; by day year; run;

How could I modify this code to keep the day and year with the highest number if raw data contained multiple different values of numbers, instead of just a single value?

Thank you!

Re: keep highest value using proc sort

novinosrin — Fri, 10 May 2019 04:57:02 GMT

data raw; set rawdata;
     keep day year title number;
proc sort data=raw ; 
by day year descending number; run;

data want;
set raw;
by day year;
if first.year;
run;

Would the above work?

topic keep highest value using proc sort in New SAS User

keep highest value using proc sort

Re: keep highest value using proc sort