Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: [Fwd: gen a between houshold id]


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: [Fwd: gen a between houshold id]
Date   Wed, 24 Mar 2004 16:18:48 -0000

See if this helps: 
http://www.stata.com/support/faqs/data/members.html

Nick 
n.j.cox@durham.ac.uk 

> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Hans J.
> Baumgartner
> Sent: 24 March 2004 16:09
> To: statalist
> Subject: st: [Fwd: gen a between houshold id]
> 
> 
> Dear Statalist,
> 
> Can anybody help me to generate a new variable that indicates the 
> household of the parents. To clarify my data:
> 
> persnr    sex    V05001    vnr   v_hh
> 1          m       1        .      .                
> 2          f       1        .      .                
> 3          f       1        1      1          
> 4          f      11        1      1            
> 
> persnr is a person identifier (1 = the father, 2 = the 
> mother, 3 = the 
> daughter that lives with the parents and 4 = the daughter 
> that lives in 
> another household).
> vnr identifies the persnr of the father.
> 
> I would like to generate a new variable v_hh that identifies the 
> houshold id (V05001) of the father. It is easy for the daughter that 
> lives with her parents but I find it quite difficult to generate the 
> between household link with the daughter that does not live with her 
> parents.
> 
> I thus constructed a loop that is copy/pasted below. However, 
> I do have 
> 21,000 obs. and I do have to run the loop twice, i.e. for 
> both parents, 
> which takes more than 3 hours.
> 
> Can anybody help me to generat faster between household links?
> 
> And to make thinks even more complicated. I have more than two 
> generations in my data, that is, motherid and fatherid does not 
> necessarily be missing.
> 
> I appreciate all comments.

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