Cornelia Zekweld
> > --------------------------------------------------------------
> > | 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
> > --------------------------------------------------------------
> >
>
> 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.
Sorry, I didn't make myself clear. I understand how
averages < 0.5 arise. What I said was that I didn't know what
such averages _entailed_ for -table-. In fact, I am not
aware that they entail anything for -table-.
-table- won't accept frequency weights which are not
integers, so I still don't understand what you are doing
with -table-. Perhaps someone else does.
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/
