## Descriptive statistics of a listing in the same column

Solved
Occasional Contributor
Posts: 7

# Descriptive statistics of a listing in the same column

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.

Accepted Solutions
Solution
‎04-11-2015 04:17 PM
Super User
Posts: 23,776

## Re: Descriptive statistics of a listing in the same column

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;

All Replies
Solution
‎04-11-2015 04:17 PM
Super User
Posts: 23,776

## Re: Descriptive statistics of a listing in the same column

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;

Occasional Contributor
Posts: 7

## Re: Descriptive statistics of a listing in the same column

Thank you very much Reeza. Great solution!

🔒 This topic is solved and locked.