The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » husbands to their wives
Re: husbands to their wives [message #16402 is a reply to message #16317] Tue, 08 January 2019 08:46 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3051
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


 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Linking variables from SA 1998 HR, PR & IR files to Adult Health respondents
Next Topic: How to merge PR & CR files in R
Goto Forum:
  


Current Time: Mon May 6 12:58:22 Coordinated Universal Time 2024