topic Proc sql finding maximum values in SAS Programming

Proc sql finding maximum values

vandhan — Thu, 28 Jan 2016 11:42:44 GMT

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 ??

Re: Proc sql finding maximum values

RW9 — Thu, 28 Jan 2016 11:48:39 GMT

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;

Re: Proc sql finding maximum values

vandhan — Thu, 28 Jan 2016 11:51:39 GMT

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. -##

Re: Proc sql finding maximum values

LinusH — Thu, 28 Jan 2016 12:46:15 GMT

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

Re: Proc sql finding maximum values

RW9 — Thu, 28 Jan 2016 12:54:45 GMT

Indeed, other post here:

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

Close this one.