Help using Base SAS procedures

Descriptive statistics of a listing in the same column

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

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?

-x1x2x3
-157
-289
-3104
-435
N444
mean2.56.56.25
std.1.293.112.22
min134
median2.56.56
max4109
%CV51.647.835.5
geo. mean2.25.96.0

Thank you.


Accepted Solutions
Solution
‎04-11-2015 04:17 PM
Grand Advisor
Posts: 16,930

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;

View solution in original post


All Replies
Solution
‎04-11-2015 04:17 PM
Grand Advisor
Posts: 16,930

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.

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

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