Reshaping proc means statistics

AKHILA — Wed, 03 Apr 2019 14:10:13 GMT

i have a dataset like;

TRT VAR1 VAR2 VAR3 VAR4 VAR5

A 12 34 56 White male

B 34 65 98 white male

A 12 55 34 White female

A 21 62 72 White male

B 64 32 31 white female

- __ ____ _____ ___ _ _ _ _

................................................

like this i am having some 100 records

the required o/p is as in the image shown in which

1. the min-Max and q1-q3 value should be combined as 'Min-max' and 'Q1-Q3'

2.var4 and var5 are character values whose statistics should be calculated along with percentages in braces.

3. The column "ALL'' also need to be calculated.

Re: Reshaping proc means statistics

Reeza — Wed, 03 Apr 2019 14:45:03 GMT

There isn't anything out of the box that does this - primarily because everyone wants their own method.

Here's a macro that gets pretty close that you can modify, with some work.

https://gist.github.com/statgeek/2f27939fd72d1dd7d8c8669cd39d7e67

If you search on lexjansen.com for "table of characteristics or table 1" you'll find several other solutions. I usually find the one closest to what I need and go from there.

@AKHILA wrote:

i have a dataset like;

TRT VAR1 VAR2 VAR3 VAR4 VAR5

A 12 34 56 White male

B 34 65 98 white male

A 12 55 34 White female

A 21 62 72 White male

B 64 32 31 white female

- __ ____ _____ ___ _ _ _ _

................................................

................................................

like this i am having some 100 records

the required o/p is as in the image shown in which

1. the min-Max and q1-q3 value should be combined as 'Min-max' and 'Q1-Q3'

2.var4 and var5 are character values whose statistics should be calculated along with percentages in braces.

3. The column "ALL'' also need to be calculated.

topic Re: Reshaping proc means statistics in SAS Programming

Reshaping proc means statistics

Re: Reshaping proc means statistics