Proc Tabulate: Mean Median etc. in the column instead of row

[Dynamike]

Hi,

at the moment i have:

Proc Tabulate Data=res.Pseudo_dist_Min;
class HDiag3;
Var Alter_;
Table (N Mean STDDEV Median Min Max)*Alter_*Hdiag3;
run;

"Alter_" consists age information (variable of interest) and "Hdiag3" includes diagnoses.

and the result is:

How to convert the result to something like that (diagnoses in the row, N Mean etc. in the column and Alter_ as the variable of interest):

       S06.0 S06.1 S06.2 etc

N

Mean

StdDev

etc

Thanks a lot ahead!

Mike

[PGStats · Accepted solution]

Try

Table (N Mean STDDEV Median Min Max), Alter_*Hdiag3;

[Dynamike]

Thank you!

Sometimes life can be so easy 🙂

[sasuser123123]

I've a data like ,
Lab drug visit sub
A01 asl2mg 1 90
A02 aa00mg 1 89
A03 asl3mg 1 88
A04 asl3mg 1 88
A01 asl2mg 2 70
A02 asl2mg 2 79
.
.
.
.

I want the report like
Sub
Lab_group. N. Mean
A01. Somevalue some value
.
.
.