DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Contributor
Posts: 42
Accepted Solution

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
Trusted Advisor
Posts: 1,321

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

Posted in reply to sambasiva_ravuri_tcs_com

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

View solution in original post


All Replies
Solution
‎03-21-2012 06:16 AM
Trusted Advisor
Posts: 1,321

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

Posted in reply to sambasiva_ravuri_tcs_com

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 ?

Posted in reply to MichelleHomes

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

Regards,

S Ravuri.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 236 views
  • 0 likes
  • 2 in conversation