The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Mortality » Maternal Mortality (Two SPSS files)
Maternal Mortality [message #27457] Wed, 16 August 2023 00:15 Go to next message
Isaac Yah is currently offline  Isaac Yah
Messages: 8
Registered: May 2023
Member
I am about to do analysis of data from the Liberia Demographic and Health survey for my study. I have two SPSS files: one that I retrieved by myself and the one that you created for me. These files have information on them that addressed my variables. Is it possible to get help to merge these SPSS files to be able to do the analysis?
Thanks,
Isaac Yah
Re: Maternal Mortality [message #27484 is a reply to message #27457] Mon, 21 August 2023 12:59 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 911
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

Unfortunately I do not use SPSS and cannot help with such a merge. But can you give me the name and date for the file I created for you? And is the other file a standard recode file from the website?
Re: Maternal Mortality [message #27494 is a reply to message #27484] Tue, 22 August 2023 01:46 Go to previous messageGo to next message
Isaac Yah is currently offline  Isaac Yah
Messages: 8
Registered: May 2023
Member
Hello,
The file was created June 1, 2023, or about that time and was name LBSR7AFL. The other file was the standard recoded one from the website named LBPR7AFL.
Thanks
Re: Maternal Mortality [message #27506 is a reply to message #27494] Thu, 24 August 2023 13:58 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 911
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.
Re: Maternal Mortality [message #27615 is a reply to message #27506] Mon, 11 September 2023 23:42 Go to previous message
Isaac Yah is currently offline  Isaac Yah
Messages: 8
Registered: May 2023
Member
Thanks for your response and trying to help. The suggestions are difficult for me so, I made another request in the Forum to see if the issue can be resolved. I sent a number of questionnaires from the women file, requestion for a SPSS file. I hope that is possible. Thank you very much.
Isaac
Previous Topic: Child mortality
Next Topic: DHS.rates
Goto Forum:
  


Current Time: Thu Dec 26 09:36:05 Coordinated Universal Time 2024