Statalist


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

Re: st: -merge- which one would make sense?


From   "Friedrich Huebler" <fhuebler@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: -merge- which one would make sense?
Date   Wed, 21 May 2008 10:56:47 -0400

Nirina,

First, please include the Stata commands you used.

Second, how do you identified husbands and wives? A married man and a
married woman living in the same household are not necessarily married
to each other.

Friedrich

On Wed, May 21, 2008 at 8:29 AM, Nirina F <fstata@gmail.com> wrote:
> Hello,
> I have a microdataset with 5000 individuals. In the data, I have
> household questionnaires and individual questionnaires together, pid,
> hhid.
>
> I did the following scenarios and now I'm lost:
>
> 1- I separated the household(hh) questionnaire from the individual(i)
> questionnaires.
> I split the remaining individual questionnaires into married female
> and  married male renamed all variables accordingly.
> Then I merged the male and female because they are husband and wife by
> their household id. I had 2000 households
> Afterward, I merged the hh questionnaire. I end up back to 5000 observations.
>
> 2- I kept the original dataset and just split into two datasets
> married female and  married male which I merged afterward to have
> husband and wives. I arrive at 2000 observations.
> When I assert if household information from husband and wife is the
> same, almost 90% of the observation is false.
>
> What do you think I should do? Which one of the two should make sense?
> Thank you very much from your help.
> Nirina
*
*   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