The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Women's-level variables (Pregnancies of 7 or more months (Sample Size))
Women's-level variables [message #27413] Wed, 09 August 2023 13:06 Go to next message
Shadrick Kayeye is currently offline  Shadrick Kayeye
Messages: 13
Registered: February 2023
Dear Team,

I am using the Zambia 2018 DHS dataset for my analysis using the IR file. I have managed to re-produce Table 8.4 in line with 2018 ZDHS report, particularly the stillbirth variable (119) and the Number of pregnancies of 7+ months' duration (9,869).The challenge now is that I am having trouble determining how to limit my sample size to the totpreg7m (9,869), which represents women who had pregnancies that lasted for 7 or months in the five years preceding the survey. Your help will be greatly appreciated. I am using SPSS Version 23 for my analysis.

Thanks and greatly appreciate your feedback in anticipation.

Re: Women's-level variables [message #27464 is a reply to message #27413] Wed, 16 August 2023 17:15 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 697
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

Table 8.4 in the pre-DHS8 surveys is tricky. You might think that the "Number of pregnancies of 7+ months duration" would be simply the number of births in the KR file plus the number of stillbirths, but it is not. The attached Stata program "perinatal_mortality_do_16Aug2023.txt" (a text file) combines information in the calendar and the birth history to get all of the numbers in table 8.4. It has a modular structure and several comments to help with the logic. In DHS8 surveys, with pregnancy histories, the table is much easier to construct. The GitHub programs also include table 8.4 but this is a stand-alone program that pre-dates the GitHub version.

Even with the comments, it may be difficult to convert this Stata program to SPSS. I suggest that you try to find the SPSS syntax within the SPSS GitHub programs for chapter 8 ( r/Chap08_CM).
Previous Topic: Full immunization coverage in Kenya 2022
Next Topic: How to generate day of birth of children (which day in the month)?
Goto Forum:

Current Time: Tue Apr 23 19:54:44 Coordinated Universal Time 2024