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

[Kit Baum <baum@bc.edu>]

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