| Re: Assigning characteristics of head of household to the entire household [message #1273 is a reply to message #1256] |
Sun, 02 February 2014 19:47  |
Sarah B
Messages: 23
Registered: June 2013
|
Member |
|
|
The good news is that your code looks fine, assuming that you've renamed the household variables hv001 and hv002 to v001 and v002 when you use
merge m:1 v001 v002 using [household level file]
And that you rename the same variables to mv001 and mv002 when you use
merge m:1 mv001 mv002 using [household level file].
The bad news is that you can't do what you're trying to do. As you note, ethnicity wasn't collected in the household questionnaire -- it was only collected for the men and women who were interviewed using the women's and men's questionnaires. Here's the problem: not every household head was an interviewed woman or man. The easiest way to see this is to look in the household (HR) file at the households in which no one was eligible for interview:
ta hv010 hv011
There are 1,635 households in which 0 women and 0 men were eligible for interview. I looked at this briefly and found that
1. In 110 households, the household head did not stay in the household last night and so was ineligible for interview (hv103_01==0)
2. In 786 households, the head of household was not in age range (15-59 for men, 15-49 for women)
3. In 739 households, the head of household was male and in age range but the house was not selected for the male survey (hv027==0)
These are the households that are not matched to any individual respondents.
Further, there are about 2,000 households in which at lease one person listed in the household roster was eligible for interview but the household head was ineligible for one of the 3 reasons listed above. In these households, there will (almost always) be household members listed in the MR and/or IR file, but none of them will be line number 1.
I hope that helps -- please re-post if you have further questions.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
