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?
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;