Table 1 for manuscript

[nawar han]

Hello all, I was wondering if it is possible with Stata to generate a Table 1 of a manuscript with a single command.
I have multiple variables ( continuous and categorical).
I want to compare all these variables according to a 2 category variable.
If possible would like to have only one table and to have all the row percentage for categorical variables and mean or median for continous ones.

Is it possible?
I tried the tabmult command but gave me a .xls file that wasn't readable

tabmult, cat(sex CDCC_TOTAL) cont(age) by (CNT4) row m save(table1.xls)

Thank you for your help

[Andrew Lover]

Two commands do exactly that: -table1- and -basetable- (both downloadable from SSC).

[Nathan E. Fosse]

Thanks, Andrew for the two recommended packages. As a result of my ingorance, I've often either run subgroup statistics using fsum in the SSC archive, which is still fine, but without the p-values. Then I'd I'd export to excel each of the stat results using branching if/else loops, etc. Far too much trouble. Thanks for these!

[Andrew Lover]

Indeed- I cringe to think of the number of kludges I've built, only later to find out that a package already exists!