Something like this, I suppose:
Data want;
do until(last.familynm);
set have;
by familynm;
array ages(*) age1-age144;
array maxage(*) 8 maxage1-maxage144;
do _N_=1 to dim(ages);
maxage(_N_)=max(maxage(_N_),ages(_N_));
end;
end;
do until(last.familynm);
set have;
by familynm;
output;
end;
run;
Something like this, I suppose:
Data want;
do until(last.familynm);
set have;
by familynm;
array ages(*) age1-age144;
array maxage(*) 8 maxage1-maxage144;
do _N_=1 to dim(ages);
maxage(_N_)=max(maxage(_N_),ages(_N_));
end;
end;
do until(last.familynm);
set have;
by familynm;
output;
end;
run;
This seems like you may be attempting to force a spreadsheet style of solution onto a SAS data set.
How do you expect to use that result?
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.