topic Possible to transpose Frequency and Col Pct output in 2x2 proc freq table? in SAS Programming

Possible to transpose Frequency and Col Pct output in 2x2 proc freq table?

RobertWF1 — Thu, 07 Jul 2022 17:47:11 GMT

For example, running proc freq on the following data:

data test;
input class :$9. gender :$1.;
cards;
Treatment M
Treatment M
Treatment F
Treatment F
Control M
Control M
Control F
Control F
Control F
Control F
;
run;
proc freq data=test;
table gender*class / nopercent norow out=freq_gender;
run;

I'd like to produce the following table with nested header:

	Control		Treatment
Gender	Frequency	Col Pct	Frequency	Col Pct
Female	4	66.67	2	50.00
Male	2	33.33	2	50.00

Is that possible in proc freq or do I need to use other procedures?

Re: Possible to transpose Frequency and Col Pct output in 2x2 proc freq table?

Reeza — Thu, 07 Jul 2022 17:57:59 GMT

I'd probably recommend PROC TABULATE. More control over what is displayed in that procedure.

Re: Possible to transpose Frequency and Col Pct output in 2x2 proc freq table?

RobertWF1 — Thu, 07 Jul 2022 21:24:05 GMT

Yes the following worked, thanks Reeza:

proc tabulate data=test;
class gender class;
table gender,class*(n='N'*F=6.0 colpctn='%'*F=6.2);
run;