final age should contain max value of age1 age2 age3 age4 age5 age6

aanan1417 — Mon, 04 Apr 2022 11:25:14 GMT

data have;

input age1 age2 age3 age4 age5 age6;

datalines;

11 22 33 44 55 65

44 88 99 65 32 77

;

run;

data want ;

input age1 age2 age3 age4 age5 age6 final_age;

datalines;

11 22 33 44 55 65 65

44 88 99 65 32 77 99

;

run;

;

run;

Re: final age should contain max value of age1 age2 age3 age4 age5 age6

Kurt_Bremser — Mon, 04 Apr 2022 11:46:27 GMT

Given your name structure, this is done quite simply:

final_age = max(of age:);