DATA Step, Macro, Functions and more

sas query how to find the n highest number

Reply
New Contributor
Posts: 4

sas query how to find the n highest number

Hi,

I have huge data with variable name HighPrice. How can i find highest and lowest number from the data. Have data like given below

 

HighPrice
568.45
571
604.3
619.35
612.7
629
651
650.7
652
678.9
689.9
665
664.4
666.8
627.5
619.4
627.25
650.8
663.95
642
631.9
Trusted Advisor
Posts: 1,137

Re: sas query how to find the n highest number

[ Edited ]
Posted in reply to Talwinder

Please try the proc univariate which will displays the 5 lowest and 5 highest value observation. in that the first lowest and last highest represent the lowest and highest values.

 

data have;
input HighPrice;
cards;
568.45
571
604.3
619.35
612.7
629
651
650.7
652
678.9
689.9
665
664.4
666.8
627.5
619.4
627.25
650.8
663.95
642
631.9
;

proc univariate data=have;
var highprice;
run;

 

Thanks,
Jag
Trusted Advisor
Posts: 1,137

Re: sas query how to find the n highest number

Posted in reply to Talwinder
Even through proc sql also you could get result

proc sql;
select min(highprice), max(highprice) into:min, :max from have;
quit;
Thanks,
Jag
Super User
Posts: 11,343

Re: sas query how to find the n highest number

Posted in reply to Talwinder

Many procedures available: proc means or summary, Proc Report or Proc Tabulate if want to make pretty output.

 

proc means data=have max min;

   var highprice;

run;

 

 

Ask a Question
Discussion stats
  • 3 replies
  • 184 views
  • 0 likes
  • 3 in conversation