The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Mortality » Maternal Mortality Ratio
Re: Maternal Mortality Ratio [message #3457 is a reply to message #3421] Fri, 12 December 2014 20:31 Go to previous messageGo to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 797
Registered: January 2013
Senior Member
If you are trying to calculate the maternal mortality ratio then the code is a lot more complicated than this. What you have done so far provides you with an estimate of the proportion of deaths to women that are due to maternal causes - roughly 33%, which matches reasonably with the 31.7% shown in the report. Note though that the table in the report is for maternal mortality in the 7 years preceding the survey and for women who were 15-49 at the time of their exposure to the risk of maternal mortality.

I am attaching a spreadsheet that shows some of the calculations needed (the numbers in the spreadsheet are fictitious and are just an example of calculations):
In the first column you need to calculate the number of maternal deaths (or pregnancy related deaths) in the seven years preceding the survey to women aged 15-49 at the time of the death.
In the second column you need to calculate the number of years of exposure in the seven years preceding the survey to women aged 15-49 at the time of the exposure. Note that any women may contribute to 3 different cells over the past 7 years. For example a women who is 40 years and 6 months at the time of interview contributes 6 months in the 40-44 category, 5 years in the 35-39 category and one and a half years in the 30-34 age category. We actually do the calculation in months (see the CMC date of birth and date of death variables) and then divide by 12 to get years.
In the third column we calculate the maternal mortality (or pregnancy related mortality) rate for each age group by dividing the first and second columns.
In the fourth column we have the distribution of the female population age 15-49 and use this to a weighted death rate in the fifth column, which is summed to produce an age adjusted total maternal mortality rate (cell F9).
This total maternal mortality rate is then divided by an age standardized general fertility rate for the same seven year time period to produce the maternal mortality ratio.
  • Attachment: PRMR.xls
    (Size: 24.50KB, Downloaded 896 times)
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Under 5 Mortality for Nepal
Next Topic: Problem in converting birth date CMC from Afghan calendar to Gregorian calendar
Goto Forum:
  


Current Time: Mon Jun 3 15:07:04 Coordinated Universal Time 2024