| DHS Cameroon [message #24649] |
Tue, 14 June 2022 05:38  |
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 #24907 is a reply to message #24879] |
Mon, 01 August 2022 12:24  |
Janet-DHS
Messages: 891
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 #24949 is a reply to message #24649] |
Mon, 08 August 2022 04:45 |
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.
|
|
|
|
|
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
