Find min and max

[novinosrin · Accepted solution]

Hi @Emma8  please see if this helps

data have;
input ID $ var1 var2 var3 ;
cards;
A 4 1 5
B . 5 5
C 1 1 4
;

data want;
 set have;
 array t var1-var3;
 min=min(of t(*));
 min_name=vname(t(whichn(min,of t(*))));
 max=max(of t(*));
 max_name=vname(t(whichn(max,of t(*))));
run;