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

st: RE: Summarising multiple tabulations in one table


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/



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