The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Mortality » DHS Cameroon (Maternal mortality rates calculation)
DHS Cameroon [message #24649] Tue, 14 June 2022 05:38 Go to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Hello,

I am currently in a training and working on the 3 last DHS in Cameroon (2004, 2011, 2018). I need to compute the maternal mortality rates (MMR). I started with 2004 but I find (1) different results from the DHS report (in french sorry) :

https://dhsprogram.com/pubs/pdf/FR163/FR163-CM04.pdf

Please find enclosed the dofile I wrote. I took example on a past conversation about the same topic for DHS Indonesia 2012 :

https://userforum.dhsprogram.com/index.php?t=msg&goto=85 52&S=Google#

I replaced "gen lowlim = v008-`period' " by "gen lowlim = v008- 60" as it (2) gives a syntax error with the first commands.
Could you please help me with these 2 problems? I hope I have been clear.

Thank you
Re: DHS Cameroon [message #24655 is a reply to message #24649] Wed, 15 June 2022 08:59 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 657
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The maternal mortality rates and ratios are much more complicated. We have posted the code on our GitHub site https:// github.com/DHSProgram/DHS-Indicators-Stata/tree/master/Chap1 6_AM. The generic chapter number for adult and mm is #16. Also, the standard interval for these rates is the 84 months before the month of interview, not 60 months.
Re: DHS Cameroon [message #24658 is a reply to message #24655] Wed, 15 June 2022 11:43 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Thank you very much for your answer
Re: DHS Cameroon [message #24679 is a reply to message #24655] Mon, 20 June 2022 05:07 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Hello, I have another question: are the stata dofiles for DHSs Cameroon available somewhere and is it possible to get them? Thank you
Re: DHS Cameroon [message #24692 is a reply to message #24679] Wed, 22 June 2022 10:43 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 657
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

We don't post the do files for specific surveys, but we do have a GitHub site with general do files (https://github.com/DHSProgram/DHS-Indicators-Stata).
Re: DHS Cameroon [message #24696 is a reply to message #24692] Thu, 23 June 2022 05:46 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Thank you for your answer
Re: DHS Cameroon [message #24839 is a reply to message #24649] Tue, 19 July 2022 03:57 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Hello, I would like to understand why when I apply the weights on the data, I find different values for the effectives. It's a problem because my results wouldn't be correct
Re: DHS Cameroon [message #24863 is a reply to message #24839] Thu, 21 July 2022 12:30 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 657
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

All estimates should include the use of weights. Otherwise the estimates will be biased toward the strata that have been over-sampled and away from the strata that have been under-sampled. (Small strata are over-sampled and large strata are under-sampled to make the subsamples within strata more equal in size.) Weighted estimates do differ from unweighted estimates, but the weighted estimates are preferable.
Re: DHS Cameroon [message #24877 is a reply to message #24863] Mon, 25 July 2022 05:49 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Thank you fo this answer

I also wanted to ask you about the code to compute the mortality rates. I want to get the maternal mortality rates. I saw that there were many programs. Do I have to run them all or only some of them? By the way I encounter some issues to run the 2nd program (set up adult mm_vars). Stata doesn't find lw and spath for example. What does it refer to?
I managed to run the 1st program but I don't understand its utlity.
Thank you
Re: DHS Cameroon [message #24879 is a reply to message #24877] Mon, 25 July 2022 11:47 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
How do you compute the emaciation, underweight and growth retardation? It seems they're not in the variables of the dataset
Is there a code to get it?
Re: DHS Cameroon [message #24907 is a reply to message #24879] Mon, 01 August 2022 12:24 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 657
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

Regarding the nutrition variables--I believe that "growth retardation, underweight and emaciation" are what we refer to as "stunted, underweight, and wasted", respectively. These are not given directly but must be calculated from hc70, hc71, hc72 in the PR file or hw70, hw71, and hw72 in the KR file. For example, here are the steps for the PR file:

gen stunted=0 if hwc70<600
replace stunted=1 if hwc70<-200

gen underweight=0 if hwc71<500
replace underweight=1 if hwc71<-200

gen wasted=0 if hwc72<500
replace wasted=1 if hwc72<-200

Regarding the calculation of adult and maternal mortality--yes, these are complex procedures. If you are referring to the Stata programs on GitHub, you need to read all the documentation. There should be a default that does not require you to specify "lw", for example, which is the century month code (different for every woman) of the first month in the (usually) 7-year window before the month of the survey for which deaths and exposure are accumulated. ("lw" for the lower end of the window; "uw" for the upper end of the window.) You should not have to specify that unless you want to do a customized run. "spath" is a scalar for the path to the data files and the documentation tells you how to specify it. I wrote the program but other people at DHS adapted it for GitHub and I don't use the GitHub version myself.
Re: DHS Cameroon [message #24923 is a reply to message #24907] Wed, 03 August 2022 10:57 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Thank you for these answers
Re: DHS Cameroon [message #24949 is a reply to message #24649] Mon, 08 August 2022 04:45 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Hello,
In this code :
//Go to the IR file and reshape the mm variables.
program define setup_adult_mm_vars

//Setup local path and data file name
local lpath=spath
local lfn_IR=sfn_IR
use "`lpath'\\`lfn_IR'", clear

//Make a file of sisters
keep v000 v001 v002 v003 v005 v008 v010 v013 v021-v025 mm* awfact*

//This file includes all women, including women with no siblings, and is needed later
sort v001 v002 v003
save IR_all_women.dta, replace

gen clusterid=v021

-> //check for v023 for stratum id
if sv023_NA==0 {
rename v023 stratumid
}

if sv023_NA==1 {
egen stratumid=group(v024 v025)
}

//Need to check for mm16; if an older survey, must give it a value
scalar smissing_mm16=0
capture confirm numeric variable mm16_01, exact
if _rc>0 {
scalar smissing_mm16=1
local li=1
while `li'<=20 {
gen mm16_`li'=.
local li=`li'+1
}
}

ren *_0* *_*
drop mmc* mmidx* mm5* mm10* mm11* mm12* mm13* mm14* mm15*


//reshape data file
quietly reshape long mm1_ mm2_ mm3_ mm4_ mm6_ mm7_ mm8_ mm9_ mm16_, i(v001 v002 v003) j(mmidx)
rename mm*_ mm*

//Drop any cases with sex missing, i.e. mm1>2
drop if mm1>2

/*---------------------------------------------------------- ----------------
NOTE:
Important for redefinition of Pregnancy Related Mortality Ratio (PRMR)
in surveys from 2016 onwards

If mm9=2, and mm16=1 or 2, recode mm9 to 1
replace mm9=1 if mm9==2 & (mm16==1 | mm16==2)

For earlier surveys that do not include mm16, it is only possible to
calculate PRMR; what was previously called maternal mortality (MM) is now called
pregancy related mortality (PRM)

See https://blog.dhsprogram.com/mmr-prmr/ for more information on these indicators.
------------------------------------------------------------ --------------*/

//This file has one record for each sibling. It is needed for the tables on completeness of information.
save workfile.dta, replace


//Crucial: drop cases in which survival status is don't know (dk) AFTER saving workfile
drop if mm2>1

//specify the lower and upper cmcs of the interval of observation, start_month and end_month,

/*---------------------------------------------------------- ----------------
NOTE:
This uses scalars lw and uw that were set earlier; usually lw=-6 and uw=0,
but not always!
------------------------------------------------------------ --------------*/

//execute program to create start and end month for window of time
-> start_month_end_month

rename mm1 sex

//Tabulate the timing--during pregnancy, at childbirth, afterwards

//tabulate mm9 for all maternal deaths, unweighted
tab mm9

//tabulate mm9 for all maternal deaths, weighted
tab mm9 [iweight=v005/1000000]

//tabulate mm9 for all maternal deaths in the window, unweighted
tab mm9 if mm8>=start_month & mm8<=end_month

//tabulate mm9 for all maternal deaths in the window, weighted
tab mm9 if mm8>=start_month & mm8<=end_month [iweight=v005/1000000]

save adult_mm_vars.dta, replace

/*---------------------------------------------------------- ----------------
NOTE:

adult_mm_vars.dta is an individual-level file for with one record for each
sibling in the IR file. If there was also a sibling module in the men's survey,
a parallel routine must be added.
------------------------------------------------------------ --------------*/

end



What are "sv023" and "start_month_end_month"? Stata displays "sv023_NA not found" and "command start_month_end_month is unrecognized" respectively when I try to run it.

Re: DHS Cameroon [message #24951 is a reply to message #24649] Mon, 08 August 2022 09:26 Go to previous messageGo to next message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
I managed to generate the variables stunted, underweight and wasted with your code. Now I want to select only the children who are under 1 year old. How can I do that please?
Re: DHS Cameroon [message #24966 is a reply to message #24951] Wed, 10 August 2022 16:39 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 657
Registered: April 2022
Senior Member
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The age of a child, in months, is given by hc1 in the PR file and hw1 in the KR file. To restrict to complete age <1 year add this "... if hc1<=11 ..." if you are using the PR file or "... if hw1<=11 ..." if using the KR file.
Re: DHS Cameroon [message #24974 is a reply to message #24966] Fri, 12 August 2022 03:57 Go to previous message
Muhibbi is currently offline  Muhibbi
Messages: 11
Registered: June 2022
Member
Thank you
Previous Topic: Neonatal mortality rate
Next Topic: Neonatal mortality
Goto Forum:
  


Current Time: Thu Mar 28 10:26:25 Coordinated Universal Time 2024