putdocxcrosstab contribution on SSC

[Jan Brogger]

Putdocxcrosstab is a crosstabulation tool for putdocx like tabulate two-way.
Options:row/column percentages, turn off/on row/columns, missingness, percent % format, table header
(Submitted to SSC should be up soon)

capture program drop putdocxcrosstab
ssc install putdocxcrosstab
sysuse auto , clear
egen pricecat = cut(price), at(0,5000,10000,999999) label
label variable pricecat "Price (categorical)"
tab pricecat foreign
putdocx clear
putdocx begin
putdocxcrosstab pricecat  foreign
putdocxcrosstab pricecat  foreign , norowsum 
putdocxcrosstab pricecat  foreign , nocolsum
putdocxcrosstab pricecat  foreign , norowsum nocolsum


putdocxcrosstab pricecat  foreign , row
putdocxcrosstab pricecat  foreign , col
putdocxcrosstab pricecat  foreign , row nofreq
putdocxcrosstab pricecat  foreign , col nofreq

putdocx save "auto.docx", replace 

Example output:

putdocxcrosstab pricecat  foreign 

putdocxcrosstab pricecat  foreign , norowsum 

putdocxcrosstab pricecat  foreign , nocolsum 

putdocxcrosstab pricecat  foreign , norowsum nocolsum 

putdocxcrosstab pricecat  foreign , row 

putdocxcrosstab pricecat  foreign , col 

(can't post image, only five allowed)

putdocxcrosstab pricecat  foreign , row nofreq 

(can't post image, only five allowed)

putdocxcrosstab pricecat  foreign , col nofreq 

(can't post image, only five allowed)

[Jan Brogger]

putdocxcrosstab pricecat  foreign , col 

putdocxcrosstab pricecat  foreign , row nofreq 

putdocxcrosstab pricecat  foreign , col nofreq 

[jameskb101]

Thanks for providing this. Just what I was after. Can confirm this is now available via ssc install putdocxcrosstab.

One initial problem I encountered was with noROWSum and noCOLSum options. For other users, please note these should be specified in all lowercase i.e. norowsum, nocolsum, as indicated in the example above, but not as shown in the current help file within Stata.

Also, is there any way to fix the gap between the digits and the % symbol? Above it looks like a single space, but in my document this is 4 spaces

Otherwise, very helpful package.

Thanks

James

[Rachel Pearce]

Many thanks! Just what I needed. My only problem is that I wish I had looked here earlier before reinventing the wheel (badly).

Rachel

[Mark Chatfield]

There are quite a few similar commands out there, including: https://www.statalist.org/forums/for...r-a-manuscript

[Rodrigo Badilla]

Do you know how remove or change the grey title?

My language is spanish then this title not help me too much.