Statalist


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

Re: st: How to balance an unbalanced panel data set


From   Kit Baum <baum@bc.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: How to balance an unbalanced panel data set
Date   Thu, 2 Apr 2009 22:23:35 -0400

<>
Christian said

In this example I only want the panel with id 04 with data in all the years, and drop the panels 01, 02 and 03 with a missing value in at least one year for var1. I also want to drop the panel 05 with doesn't have values in all years.

drop if mi(var1) [ which could be if mi(var1, var2, .... varn), but they must be explicitly named)
by id: keep if _N == 5


Kit Baum   |   Boston College Economics & DIW Berlin   |   http://ideas.repec.org/e/pba1.html
An Introduction to Stata Programming | http://www.stata-press.com/books/isp.html
   An Introduction to Modern Econometrics Using Stata  |   http://www.stata-press.com/books/imeus.html



*
*   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   |   What's new   |   Site index