Help using Base SAS procedures

Help to get the summary statistics

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

Help to get the summary statistics

Hi, I need some help getting the summary statistics for table A to the format of table B. I have tried the following code but that is not sufficient (test table), I will require stats such as mode and median too. AND how do I format the data to look like the one in B.

proc means data=work.t2;

        var gindex;

        class year;

        output out=work.t2

run;

Test

Analysis Variable : Index
YearN ObsNMeanStd DevMinimumMaximum
2008
2009
2010
2011

Table A                                                        

YearIndex
20084
20088
20087
20095
20098
201011
201014
20105
20116

Table B

2008200920102011
Min
Mean
Median
Mode
Max
Stand Dev

Accepted Solutions
Solution
‎04-05-2015 02:15 PM
Trusted Advisor
Posts: 1,204

Re: Help to get the summary statistics

Try this.

proc tabulate data=TableA;

class year;

var index;

table (n min mean median mode max stddev),year*index=' ';

run;

View solution in original post


All Replies
Solution
‎04-05-2015 02:15 PM
Trusted Advisor
Posts: 1,204

Re: Help to get the summary statistics

Try this.

proc tabulate data=TableA;

class year;

var index;

table (n min mean median mode max stddev),year*index=' ';

run;

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 156 views
  • 0 likes
  • 2 in conversation