A table displaying one numerical and two categorial variables

[Martin Semmelberg]

Hello,
I want to create a table that displays earnings for each sex over the years.
I tried a couple different lines but never got it right, I always get multiple tables instead of one.
How do you do it so that its in one table?

[Ken Chui]

See the examples between pages 2 and 3 here: https://www.stata.com/manuals/rtable...df#rtableintro

[Attaullah Shah]

You can use the table command inside asdoc, or even better asdocx to do this. See this example

ssc install asdoc
sysuse nlsw88

* add variable year for this example
gen year = mod(_n, 10)+2000
asdocx table year race, c(mean wage) replace

[Nick Cox]

#1 leaves vague what you want to see for earnings. But many commands will help. To see mean, SD and count:

. sysuse auto, clear
(1978 automobile data)

. tab foreign rep78 , sum(mpg)

[Martin Semmelberg]

#1 leaves vague what you want to see for earnings. But many commands will help. To see mean, SD and count:

. sysuse auto, clear
(1978 automobile data)

. tab foreign rep78 , sum(mpg)

Thanks that works. Is this table exportable to latex ?

[Nick Cox]

I am not a good person to advise on that,

1. Clearly many people want output as LaTeX or HTML or whatever and several commands offer something of the kind.

2. That could be really important if, perish the thought, you needed many, many such tables. In some fields there is a ritual of massive appendices with lots of tables. How often does anybody read them?

#2 is never what I need and #1 is rarely what I need — I am far more likely to produce tables as graphs. I have never tried any of the commands on offer. It seems a lot simpler to write your own mark-up directly.

Any way, sorry: you need better advice from others.

[Rich Goldstein]

a start on this can be found at

help collect style tex

[Bjarte Aagnes]

table foreign rep78 , stat(mean mpg) stat(sd mpg) stat(freq)

collect style cell result[mean sd], nformat(%4.1f)

collect export test.tex, replace

[Martin Semmelberg]

table foreign rep78 , stat(mean mpg) stat(sd mpg) stat(freq)

collect style cell result[mean sd], nformat(%4.1f)

collect export test.tex, replace

Thanks it works