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 |
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;
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.