Help to get the summary statistics

Re: Help to get the summary statistics

topic Help to get the summary statistics in SAS Procedures

Help to get the summary statistics

Re: Help to get the summary statistics

danielhu — Sun, 05 Apr 2015 08:13:57 GMT

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

Table A

Year	Index
2008	4
2008	8
2008	7
2009	5
2009	8
2010	11
2010	14
2010	5
2011	6

Table B

	2008	2009	2010	2011
Min
Mean
Median
Mode
Max
Stand Dev

stat_sas — Sun, 05 Apr 2015 18:15:55 GMT

Try this.

proc tabulate data=TableA;

class year;

var index;

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

run;

Analysis Variable : Index