Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: RE: Summarising multiple tabulations in one table


From   Lee Sieswerda <Lee.Sieswerda@tbdhu.com>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: Summarising multiple tabulations in one table
Date   Tue, 10 Dec 2002 09:43:59 -0500

If I'm understanding your data structure correctly, you could use -tabm-
with the -trans- and -col- options. Currently, -tabm- is not by-able, so you
would need to use -if-. As in:

foreach n in 0/10 {
	tabm agekst* if cohort==`n', trans col
}

Best,
Lee

Lee Sieswerda, Epidemiologist
Thunder Bay District Health Unit
999 Balmoral Street
Thunder Bay, Ontario
Canada  P7B 6E7
Tel: +1 (807) 625-5957
Fax: +1 (807) 623-2369
Lee.Sieswerda@tbdhu.com
www.tbdhu.com


> -----Original Message-----
> From:	Nick Cox [SMTP:n.j.cox@durham.ac.uk]
> Sent:	Tuesday, December 10, 2002 7:27 AM
> To:	statalist@hsphsun2.harvard.edu
> Subject:	st: RE: Summarising multiple tabulations in one table
> 
> Stephen P. Jenkins
> >
> > I have a large number of categorical variables named
> > "agekst*" (where *
> > are integers), where each variable is coded using the same frame (4
> > categories: 0,1,2,3). The variables summarise the number of
> > children a
> > woman has had by each age (the elements of *). I would like
> > to tabulate
> > the percentages in each agekst* category -- these are
> > straightforward
> > to derive using -tabulate- and e.g. -foreach-. But how can
> > I report the
> > percentages in a summary table in which there is a column for each
> > variable and the rows are the col percentages? (Or, alternatively,
> > there are rows for each variable, and the col percents on
> > agekst* form columns.)
> > I also know each woman's birthdate, summarised in a categorical
> > variable named "cohort" (8 categories), and it would be
> > nice to able to
> > repeat the summary table for each value of cohort.
> > [I've looked at -collapse-, -table-, and their relatives, and none
> > appear to be what I require.]
> > Suggestions please!
> > In essence I am asking how I might use Stata to reproduce
> > output that the SPSS REPORT command produces.  Here follows an
> example
> > of what SPSS can do:
> >
> > SPSS Code & Output
> > ------------------
> > sort cases by cohort.
> > report /format= colspace(1) nolist margins(1)
> >      /variables= cohort agekst20 agekst25 agekst30 agekst35
> > agekst40 agekst45 (6)
> >      /break= cohort
> >     /summary=percent(0,3).
> >
> > ************output***************************************
> >   COHORT   AGEKST20 AGEKST25 AGEKST30 AGEKST35 AGEKST40 AGEKS45
> >      .00
> >           0   92.1     64.3     40.2     27.5     22.0   21.1
> >           1    6.7     25.0     33.7     30.4     23.1   21.6
> >           2    1.2      8.7     20.5     27.4     32.5   32.9
> >           3     .0      2.0      5.7     14.7     22.4   24.4
> >    10.00
> >           0   95.0     67.6     36.6     22.5     20.6   20.1
> >           1    4.8     23.1     32.2     26.7     23.0   22.7
> >           2     .3      6.8     21.3     29.4     29.3   28.3
> >           3     .0      2.5      9.9     21.4     27.1   28.9
> 
> I guess your main way forward is -reshape- so that
> the agekst* are all stacked into one variable.
> 
> Nick
> n.j.cox@durham.ac.uk
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index