proc sql; create table want as select s.*, coalescec(v.flag,'0') as flag from source s left join ( select distinct id,date,level, '1' as flag length=1 from source group by id, date having max(age)=age ) v on s.id=v.id and s.date=v.date and s.level=v.level ; quit; ... View more

Post the sas code, NOT picture, nobody would like to type it for you if want help from others.   data a; input id count dty; cards; 1022 2 200 1022 2 600 6500 3 3 6500 3 50 6500 3 12 ; data b; input id dt : date9.; format dt date9.; cards; 1022 25apr2018 1022 11jul2018 6500 08may2018 6500 31may2018 6500 20mar2018 ; data have; merge a b; by id; run; proc sql noprint; select max(count) into : n from (select count(*) as count from have group by id); quit; data want; set have; by id; array dty_{&n}; array dt_{&n}; if first.id then n=0; n+1;dty_{n}=dty;dt_{n}=dt; drop dt n; format dt_: date9.; run; ... View more