The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Calculating for children less than 23 months
Re: Calculating for children less than 23 months [message #9295 is a reply to message #9260] Sat, 05 March 2016 01:36 Go to previous messageGo to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 799
Registered: January 2013
Senior Member
Here is code for selecting the children to include. Two important differences with your code:
1) hw1 is not available for all children in this survey, I believe because anthropometry was collected in a subsample of households. It is generally better to calculate age in months using v008-b3.
2) The youngest child under age 2 living with the mother is not always the child with midx=1 (the last child born). It can be that the last child born either died or does not live with the monther, but the next to last child fits the criteria.

use "C:\Data\DHS_Stata\GHKR70FL.DTA", clear
gen age = v008-b3

* select on the living children under 2
keep if age<24 & b5==1

* regroup age
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)

* tabulate for the last column in table 11.3
tab child_age
tab child_age[iw=v005/1000000]

* Now restrict further
* Keep only those living with their mother
keep if b9==0
* and now check if it is the youngest
* children are in order with youngest first, any other child with the same caseid is not the youngest
drop if _n > 0 & caseid == caseid[_n-1]

* tabulate for the number of youngest children under age 2 living with mother
tab child_age
tab child_age[iw=v005/1000000]
Read Message
Read Message
Read Message
Read Message
Previous Topic: Computing Exclusive Breastfeeding Using SPSS
Next Topic: women's empowerment on child nutrition
Goto Forum:

Current Time: Mon Jun 17 02:36:28 Coordinated Universal Time 2024