Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Dropping observations and creating a balanced panel


From   Matthew Krauchunas <krauchunasms@mymail.vcu.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: Dropping observations and creating a balanced panel
Date   Tue, 27 Jul 2010 17:52:10 -0400

Hello,

I am studying nursing homes (2002-2004 & 2006-2008) and I have a two
part problem that I need to solve in order to create a balanced panel.
 First, I have nursing homes that have closed or changed ownership
(chow) during my study period.  I need to  drop all the observations
in each of the panels (panel identifier is the oshpd_fac_no) if there
was a chow or closure?  Second, I have nursing homes that opened after
2003 and therefore I would not have all the observations for these
panels.  How can I identify and remove these panels as well?  Does
anyone have any ideas?


oshpd_fac_no    year    chow    closure
206010734    2002    0    0
206010734    2003    0    0
206010734    2004    0    0
206010734    2006    0    0
206010734    2006    1    0
206010734    2008    0    0
206010744    2002    0    0
206010744    2003    0    0
206010744    2004    0    0
206010744    2007    0    0
206010744    2008    0    0
206010747    2002    0    0
206010747    2003    0    0
206010747    2004    0    0
206010747    2006    0    0
206010747    2007    0    0
206010747    2008    0    0

Thank you,
Matt
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   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   |   Site index