Re: st: three-way tables, exporting to tex

[Johannes Geyer <JGeyer@diw.de>]

Here is one option (maybe not very elegant but does what you want):

******************************************************
clear
webuse union
table year union south, c(freq mean grade)
***

egen cats = group(south union)

* initialize matrix a1
qui sum year
qui tabstat grade if year == `r(min)', by(cats) save stats(N mean)
qui tabstatmat a1
matrix a1 = a1'


qui sum year
forvalues u = `=`r(min)'+1'/`r(max)' {
        di "`u'"
        capture {
                qui tabstat grade if year == `u', by(cats) save stats(N 
mean)
                qui tabstatmat a
                matrix a`u' = a'
                matrix a1 = a1\a`u'
        }
}

esttab matrix(a1)
****************************************************************************************

Johannes


----------------------
Johannes Geyer
Deutsches Institut für Wirtschaftsforschung (DIW Berlin)
German Institute for Economic Research 
Department of Public Economics
DIW Berlin
Mohrenstraße 58
10117 Berlin
Tel: +49-30-89789-258

owner-statalist@hsphsun2.harvard.edu schrieb am 20/03/2009 18:35:03:

> <>
> 
> -tabout- seems unable to do that. -table- can replace the current 
> dataset, but what it leaves behind is not directly amenable to 
> translation to tex. 
> 
> Seems you either have to -egen souunion=group(south union)- and then
> work on a two-way table or look at custom solutions as in 
> Baum(2009), chap. 10.3, http://www.stata-press.com/books/isp.html ...
> 
> HTH
> Martin
> -------- Original-Nachricht --------
> > Datum: Fri, 20 Mar 2009 17:45:47 +0100
> > Von: Richard Ochmann <rochmann@diw.de>
> > An: statalist@hsphsun2.harvard.edu
> > Betreff: st: three-way tables, exporting to tex
> 
> > Hi,
> > 
> > how would you export a three-way table to a .tex document?
> > 
> > I would like to produce a summary table for a continuous variable over 

> > three categorical variables. Cells shall contain means as well as 
> > frequencies.
> > I found I can nicely do that with -table- (find my code below). Now I 
have
> > a hard time exporting the resulting table to a .tex document that I 
can 
> > further edit in LaTeX.
> > I tried with user-written programs like -estout- and -tabout-. While 
> > -tabout- brings me close, I didnt figure out how to do a three-way 
table 
> > there.
> > While this problem is certainly easily worked-around producing 
separate 
> > two-way tables conditioning on the third variable and somehow 
combining 
> > them, I would be happy to have a one-step solution here.
> > 
> > thanks for ideas!
> > 
> > Stata 10, WinXP
> > 
> > best, rich
> > 
> > ***
> > clear
> > webuse union
> > table year union south, c(freq mean grade)
> > ***
> > 
> > *
> > *   For searches and help try:
> > *   http://www.stata.com/help.cgi?search
> > *   http://www.stata.com/support/statalist/faq
> > *   http://www.ats.ucla.edu/stat/stata/
> 
> -- 
> Martin Weiss
> Hackersteigle 3
> 72076 Tübingen
> 00497071/793535
> 00491784597218
> 
> Aufgepasst: Sind Ihre Daten beim Online-Banking auch optimal geschützt?
> Jetzt absichern: https://homebanking.gmx.net/?mc=mail@footer.hb
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/