Re: Missing Data in Indonesia DHS 2012 [message #9814 is a reply to message #9813] |
Tue, 24 May 2016 16:04 |
Bridgette-DHS
Messages: 3230 Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
In situations like this it is good to look at the questionnaire. In the woman's questionnaire for this survey, given in an appendix (see page 451 of the report), #1109 is a filter based on sex and age at death. The questions about whether the death was pregnancy-related are not asked for men, of course, but they also are not asked about girls who died before age 10. The last two lines below will show you that the relevant number of missing cases is more like 447 than 9142. I would prefer that those 447 cases were not missing, but that's only about 5% of the number you thought. There may be some other reason why they are missing, such as a reluctance by the interviewer to ask whether a sister who died in her early teens had been pregnant. I agree that 372 deaths were identified to be pregnancy-related--in terms of their timing, at least.
set more off
use e:\DHS\DHS_data\IR_files\IDIR63FL.dta, clear
keep v001 v002 v003 mm*
describe mm*_1
drop mm5* mm6* mm10* mm11* mm12* mm13* mmc* mmidx*
rename *_0* *_*
describe mm*_1
reshape long mm1_ mm2_ mm3_ mm4_ mm7_ mm8_ mm9_ mm14_ mm15_,i(v001 v002 v003) j(mmidx)
rename *_ *
drop if mm1==.
drop if mm1==1
tab mm9 mm2,m
tab mm7 if mm2==0 & mm9==., m
tab mm7 if mm2==0 & mm9==. & mm7>=10 & mm7<=49, m
|
|
|