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

st: RE: RE: tabulating frequency records


From   "Zekveld, Cornelia" <c.zekveld@imperial.ac.uk>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: tabulating frequency records
Date   Thu, 10 Jul 2003 16:27:57 +0100

> --------------------------------------------------------------
>                                          |       agecat
>                                AgentName | 16-39  40-64    65+
> -----------------------------------------+--------------------
>                                A........ |     1      2      .
>                                 C....... | 9,999      1      .
>                                   C..... |     .      1  9,999
>                            I............ |     .  9,999      .
>                                   N..... |     1  9,999      .
>                             O........... |     1      2  9,999
> --------------------------------------------------------------
>

Nick,

I will have a look at the tabcount command - thanks.

The reason why the avg. freq. <0.5 is that it is annual averages where e.g.,
over a period of 5 years there are only 2 occurrences of the disease and so
dividing this by 5 gives you 0.4 per year - which then is rounded to zero.

This causes another problem in that if I add col or row to get totals by
age-group, the zero's of course do not add anything to the totals (where
actually it was 0.4). Having say 3 such entries, the overall total should
increase by 1.2 (rounded to 1), but now I lose this.  

I have an immense number of tables to produce, otherwise I could have worked
out the annual average totals from the period-specific totals.

Regards,
Cornelia

*
*   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