The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Mortality » Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016
Calculating pregnancy related maternal mortality by year using ETHIOPIA DHSs 2000-2016 [message #22422] Wed, 10 March 2021 20:33 Go to next message
Melese is currently offline  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
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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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).

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 Go to previous messageGo to next message
Melese is currently offline  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)]
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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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.
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 Go to previous messageGo to next message
Melese is currently offline  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
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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
A reply was sent to your email.
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 Go to previous messageGo to next message
waqas is currently offline  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
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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
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.
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 Go to previous message
waqas is currently offline  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
Previous Topic: Modelling of determinants of under five mortality
Next Topic: Maternal Mortality
Goto Forum:
  


Current Time: Fri Mar 29 03:11:52 Coordinated Universal Time 2024