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

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

[Message index]

		Denominator for reproductive health variables By: nasser.ebrahim9@gmail.com on Wed, 21 June 2023 22:59
		Re: Denominator for reproductive health variables By: Shireen-DHS on Thu, 13 July 2023 10:06
		Re: Denominator for reproductive health variables By: Shireen-DHS on Thu, 13 July 2023 12:29

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 18 13:12:25 Coordinated Universal Time 2025