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

RE: st: count (Stata 8)


From   "louis boakye-yiadom" <louisby@hotmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   RE: st: count (Stata 8)
Date   Tue, 10 May 2005 15:34:53 +0000

I think the -collapse- command can be useful in doing this.

Louis



--------------------


From: Heather Gold <heg2001@med.cornell.edu>


Dear Listers -

I know this must be simple, but something eludes me.
I have a data set of subjects (cases and non-cases) by year and am trying to calculate a prevalence per year, ie, [cases/(cases+noncases)].
ie, data look like this:
id year dxflag
1 1995 1
1 1996 0
1 1997 0
2 1995 0
2 1996 1
...

I found that I can write
by year: count if dxflag==1
or
by year: count

and these return number of cases in the first line, and count of total population in the second line, just as I want.
But what I need are these values as scalars, so I can create a prevalence per year. In the Stata 8 help/manual it says that -count- saves the scalar of number of observations in r(N), but I can't seem to get this number to appear. Do I actually have to write a program to calculate this? And how does the "by year" part fit in...?

Thanks for your help,
Heather

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