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
 Trevor-DHS Messages: 799Registered: 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]```

 Calculating for children less than 23 months By: tony on Sun, 28 February 2016 16:57 Re: Calculating for children less than 23 months By: Trevor-DHS on Sat, 05 March 2016 01:36 Re: Calculating for children less than 23 months By: tony on Tue, 08 March 2016 09:01 Re: Calculating for children less than 23 months By: tony on Mon, 21 March 2016 07:13
 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