The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Calculated rates of exclusive breastfeeding not matching rates in reports
Re: Calculated rates of exclusive breastfeeding not matching rates in reports [message #16046 is a reply to message #15757] Fri, 26 October 2018 10:04
 Bridgette-DHS Messages: 1785Registered: February 2013 Senior Member
Following is a response from DHS Technical Specialist, Rukundo Benedict:

The variables you listed for the liquids and solids look correct. I suspect your issue may be with selecting the sample. The code below will ensure you select the correct sample and the results will match the report. I would encourage you to also review the new DHS-7 guide to statistics, particularly if you are comparing breastfeeding changes over time.

```***SELECTING SAMPLE***
*Generate weight variable**
gen wgt=v005/1000000
*Generate age, keep those <2 years
gen age = v008-b3
*keep only those children alive
ta b5
keep if b5==1
*Generate age 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"), gen (age_months)
**If drank from bottle with nipple (bottlefeeding)
gen bottle=0
replace bottle=1 if m38==1
ta age_month bottle  [iw=wgt], row
*Important Note: for the other indicators, children must be the youngest child and living with mother
*keep only those living with mother
keep if b9==0
* finding the youngest child living with the mother
bysort v001 v002 v003: egen minbidx=min(bidx)
* keep only children less than 2 years
keep if age<24
ta bidx minbidx
* need to drop those that are bidx==2 and minbidx==1
drop if bidx>minbidx
ta age_month [iw=wgt]

***FOR CD***
gen water=0
gen liquids=0
gen milk=0
gen solids=0
gen breast=0
*To determine if child is given water, sugar water, jiuce, tea or other
replace water=1 if (v409>=1 & v409<=7)

* If given other liquids
foreach xvar of varlist v409a v410 v410a v413*  {
replace liquids=1 if `xvar'>=1 & `xvar'<=7
}

* If given powder/tinned milk, formula or fresh milk
foreach xvar of varlist v411 v411a v412 v414p {
replace milk=1 if `xvar'>=1 & `xvar'<=7
}
*If currently breastfeeding
replace breast=1 if m4==95
*If given any solid
foreach xvar of varlist v414* {
replace solids=1 if `xvar'>=1 & `xvar'<=7
}
replace solids=1 if v412a==1 | v412b==1
gen feeding=1
replace feeding=2 if water==1
replace feeding=3 if liquids==1
replace feeding=4 if milk==1
replace feeding=5 if solids==1
replace feeding=0 if breast==0
label define feeding 0 "Not breastfeeding" 1 "exclusive breastfeeding" 2 "+Water" 3 "+Liquids" 4 "+Other Milk" 5 "+Solids"
label val feeding feeding
ta age_month feeding  [iw=wgt], row

****FOR MZ & RW****
gen water=0
gen liquids=0
gen milk=0
gen solids=0
gen breast=0

*To determine if child is given water, sugar water, juice, tea or other
replace water=1 if (m37a>=1 & m37a<=7)

* If given other liquids
foreach xvar of varlist m37b m37c m37d m37e m37i m37j m37l{
replace liquids=1 if `xvar'>=1 & `xvar'<=7
}

* If given powder/tinned milk, formula or fresh milk
foreach xvar of varlist m37f m37g m37h {
replace milk=1 if `xvar'>=1 & `xvar'<=7
}

*If currently breastfeeding
replace breast=1 if m4==95

*If given any solid
foreach xvar of varlist m37m m37n m37o m37p m37q m37r m37s m37t m37u m37v m37w m37x m37y{
replace solids=1 if `xvar'>=1 & `xvar'<=7
}

gen feeding=1
replace feeding=2 if water==1
replace feeding=3 if liquids==1
replace feeding=4 if milk==1
replace feeding=5 if solids==1
replace feeding=0 if breast==0
label define feeding 0 "Not breastfeeding" 1 "exclusive breastfeeding" 2 "+Water" 3 "+Liquids" 4 "+Other Milk" 5 "+Solids"
label val feeding feeding
ta age_month feeding  [iw=wgt], row
```

 Calculated rates of exclusive breastfeeding not matching rates in reports By: IHME on Tue, 04 September 2018 18:54 Re: Calculated rates of exclusive breastfeeding not matching rates in reports By: Liz-DHS on Mon, 10 September 2018 12:28 Re: Calculated rates of exclusive breastfeeding not matching rates in reports By: IHME on Mon, 10 September 2018 21:06 Re: Calculated rates of exclusive breastfeeding not matching rates in reports By: Bridgette-DHS on Fri, 26 October 2018 10:04
 Previous Topic: Missing anthropometry data for African countries Next Topic: determining Children Nutrition Using Children Z score
Goto Forum:

Current Time: Tue Jun 2 11:18:36 Eastern Daylight Time 2020