Solved
Contributor
Posts: 42

# Write single SAS Program to get the smallest,largest,mean and Median values ?

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.

Accepted Solutions
Solution
‎03-21-2012 06:16 AM
Posts: 1,403

## Write single SAS Program to get the smallest,largest,mean and Median values ?

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

All Replies
Solution
‎03-21-2012 06:16 AM
Posts: 1,403

## Write single SAS Program to get the smallest,largest,mean and Median values ?

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

Contributor
Posts: 42

## Write single SAS Program to get the smallest,largest,mean and Median values ?

Regards,

S Ravuri.

🔒 This topic is solved and locked.