The DHS Program User Forum: Mortality » Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016

Home » Topics » Mortality » Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016

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

Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #22422]

Wed, 10 March 2021 20:33

Melese
Messages: 17
Registered: August 2019

Member

Dear DHS expert, greetings. As you know DHS collects data within 5-7 years before the survey. I have calculated the pregnancy related maternal mortality for all the ETHIOPIA DHS surveys (2000-2016)using your guidelines. Dear expert, I want to calculate the estimates for each year preceding the survey. i.e. for each year that is included in the survey preceding the study. For example: for the EDHS 2016, this mortality is calculated for the deaths in 7 years preceding this survey (since 2010). I want to calculate the estimates for each year 2010-2016. Which variable/s should I use, please? I need your help.
Kindest Regards
Melese

Report message to a moderator

Re: Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #22435 is a reply to message #22422]

Thu, 11 March 2021 15:54

Bridgette-DHS
Messages: 3195
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The sibling histories are not limited to the past 7 years. They are intended to include all siblings ever born. The limitation to the past 7 years is imposed during the calculation of the rates. The past 7 years refers to the 84 calendar months before the month of interview and varies for women interviewed in different months. It does not refer to calendar years such as 2010-2016.

It would definitely be possible to calculate rates for different intervals before the survey or for calendar years. We don't normally do this except for data quality checks. Our GitHub site--includes a Stata program to calculate these rates. It can be modified for different intervals of time, but you should be careful with such modifications because the rates depend on exposure (the denominators) as well as the dates of the deaths (the numerators).

Report message to a moderator

Re: Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #22440 is a reply to message #22435]

Thu, 11 March 2021 21:38

Melese
Messages: 17
Registered: August 2019

Member

Dear Bridgette and Tom, thank you very much for the reply.
Dear experts, can you please help me with this STATA syntax (program) to calculate these rates over different time intervals, please? I ccouldn't get it on the GitHub site.
Regards
Melese

*The following is the syntax that I used to calculate the pregnancy-related maternal mortality rate (out of the 15-49 reproductive age women) over the 05 years preceding the survey by using the ETHIOPIA 2011 survey IR dataset.

