How to find the least three values?

RamKumar — Wed, 05 Nov 2014 12:31:05 GMT

I need to find out least 3 values from the list of ten variables.

e.g.

Desired output:

With the 'min' function we can find out only the least 1 variable, but I was why wondering to get the least three values.

Appreciate your inputs in advance.

Re: How to find the least three values?

Loko — Wed, 05 Nov 2014 12:47:34 GMT

Hello,

data have;
input a b c d e;
datalines;
1 2 3 4 5
10 50 20 30 40
50 60 40 30 30
;

data want;

array mindistance{3};
set have;
do i=1 to 3;
mindistance{i}=smallest(i,a,b,c,d,e);
end;

run;

RamKumar — Wed, 05 Nov 2014 13:27:29 GMT

Thanks.

how to find the maximum 3 values for the same scenario?

RamKumar — Wed, 05 Nov 2014 13:29:25 GMT

I got it. It can be done via largest function.