Statalist


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

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


From   "Nirina F" <fstata@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: -merge- which one would make sense?
Date   Thu, 22 May 2008 06:02:07 -0400

Dear Friedrich,

Thank you again for responding.

My problem is that I do not have a relationship to household head but
I only have the line number of each respondent.

Nirina

On 5/21/08, Friedrich Huebler <fhuebler@gmail.com> wrote:
> Nirina,
>
> Let's say we have the household below. Assume that the two
> 40-year-olds are married and that the 50-year-old man is married to
> the 30-year-old woman. Your code merges the 50-year-old man with the
> 40-year-old woman and the 40-year-old man with the 30-year-old woman,
> which would be wrong. Given only the data below it is not possible to
> identify married couples. You need something like line number of the
> spouse.
>
> hhid sex age maritalstatus
> 1    1   50  1
> 1    1   40  1
> 1    2   40  1
> 1    2   30  1
> 1    1   5   0
> 1    2   3   0
>
> It may help if you read two Stata FAQs about data on families.
>
> http://www.stata.com/support/faqs/data/members.html
> http://www.stata.com/support/faqs/data/anyall.html
>
> Friedrich
>
> On Wed, May 21, 2008 at 6:52 PM, Nirina F <fstata@gmail.com> wrote:
> > Dear David and Friedrich,
> >
> > You are right, within one household, there are the wife and husband,
> > children and other people like mother of husband.
> > This is the code I used originally:
> >
> > Using the original data:
> >
> > keep if sex==1 & maritalstatus==1
> > foreach x of var * {
> >        rename `x' h_`x'
> > }
> >
> > gen hid=h_hhid
> > sort hid
> > save  husband.dta
> >
> > keep if sex==2 & maritalstatus==1
> > foreach x of var * {
> >        rename `x' w_`x'
> > }
> > gen hid=w_hhid
> > sort hid
> > save wife.dta
> > merge using husband.dta
> >
> > I also tried to include line number of respondent after each -keep-
> > but it does not give me the answer where answers from husband on hh
> > characteristics should match wive's.
> > I am looking into details of what I have.
> > thank you,
> > nirina
> >
> >
> >
> > On 5/21/08, Friedrich Huebler <fhuebler@gmail.com> wrote:
> >> Nirina,
> >>
> >> 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.
> >>
> >> Friedrich
> >>
> >> On Wed, May 21, 2008 at 10:56 AM, Friedrich Huebler <fhuebler@gmail.com> 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 <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/
>
*
*   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