Hi All,
How can I find the 3rd highest(all ways) value in a dataset.
Regards
Anand
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
Proc Rank seems handy:
proc rank data=sashelp.class out=want(where=(rank=3)) descending ties=dense;
var age;
ranks rank;
run;
Haikuo
this doesn't work.
NOTE: The data set WORK.WANT has 0 observations and 6 variables.
Have you already searched the communities here. Similar questions have already been asked and answered multiple times.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.