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

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

Dynamike — Fri, 15 Sep 2017 04:38:15 GMT

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

Mean

StdDev

etc

Thanks a lot ahead!

Mike

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

PGStats — Fri, 15 Sep 2017 04:56:14 GMT

Try

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

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

Dynamike — Fri, 15 Sep 2017 04:58:28 GMT

Thank you!

Sometimes life can be so easy 🙂

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

sasuser123123 — Tue, 23 Jul 2019 11:02:18 GMT

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
.
.
.