clear
input hhid number
1 1
1 2
1 3
1 3
2 1
2 2
3 1
4 2
end
gen tag = 1 if number == 3
bysort hhid (tag): replace tag = tag[_n-1] if tag == .
keep if tag == 1
drop tag
l
Scott
On Fri, Jun 27, 2008 at 4:32 PM, Maghais SK <[email protected]> wrote:
>
> 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)
>
*
* 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/
