Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Dropping observations and creating a balanced panel
From
Matthew Krauchunas <[email protected]>
To
[email protected]
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/