Computing Under-5 Mortality [message #3464] |
Mon, 15 December 2014 02:24 |
femifemi
Messages: 8 Registered: December 2014 Location: NIGERIA
|
Member |
|
|
Please I have problem reproducing Under-5 mortality in Nigeria DHS report. How do I go about it. Below are some of the codes I have tried. Thank you in anticipation.
/*
------------------------------------------------------------ -----------------------------------------------------
Using kids' record NGKR6AFL.DTA
------------------------------------------------------------ -----------------------------------------------------
*/
*Compute weight
gen weight=v005/1000000
svyset [iweight=weight]
*Tabulate the survival status of child
tab b5 [iweight=weight]
* b5 shows that Under-5 mortality rate was 92 deaths per 1000 live births different from 128/1000 in report
*compute child's age as at the date of interview where v008=CMC Date of interview,b3=CMC date of birth of child
gen childage = int( (v008-b3)/12 )
* Result shows that all of them died 0-4 years before survey
* b6 & b7 indicate that all the children died before age 5
/*
------------------------------------------------------------ -----------------------------------------------------
Using women's birth history in NGIR6AFL.DTA
------------------------------------------------------------ -----------------------------------------------------
*/
*Rename to drop zeros
rename b*_0* b*_*
keep caseid b* v008 v005 v021 v022
*Reshape
reshape long bidx_ b1_ b2_ b3_ b4_ b5_ b6_ b7_ b8_ b9_ b10_ b11_ b12_ b13_ b15_ b16_,i(caseid) j(bidx)
*Compute weight
gen weight=v005/1000000
svyset v021 [pweight=weight],srata(v022)
*compute child's age as at the date of interview where v008=CMC Date of interview,b3=CMC date of birth of child
gen childage = int( (v008-b3)/12 )
* Result shows that all of them died 0-4 years before survey
* Tabulation of b6 & b7 indicate that all the children died before age 5
*Tabulate survival status of child
svy: tab b5_
*Result in b5_ shows that Under-5 mortality rate was 170 deaths per 1000 live births but I want to reproduce 128/1000 in report
[Updated on: Mon, 15 December 2014 02:26] Report message to a moderator
|
|
|