st: RE: count

["Herrnstadt, Evan" <Herrnstadt@rff.org>]

Tina,

Try this:

sort year
by year: gen count = _N

Best,
Evan Herrnstadt

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Tina
Hernandez-Boussard
Sent: Friday, October 12, 2007 4:37 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: count

Hi All,

I am trying to get a count of procedures at a hospital by year and store
this number.

In SAS I can do this:

proc freq  data=tmp noprint;   tables year * hospid / out=t_tmp;   run;


I am trying to use count in stata, but I am unable to store count of
hospitals by year.  I get the count of hospitals by year with this
command

by hospid: count if year == 1999

Any help??

Thanks

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

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