 |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: -merge- which one would make sense?
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
information in order to help you.
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/