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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.