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