Hello
I have a dataset on households of parents with kids, and parents without kids. I only want to keep the data of parents and their kids. For instance in the example below, I wish to keep only the first household(parents with 2 kids) and drop the other households. Is there any easy way of doing this? The keep and drop command works for individual observations. But I need to keep all the household members if the household has kids. Thank you
HHID Number in household
001 1 (father)
001 2 (mother)
001 3 (child)
001 3 (child)
002 1 (father)
002 2 (mother)
003 1 (father)
004 2 (mother)
-Mag
*
* 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/