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

[sambasiva_ravuri_tcs_com]

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.

[MichelleHomes · Accepted solution]

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

[sambasiva_ravuri_tcs_com]

OOPS....I forgot about this PROC. Million Thanks to  Michelle.

Regards,

S Ravuri.