top 2 maximum and minimum values by proc

[draroda]

Dear All,

I have below data.

a

1

2

3

4

6

99

118

190

0

4

5

8

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

[Reeza · Accepted solution]

Proc univariate. 

[PeterClemmensen]

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;