Statalist


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

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


From   "Howrey, Bret T." <bthowrey@UTMB.EDU>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: how to retain a complicated subset of data
Date   Fri, 27 Jun 2008 16:46:34 -0500

try using -reshape- making it "wide" on the hhid, then drop households where child==0 or .



________________________________________
From: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] On Behalf Of Maghais SK [maghais@yahoo.com]
Sent: Friday, June 27, 2008 4:32 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: how to retain a complicated subset of data

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/

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