The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Calculating cases for IYCF
Re: Calculating cases for IYCF [message #11421 is a reply to message #11411] Mon, 19 December 2016 08:49
 Bridgette-DHS Messages: 3113Registered: February 2013 Senior Member
Following is a response from DHS Senior Research Associate, Shireen Assaf:

Quote:
To match the table for exclusive breastfeeding you would need to compute some variables such as drank any liquids or consuming any solids, etc. The code below can be used to match the table for exclusive breastfeeding. The estimate is 71.4% for children 0-5 months and the denominator is 1,698.

```** Exclusive breast feeding
use MWKR61FL.dta, clear

gen age=v008-b3

keep if b9==0

* finding the youngest child living with the mother for each mother
bysort v001 v002 v003: egen minbidx=min(bidx)
* keep only children less than 2 years
keep if age<24
* need to drop those that are bidx==2 and minbidx==1
drop if bidx>minbidx

gen water=0
gen liquids=0
gen milk=0
gen solids=0
gen breast=0
gen bottle=0

*TO DETERMINE IF CHILD IS GIVEN WATER, SUGAR WATER, JUICE, TEA OR OTHER.
replace water=1 if (v409>=1 & v409<=7)

* IF GIVEN OTHER LIQUIDS
foreach xvar of varlist v409a v410 v410*  v413* {
replace liquids=1 if `xvar'>=1 & `xvar'<=7
}

cap replace liquids=1 if v412c>=1 & v412c<=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 STILL BREASTFEEDING
replace breast=1 if m4==95

* IF WAS EVER BOTTLE FED
replace bottle=1 if m38==1

*IF GIVEN ANY SOLID FOOD
foreach xvar of varlist v414* {
replace solids=1 if `xvar'>=1 & `xvar'<=7
}
replace solids=1 if v412a==1 | v412b==1

gen diet=7
replace diet=0 if water==0 & liquids==0 & milk==0 & solids==0
replace diet=1 if water==1 & liquids==0 & milk==0 & solids==0
replace diet=2 if            liquids==1 & milk==0 & solids==0
replace diet=3 if                         milk==1 & solids==0
replace diet=4 if                         milk==0 & solids==1
replace diet=5 if                         milk==1 & solids==1
replace diet=6 if breast==0

*diet=0: given only water (full bf)
*diet=1: given only liquids (bf & liquids)
*diet=2: given only milks (bf & milk)
*diet=3: given only solids (bf & solids)
*diet=4: given only milk and solids (bf & milk & solids)
*diet=5: not still breastfeeding (weaned)
*diet=6: not now being breastfed (m4~=95)

** Matching Table 11.3 for exclusive breast feeding in 0-5 month children **
gen ebf=0
replace ebf=1 if diet==0
ta ebf if age<6 [iw=v005/1000000]

