topic Re: Proc Tabulate N(%) in ODS and Base Reporting

Proc Tabulate N(%)

MiraKr_ — Thu, 23 Aug 2018 19:50:54 GMT

Hello,

I am looking for a way to request proc tabulate to display the output with N(%) in the same column. Is that possible using proc tabulate or do I need proc template?

proc tabulate data=dquest.pooled_dri_quest missing;
class STUDYID sex ;
tables (sex all='Overall' ), STUDYID*(n='N'*F=6.0 colpctn='%'*F=6.1) (all='Pooled')*(N='N'*F=6.0 COLPCTN='%'*F=6.1);
run;

Output:

	Study Identifier				Pooled
	DRI12544		EFC13579
	N	%	N	%	N	%
Sex	490	63.1	1197	62.9	1687	63
F
M	286	36.9	705	37.1	991	37
Overall	776	100	1902	100	2678	100

I want this:

	Study Identifier		Pooled
	DRI12544	EFC13579	Pooled
	N (%)	N (%)	N (%)
Sex	490 (63.1)	1197 (62.9)	1687 (63.0)
F	490 (63.1)	1197 (62.9)	1687 (63.0)
M	286 (36.9)	705 (37.1)	991 (37.0)
Overall	776 (100)	1902 (100)	2678 (100)

Many Thanks,
MK

Re: Proc Tabulate N(%)

Reeza — Thu, 23 Aug 2018 20:03:08 GMT

It's not possible with PROC TABULATE. If I need that type of reporting, I create the field as text within a data step and use PROC PRINT or REPORT to display it.

@MiraKr_ wrote:

Hello,

I am looking for a way to request proc tabulate to display the output with N(%) in the same column. Is that possible using proc tabulate or do I need proc template?

proc tabulate data=dquest.pooled_dri_quest missing;
class STUDYID sex ;
tables (sex all='Overall' ), STUDYID*(n='N'*F=6.0 colpctn='%'*F=6.1) (all='Pooled')*(N='N'*F=6.0 COLPCTN='%'*F=6.1);
run;

Output:

Study Identifier Pooled

DRI12544 EFC13579

N % N % N %

Sex 490 63.1 1197 62.9 1687 63

F

M 286 36.9 705 37.1 991 37

Overall 776 100 1902 100 2678
100

I want this:

Study Identifier Pooled

DRI12544 EFC13579

N (%) N (%) N (%)

Sex 490 (63.1) 1197 (62.9) 1687 (63.0)

F

M 286 (36.9) 705 (37.1) 991 (37.0)

Overall 776 (100) 1902 (100) 2678 (100)

Many Thanks,
MK

Re: Proc Tabulate N(%)

ballardw — Fri, 24 Aug 2018 16:08:46 GMT

You can create output that with print similar to that on paper but not in electronic form with proc tabulate. Keys are using the correct, possibly custom to provide (), format for the %, justification of values in the cells, using style overrides to remove any cell border and likely cellpadding settings between the N and %.

The values will still be in separate "columns" but the decision is yours.