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
[email protected]
www.tbdhu.com
> -----Original Message-----
> From: Nick Cox [SMTP:[email protected]]
> Sent: Tuesday, December 10, 2002 7:27 AM
> To: [email protected]
> 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
> [email protected]
>
> *
> * 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/
