The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Mortality » Maternal Mortality (Two SPSS files)
Re: Maternal Mortality [message #27506 is a reply to message #27494] Thu, 24 August 2023 13:58 Go to previous messageGo to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 888
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

Thanks for refreshing my memory. The file "LBSR7AFL.dta" has one record for each sibling of the women in the IR file, LBIR7AFL.dta. You say you want to merge with the PR file.

It sounds like you want to attach, to the siblings, information about the household that the respondent lives in. You can do that, but the siblings usually live (or lived, if they have died) in different households than the respondent. You should be careful in how you interpret any associations. To do such a merge, you would open the PR file, reduce it to one record per household (keep if hv101==1), reduce it to the household-level variables (keep hv0* hv2*), and then match hv001 hv002 in this file with v001 v002 in the SR file. I do not know the SPSS code to do that, but it should not be difficult.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Child mortality
Next Topic: DHS.rates
Goto Forum:
  


Current Time: Mon Nov 25 15:27:48 Coordinated Universal Time 2024