3rd highest value

[AnandSahu]

Hi All,

How can I find the 3rd highest(all ways) value in a dataset.

Regards

Anand

[Tushar]

Hi AnandSahu, Below is the example of finding nth highest salary from given input using Proc SQL.

data salary;

input sal;

cards;

23

12

.

45

0

54

-21

43

;

run; 

%let N=3;
proc sql;
select a.sal from salary a where &N= (select count(distinct sal) from salary b where a.sal<=b.sal);
quit;

Regards,

Tushar J

[Haikuo]

Proc Rank seems handy:

proc rank data=sashelp.class out=want(where=(rank=3)) descending ties=dense;

var age;

ranks rank;

run;

Haikuo

[Rahul_SAS]

this doesn't work.

NOTE: The data set WORK.WANT has 0 observations and 6 variables.

[Patrick]

Have you already searched the communities here. Similar questions have already been asked and answered multiple times.