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

[aanan1417]

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;

[Kurt_Bremser · Accepted solution]

Given your name structure, this is done quite simply:

final_age = max(of age:);