topic Descriptive statistics of a listing in the same column in SAS Procedures

Descriptive statistics of a listing in the same column

bmozdemir — Sat, 11 Apr 2015 19:28:34 GMT

Hello
I'd like to get some descriptive statistics and report them similar to the example below. For example we can take the data set cars. How should I list the individual parametes first and then the descriptives right after them in the same column? Proc report?

-	x1	x2	x3
-	1	5	7
-	2	8	9
-	3	10	4
-	4	3	5
N	4	4	4
mean	2.5	6.5	6.25
std.	1.29	3.11	2.22
min	1	3	4
median	2.5	6.5	6
max	4	10	9
%CV	51.6	47.8	35.5
geo. mean	2.2	5.9	6.0

Thank you.

Re: Descriptive statistics of a listing in the same column

Reeza — Sat, 11 Apr 2015 20:17:22 GMT

None of the standard procs will do that by default, you'll have to create your own data and then use proc print or report to display it.

Here's a sample, but it doesn't create the geomean.

data have;

input x1 x2 x3;

cards;

1 5 7

2 8 9

3 10 4

4 3 5

;

run;

proc means data=have stackods n mean min std median max cv;

var x1 x2 x3;

ods output summary=stats;

run;

proc transpose data=stats out=stats2;

id variable;

run;

data want;

set have (in=a) stats2(in=b);

if a then _NAME_='RAW';

drop _label_;

run;

Re: Descriptive statistics of a listing in the same column

bmozdemir — Tue, 14 Apr 2015 12:49:19 GMT

Thank you very much Reeza. Great solution!