Question

How to analyse household and household member combined datasets?

Answer 1

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 ----- Original Message ----- From: "Fredrik Wallenberg" <[email protected]> To: <[email protected]> Sent: Sunday, May 23, 2004 6:47 AM Subject: Re: st: Questions on Merging Two Data sets(Individual and Household data) > On Sat, 22 May 2004 02:05:53 -0700, Lok Wong <[email protected]> wrote: > > > > Hi there, > > > > I have two data sets: one individual, another household. The observations in > > household data set are less than those in individual one > > because household consists of more than one individual. Now, I want to merge > > this two data sets. What should I do? In the invidiual data, > > there are two variables "household id" and "number in the household" which > > could be used to identify invididuals uniquely. In the household > > data, there is one variales "household id". > > > > The first question is whether you want to make your analysis at the > individual level or at the household level. The first is straight > forward. Sort (and save) the household level data and then use and > sort the individual data. After that you use > > merge -hhid- using -hhdata- > > This will add the hhdata to each individual observations with > individuals in the same household having the same household level > variables. The issue here is one of weighting but someone with a > better grasp of statistics/econometrics can probably provide you with > an appropriate correction. >