Dear All,
I have a Dataset
x
1
3
2
6
4
8
7
1
9
Usingn this Dataset, would like to get the smallest,largest, Mean and Median values in a single program. Is it possible ?
Syntaxes for all as below:
Smallest - MIN(argument,argument, ...)
Largest - MAX(argument,argument, ...)
Mean - MEAN(argument,argument, ...)
MEDIAN(value1<, value2, ...>)
Regards,
S Ravuri.
Hi,
Have you looked at using PROC MEANS? You can create a table and a report with the results if you like... general syntax you would need is as follows:
data dataset_name;
input x;
cards;
1
3
2
6
4
8
7
1
9
;
run;
*To only produce a report;
proc means data=dataset_name min max mean median;
var x;
run;
*To produce a report and a table that contains the statistics;
proc means data=dataset_name min max mean median;
var x;
output out=summaryStatistics min=Smallest max=Largest mean=Mean mean=Median;
run;
For more details check out http://support.sas.com/documentation/cdl/en/proc/63079/HTML/default/viewer.htm#p0f0fjpjeuco4gn1ri963...
Cheers,
Michelle
Hi,
Have you looked at using PROC MEANS? You can create a table and a report with the results if you like... general syntax you would need is as follows:
data dataset_name;
input x;
cards;
1
3
2
6
4
8
7
1
9
;
run;
*To only produce a report;
proc means data=dataset_name min max mean median;
var x;
run;
*To produce a report and a table that contains the statistics;
proc means data=dataset_name min max mean median;
var x;
output out=summaryStatistics min=Smallest max=Largest mean=Mean mean=Median;
run;
For more details check out http://support.sas.com/documentation/cdl/en/proc/63079/HTML/default/viewer.htm#p0f0fjpjeuco4gn1ri963...
Cheers,
Michelle
OOPS....I forgot about this PROC. Million Thanks to Michelle.
Regards,
S Ravuri.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.