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

RE: st: Questions on Merging Two Data sets(Individual and Household data)


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Questions on Merging Two Data sets(Individual and Household data)
Date   Sun, 23 May 2004 18:14:37 +0100

You don't _have to_ do it this way. 
Suppose that household data are repeated across
individuals in each household. Then you can 
tag just one observation for each household 
with e.g. 

. egen hh = tag(hhid) 

and thereafter work 

. ... if tag 

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

> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of 
> R.E. De Hoyos
> Sent: 23 May 2004 18:05
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: Questions on Merging Two Data sets(Individual and
> Household data)
> 
> 
> Lok,
> 
> As Fredrik mentioned, the best way to -merge- the two dataset 
> is by taking
> the individual one as the "master" and the household as the 
> "using" one.
> This procedure will ensure that all the information will be 
> in a single
> dataset. From my point of view you should use this dataset at 
> the individual
> level even if your unit of analysis is the household.
> 
> If you prefer to work only with household data you have to 
> -collapse- the
> individual dataset into means, sums, etc. before merging it with the
> household one. In this last case it wont matter which dataset 
> you take as
> the "master or the "using" one.
> 
> Rafa
> 

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