The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Mortality » Computing Under-5 Mortality
Computing Under-5 Mortality [message #3464] Mon, 15 December 2014 02:24 Go to previous message
femifemi is currently offline  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

 
Read Message
Read Message
Previous Topic: Maternal Mortality Rwanda
Next Topic: Sharing code for child/infant/U5 mortality rates
Goto Forum:
  


Current Time: Sun Dec 29 14:06:47 Coordinated Universal Time 2024