```

 Calculating cases for IYCF By: anuth on Wed, 26 October 2016 14:05 Re: Calculating cases for IYCF By: Trevor-DHS on Wed, 26 October 2016 18:12 Re: Calculating cases for IYCF By: Roselync on Fri, 16 December 2016 02:51 Re: Calculating cases for IYCF By: Bridgette-DHS on Mon, 19 December 2016 08:49 Re: Calculating cases for IYCF By: Roselync on Mon, 19 December 2016 09:43 Re: Calculating cases for IYCF By: Roselync on Fri, 06 January 2017 04:34 Re: Calculating cases for IYCF By: Roselync on Sun, 08 January 2017 09:34 Re: Calculating cases for IYCF By: Bridgette-DHS on Mon, 09 January 2017 09:04 Re: Calculating cases for IYCF By: Roselync on Mon, 09 January 2017 09:19 Re: Calculating cases for IYCF By: Bridgette-DHS on Tue, 10 January 2017 08:55 Re: Calculating cases for IYCF By: Roselync on Tue, 10 January 2017 09:06 Re: Calculating cases for IYCF By: adenikedegun on Wed, 21 June 2017 05:58 Re: Calculating cases for IYCF By: Bridgette-DHS on Wed, 21 June 2017 08:36 Re: Calculating cases for IYCF By: adenikedegun on Wed, 21 June 2017 18:03 Re: Calculating cases for IYCF By: adenikedegun on Thu, 22 June 2017 08:59 Re: Calculating cases for IYCF By: Bridgette-DHS on Thu, 22 June 2017 09:55 Re: Calculating cases for IYCF By: Bridgette-DHS on Thu, 22 June 2017 10:10 Re: Calculating cases for IYCF By: adenikedegun on Thu, 22 June 2017 11:06 Re: Calculating cases for IYCF By: adenikedegun on Thu, 22 June 2017 11:15 Re: Calculating cases for IYCF By: Bridgette-DHS on Thu, 22 June 2017 14:50 Re: Calculating cases for IYCF By: adenikedegun on Thu, 22 June 2017 10:42 Re: Calculating cases for IYCF By: adenikedegun on Tue, 27 June 2017 08:09 Re: Calculating cases for IYCF By: Bridgette-DHS on Tue, 27 June 2017 10:20 Re: Calculating cases for IYCF By: adenikedegun on Tue, 27 June 2017 15:41 Re: Calculating cases for IYCF By: Roselync on Wed, 23 May 2018 00:53 Re: Calculating cases for IYCF By: Bridgette-DHS on Wed, 23 May 2018 09:24 Re: Calculating cases for IYCF By: Roselync on Wed, 23 May 2018 19:48 Re: Calculating cases for IYCF By: Mlue on Thu, 24 May 2018 04:48 Re: Calculating cases for IYCF By: Hassen on Thu, 24 May 2018 05:25 Re: Calculating cases for IYCF By: Roselync on Thu, 24 May 2018 06:53 Re: Calculating cases for IYCF By: Roselync on Sun, 27 May 2018 06:31 Re: Calculating cases for IYCF By: Mlue on Mon, 28 May 2018 02:28 Re: Calculating cases for IYCF By: Roselync on Mon, 28 May 2018 02:51 Re: Calculating cases for IYCF By: Mlue on Mon, 28 May 2018 04:44 Re: Calculating cases for IYCF By: Roselync on Mon, 28 May 2018 04:51 Re: Calculating cases for IYCF By: Hassen on Wed, 06 June 2018 11:07 Re: Calculating cases for IYCF By: Hope on Wed, 13 June 2018 02:50 Re: Calculating cases for IYCF By: Bridgette-DHS on Fri, 15 June 2018 06:10 Re: Calculating cases for IYCF By: Hope on Mon, 18 June 2018 12:25 Re: Calculating cases for IYCF By: Chris on Sun, 10 February 2019 10:01 Re: Calculating cases for IYCF By: Roselync on Thu, 06 April 2017 07:32 Re: Calculating cases for IYCF By: Bridgette-DHS on Thu, 06 April 2017 14:33 Re: Calculating cases for IYCF By: Roselync on Fri, 07 April 2017 11:01 Re: Calculating cases for IYCF By: Sajhama on Wed, 25 October 2017 14:14 Re: Calculating cases for IYCF By: Bridgette-DHS on Thu, 26 October 2017 13:13 Re: Calculating cases for IYCF By: Sajhama on Thu, 26 October 2017 14:56 Re: Calculating cases for IYCF By: Chris on Tue, 10 April 2018 13:18 Re: Calculating cases for IYCF By: Trevor-DHS on Tue, 10 April 2018 17:31 Re: Calculating cases for IYCF By: Chris on Wed, 11 April 2018 12:24 Re: Calculating cases for IYCF By: Chris on Fri, 13 April 2018 01:32
 Previous Topic: Selecting one child per mother Next Topic: Postnatal care utilization variable in 2015-2016 MDHS dataset
Goto Forum:

Current Time: Sun Jul 14 12:51:01 Coordinated Universal Time 2024