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