The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Rwanda DHS 2014-15 ;Child Nutrition- Table 11.6
Rwanda DHS 2014-15 ;Child Nutrition- Table 11.6 [message #12042] Wed, 22 March 2017 11:33 Go to previous message
crlnhalcyn is currently offline  crlnhalcyn
Messages: 3
Registered: March 2017
Member
Hi,

am trying to replicate Table 11.6 in the Rwanda DHS 14-15 using the KR file, but the distribution of children age 6-23 does not match up. Here is the code I have as of now:


*date of interview
desc v008

*date of birth
desc b3

*gen age
gen age = v008-b3
tab age

*sort
sort v000 v001 v002 v003 bidx

*Keep if :
*child is living with nother (b9=0)
*child is last-born (bidx=1)
*child is alive (b5=1)
*age range to 6-23 and keep only if child is alive

keep if b9==0
keep if bidx==1
keep if b5==1 & age<24
drop if age<6

*to match the distribution in table 11.6 (underestimated in every category except 9-11)
*recode age into groups

recode age (0/1=1 "0-1")(2/3=2 "2-3")(4/5=3 "4-5")(6/8=4 "6-8")(9/11=5 "9-11") ///
(12/17=6 "12-17")(18/23=7 "18-23")(24/59=.), gen(child_age)
tab child_age

*tab for multiple births

tab child_age b0

I have checked with various versions of code, but the distribution I am able to get does not match up to the one shown in Table 11.6. I would be most grateful for help!
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: cameroon 1998 v002
Next Topic: how to download a data set
Goto Forum:
  


Current Time: Fri Apr 26 05:44:50 Coordinated Universal Time 2024