The DHS Program User Forum: Reproductive Health » Denominator for reproductive health variables

Home » Topics » Reproductive Health » Denominator for reproductive health variables (Philippines 2022 data set)

Show: Today's Messages :: Show Polls :: Message Navigator

Denominator for reproductive health variables [message #27149]

Wed, 21 June 2023 22:59

nasser.ebrahim9@gmail.com is currently offline

nasser.ebrahim9@gmail.com
Messages: 3
Registered: November 2018

Member

Dear forum members,

I am analyzing a dataset from the Philippines 2022 on reproductive health services. For example on page 156 table 9.3.1 the total number for ANC is 2759 for livebirths and stillbirths. I am getting a larger denominator and couldn't figure out what mistake I am making. Which variable filter should I use? I was trying to use M80 but the denominator was still different from what is reported. I am using SPSS, the module for complex data, and applied weight and design effects. Your help is highly appreciated.

Report message to a moderator

Re: Denominator for reproductive health variables [message #27288 is a reply to message #27149]

Thu, 13 July 2023 10:06

Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA

Senior Member

Hello,

Thank you for your question. We have updated our code for DHS8 surveys on our code share library on GitHub but only in Stata currently. Updates to SPSS and R are planned next year. However, please check the Stata code to get the general logic for your analysis. If you don't have Stata you can still open the do files as text in notepad. The SPSS code that has not yet been updated is found here: https://github.com/DHSProgram/DHS-Indicators-SPSS/tree/maste r

For Chapter 9 the updated Stata code can be found here: https://github.com/DHSProgram/DHS-Indicators-Stata/tree/mast er/Chap09_RH/DHS8
The code is organizing with a main file that calls out the other do files. In the main file you will see for the ANC indicators you need to use the NR file and only keep births in the last two years that were live births or stillbirths as follows:

keep if p19 < 24 & (m80 == 1 | m80 == 3)

Then you can run the ANC code to produce all the ANC indicators. You can check the SPSS code for this but again there have been updates so you can start with this code and make the DHS8 updates yourself using the Stata updates as a guide: https://github.com/DHSProgram/DHS-Indicators-SPSS/tree/maste r/Chap09_RH

Then to match table 9.3.1, you need to select women that have had any ANC visit. There is a variable in the code for that called anyanc.

Then for the three denominators in table 9.3.1 you can create a filter variable for each of the subpopulations:
1. Live births
gen select1 = m80==1

2. Stillbirths
gen select2 = m80==3

3. Live births and stillbirths: this is a little tricky because if you need to keep last live birth or last still birth.
If a woman had a live birth and a stillbirth in the last two years, then you want to just keep the last live birth (see the footnote in the table). This can be done with the following selection :
select3= (_n == 1 | caseid != caseid[_n-1]).

I believe the SPSS equivalent to this is as follows but please check:
COMPUTE select3= ($casenum = 1 OR caseid <> LAG(caseid)).
EXECUTE IF select3.

So for example to tabulate the blood pressure variable coded in the ANC do file for table 9.3.1 for live births and stillbirths, you would do the following.

gen wt=v005/1000000
tab rh_anc_bldpres if select3==1 & ancany==1 [iw=wt]

For table 9.3.2 you would remove ancany==1:

tab rh_anc_bldpres if select3==1 [iw=wt]

I hope these instructions are clear.

Best,

Shireen Assaf
Senior Research Manager
The DHS Program

Report message to a moderator

Re: Denominator for reproductive health variables [message #27289 is a reply to message #27288]

Thu, 13 July 2023 12:29

Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA

Senior Member

Hello,

Adding to my response below, I believe for the live birth and still births selection in SPSS (#3), you can use:
Select if (caseid <> lag(caseid))

Best,
Shireen Assaf
The DHS Program

Report message to a moderator

Previous Topic:	Ever use of contraceptive methods (NDHS 2022)
Next Topic:	Socially Marketed Brands

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 26 19:06:57 Coordinated Universal Time 2024