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

 From David Bell <[email protected]> To "[email protected]" <[email protected]> Subject Re: st: -merge- which one would make sense? Date Thu, 22 May 2008 08:56:02 -0400

Nirina-

I am assuming that there are only two persons in a household for whom maritalstatus==1 (no married grandmother-grandfathers). If so, you don't need to save and merge. You can just do -keep if maritalstatus==1-. At this point sex identifies spouses (unless you have any same-sex marriages). If you have multiple marriages within a household, you would need to do something to distinguish them, for example giving each marriage a different variation on the original hhid.

The essential question for what to do depends on what sort of analyses you intend. Clearly, you can analyze the married study participants as individual cases; you would probably want to use -, cluster(hhid)- options to adjust variances for within household similarities.

If you want to do dyadic analyses (husband's values affect wife's and vice versa), you need to do something as the following:
***
sort hhid sex /* So husbands and wives are in the same order in each family */
by hhid: gen spouseVar = ownVar[_n+1] if sex==1
by hhid: replace spouseVar = ownVar[_n-1] if sex==2
***

Hope this helps.
Dave
====================================
David C. Bell
Professor of Sociology
Indiana University Purdue University Indianapolis (IUPUI)
(317) 278-1336
====================================

On May 22, 2008, at 6:02 AM, Nirina F wrote:

```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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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

Friedrich

On Wed, May 21, 2008 at 10:56 AM, Friedrich Huebler <[email protected] > 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 <[email protected]> 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/
```
```*
*   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/
```