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

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

From   "Friedrich Huebler" <>
Subject   Re: st: -merge- which one would make sense?
Date   Wed, 21 May 2008 14:31:03 -0400


Further to my earlier question, I assume you have a variable that
identifies the marital status of each household member. Your
description is not clear but from what I understand you selected men
and women whose marital status is "married" and then assumed that a
married man and a married woman in the same household are each other's
spouse. Is this what you did? What did you do with households with
more than one married man and woman?

Other possibilities are that you have a variable with the line number
of each household member's spouse or a variable that describes the
relationship to the household head. Either way, we need more
information in order to help you.


On Wed, May 21, 2008 at 10:56 AM, Friedrich Huebler <> wrote:
> 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 <> 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:

© Copyright 1996–2023 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index