[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"Nick Cox" <n.j.cox@durham.ac.uk> |

To |
<statalist@hsphsun2.harvard.edu> |

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

Date |
Tue, 10 Dec 2002 12:27:28 -0000 |

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/

**Follow-Ups**:**Re: st: RE: Summarising multiple tabulations in one table***From:*"Stephen P. Jenkins" <stephenj@essex.ac.uk>

**References**:**st: Summarising multiple tabulations in one table***From:*"Stephen P. Jenkins" <stephenj@essex.ac.uk>

- Prev by Date:
**st: RE: more informative names of dummy vars** - Next by Date:
**Re: st: more informative names of dummy vars** - Previous by thread:
**st: Summarising multiple tabulations in one table** - Next by thread:
**Re: st: RE: Summarising multiple tabulations in one table** - Index(es):

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