keep caseid v001 v002 v003 v005 v008 v011 v012 v013 v021 v023 v024 v025 v106 v190 awfactt mm* mmc*
rename mm*_0* mm*_*
reshape long mmidx_ mm1_ mm2_ mm3_ mm4_ mm5_ mm6_ mm7_ mm8_ mm9_ mm10_ mm11_ mm12_ mm13_ mm14_ mm15_, i(caseid) j(mmindex)
rename mm*_ mm*
drop if mmidx==.
tab mm1
drop if (mm1 == 8 | mm1 == 9 | mm2 == 8 | mm2 == 9 | mm1 == . | mm2 == .)
tab mm2 mm1
local period 60
gen upplim = v008-1
replace upplim = mm8 if mm2 == 0
gen lowlim = v008-`period'
gen exposure = upplim-lowlim+1
replace exposure = 0 if exposure < 0
gen agegrp1 = int((upplim-mm4)/60)
gen expo1 = min(exposure,upplim - (mm4 + agegrp1*60) + 1)
gen deaths1 = (mm2==0 & expo1 > 0)
replace exposure = exposure - expo1
gen agegrp2 = agegrp1 - 1
gen expo2 = min(60,exposure)
gen deaths2 = 0
replace exposure = exposure - expo2
gen agegrp3 = agegrp2 - 1
gen expo3 = min(60,exposure)
gen deaths3 = 0
reshape long agegrp expo deaths, i(caseid mmindex) j(j)
keep if agegrp >= 3 & agegrp <= 9
label define agegrp 3 "15-19" 4 "20-24" 5 "25-29" 6 "30-34" 7 "35-39" 8 "40-44" 9 " 45-49"
label values agegrp agegrp
gen wt = v005/1000000
tab agegrp mm1 [iw=deaths*wt]
tab agegrp mm1 [iw=expo*wt/12]
tab agegrp [iw=deaths*wt] if mm1 == 2 & mm9 >= 2 & mm9 <= 6
tab agegrp [iw=expo*wt/12] if mm1 == 2
gen PregMMR = 0 if [(agegrp==3 | agegrp==4 | agegrp==5 | agegrp==6 | agegrp==7 | agegrp==8 | agegrp==9) & (mm1 == 2)]
replace PregMMR = 1 if [(agegrp==3 | agegrp==4 | agegrp==5 | agegrp==6 | agegrp==7 | agegrp==8 | agegrp==9) & (mm1 == 2) & (mm1 == 2) & (mm9 >= 2) & (mm9 <= 6)]

Report message to a moderator

Re: Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #22442 is a reply to message #22440]

Fri, 12 March 2021 07:54

Bridgette-DHS
Messages: 3195
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The GitHub Stata program can be accessed here: https://github.com/DHSProgram/DHS-Indicators-Stata/tree/mast er/Chap16_AM. To use it, you should first look at this page: https://github.com/DHSProgram/DHS-Indicators-Stata.

You may be able to adapt that program to different time intervals--your Stata skills appear to be excellent. The GitHub program is a modification of a more general program I wrote several years ago. I believe it is set up for a specific reference period, the 7 years (84 months) before the survey. However, if you look at the code, you should be able to locate two variables that specify the reference period for the estimates in century month codes (cmc). Look for "lcmc" and "ucmc" (for lower and upper cmc of the reference period). They can be specified with either a "calendar years" or "years ago" definition of the reference period.

Report message to a moderator

Re: Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #22470 is a reply to message #22442]

Wed, 17 March 2021 10:39

Melese
Messages: 17
Registered: August 2019

Member

Dear Tom, thank you very much for the help.
Using the 2000 ETHIOPIA DHS IR data file and applying the previous command to calculate the pregnancy-related maternal mortality
rate in the five (05) years preceding the survey, I tried the following command to calculate the mortality rate in the calendar year 1987(a single year).

gen pregmmr1987= PregMMR if [(lowlim==1050 |lowlim==1051|lowlim==1052|lowlim==1053|lowlim==1054) & (upplim==1045 | upplim==1046| upplim==1047|upplim==1048|upplim==1049|upplim==1050|upplim== 1056)]

However I failed, Tom. I still need your help and I am grateful for the help you guys offered me.
Regards
Melese

Report message to a moderator

Re: Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #22481 is a reply to message #22470]

Thu, 18 March 2021 10:36

Bridgette-DHS
Messages: 3195
Registered: February 2013

Senior Member

A reply was sent to your email.

Report message to a moderator

Re: Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #27048 is a reply to message #22481]

Thu, 15 June 2023 07:42

waqas
Messages: 35
Registered: June 2015
Location: Islamabad, Pakistan

Member

Bridgette-DHS wrote on Thu, 18 March 2021 10:36

A reply was sent to your email.

Dear Melese!

I am following this thread.

I was going through the code you share. It has solution to calculate the exposure years. I am stuck at a line (gen lowlim = v008-`period'). In this line i did not find explanation or roots for the term 'period'.

It will be more understandable to me if you kindle notes for each line of code you shared.

Kindly please share the response from Bridgette-DHS with me.

Waqas Imran
methegemini@gmai.com

Waqas Imran

Report message to a moderator

Re: Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #27187 is a reply to message #27048]

Tue, 27 June 2023 13:20

Bridgette-DHS
Messages: 3195
Registered: February 2013

Senior Member

Attached is a program by Tom Pullum, to calculate adult and maternal mortality rates. It produces all the standard estimates in the final report chapter on adult and maternal mortality.

Attachment: adult_mm_rates_do_16Mar2023.txt
(Size: 12.85KB, Downloaded 171 times)

Report message to a moderator

Re: Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #27225 is a reply to message #27187]

Sun, 02 July 2023 07:40

waqas
Messages: 35
Registered: June 2015
Location: Islamabad, Pakistan

Member

This program is expectedly be suing IR file from individual women records/questionnaire.

Many thanx i may communicate again if i get any issue.

Regards
Waqas Imran

Waqas Imran

Report message to a moderator

Previous Topic:	Modelling of determinants of under five mortality
Next Topic:	Maternal Mortality

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 13 07:04:14 Coordinated Universal Time 2024