Solved: Find min and max - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

Find min and max

Posted 06-15-2020 07:51 PM (806 views)

1 ACCEPTED SOLUTION

Accepted Solutions

Tourmaline | Level 20

Tourmaline | Level 20

Re: Find min and max

Posted 06-15-2020 07:59 PM (786 views) | In reply to Emma8

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;

View solution in original post

1 REPLY 1

Tourmaline | Level 20

Tourmaline | Level 20

Re: Find min and max

Posted 06-15-2020 07:59 PM (787 views) | In reply to Emma8

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;