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;
Would the above work?
The 2025 SAS Hackathon has begun!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.