topic Re: 3rd highest value in SAS Programming

3rd highest value

AnandSahu — Wed, 30 Oct 2013 03:18:02 GMT

Hi All,

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

Regards

Anand

Tushar — Wed, 30 Oct 2013 04:05:08 GMT

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

data salary;

input sal;

cards;

-21

;

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

Patrick — Wed, 30 Oct 2013 04:13:25 GMT

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

Haikuo — Wed, 30 Oct 2013 04:25:21 GMT

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 — Fri, 23 Nov 2018 11:42:20 GMT

this doesn't work.

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