data have;
infile datalines dlm=',';
input ID $ Year Freq;
datalines;
1,2015,2
1,2016,5
1,2016,8
1,2018,6
1,2019,4
1,2019,3
1,2020,7
1,2020,3
2,2018,1
2,2018,3
2,2020,4
2,2021,6
;
data temp/view=temp;
set have;
by id;
if first.id then group=1;
if dif(year)>1 then group+1;
run;
proc sql;
create table want as
select id, year, freq, max(freq) as max_freq
from temp
group by id, group;
quit ;
... View more
