Proc sql finding maximum values

[vandhan]

data have;
input id sal;
cards;
101 1000
102 2000
103 1000
104 3000
105 3000
106 4000
;

How would i find 3rd max sal from above data using sql ??

[RW9]

It is simpler to use a datastep here:

data have;
  input id sal;
cards;
101 1000
102 2000
103 1000
104 3000
105 3000
106 4000
;
run;

proc sort data=have;
  by sal;
run;

data want;
  set have;
  if _n_=3;
run;

[vandhan]

if i have max values 6 values like 4000 ... in that case this is not
possible...

##- Please type your reply above this line. Simple formatting, no
attachments. -##

[LinusH]

Hey, stop posting the same question in different forums, pls.

[RW9]

Indeed, other post here:

https://communities.sas.com/t5/General-SAS-Programming/proc-sql/m-p/246594

Close this one.