Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: how to retain a complicated subset of data


From   "Scott Merryman" <scott.merryman@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: how to retain a complicated subset of data
Date   Fri, 27 Jun 2008 16:59:35 -0500

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 <maghais@yahoo.com> 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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index