Re: husbands to their wives [message #16402 is a reply to message #16317] |
Tue, 08 January 2019 08:46 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Bridgette-DHS
Messages: 3139 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
There are two issues here. The first issue is what you asked before, about linking husbands and wives. Your procedure, using v034, is based solely on the woman's specification of her husband. DHS normally requires that this specification also matches with the man's specification of his wife. The latter was not included in the men's survey in Pakistan, and that is the reason why a couples' file was not included among the standard recode files.
You can probably do a very good job of matching couples in Pakistan using just the woman's response, and your Stata lines do this correctly. However, the reason why you get few matches is that the men's questionnaire was only administered in a subsample of households. There are 13,558 women in the IR file but only 3,168 men in the MR file. Your procedure gives 2,798 matches. That's the best you can possibly do in terms of getting couples.
The second issue is how to get the number of infant deaths per woman. An infant death is given by b7<12 for each of the births in the birth history. The following lines will do this in Stata, after you have opened the IR file. You will want to relate the number of infant deaths to the number of births, which is v201.
rename b*_0* b*_*
local li=1
quietly while `li'<=20 {
gen infant_death_`li'=0
replace infant_death_`li'=1 if b7_`li'<12
local li=`li'+1
}
egen infant_deaths=rowtotal(infant_death_*)
tab infant_deaths
|
|
|