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?
Catch up on SAS Innovate 2026
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.