topic Re: top 2 maximum and minimum values by proc in SAS Programming

top 2 maximum and minimum values by proc

draroda — Sun, 27 Nov 2016 09:49:02 GMT

Dear All,

I have below data.

118

190

I want to find out top 2 maximum and minimum values with proc (not by data step or proc sql).

is there any proc in sas which can handle the said scenario ?

Regards,

Rajesh

Re: top 2 maximum and minimum values by proc

Reeza — Sun, 27 Nov 2016 12:15:49 GMT

Proc univariate.

Re: top 2 maximum and minimum values by proc

PeterClemmensen — Sun, 27 Nov 2016 12:20:21 GMT

Proc IML ok? 🙂

data a;
input a;
infile datalines dlm = ' ';
datalines;
1 
2 
3 
4 
6 
99 
118 
190 
0 
4 
5 
8
;

proc iml;
use a;
   read all var _NUM_ into a;
close a;

call sort(a);
rows = nrow(a);


print (a[1:2, ]), (a[rows - 1:rows, ]);
quit;