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 #11522 is a reply to message #11516] Sun, 08 January 2017 09:34
 Roselync Messages: 19Registered: December 2016 Location: Taiwan Member
Dear DHS team and colleagues,
I managed to find the exclusive breastfeeding rate of 71.4% which is similar to that of the 2010 Malawi DHS REPORT but surprisingly the denominator(0-5 months) is 1656 instead of 1698,i tried key in the codes that I was given previously several times using Stata but I keep getting the same denominator(1656) .Iam also still finding challenges to find the correct predominant feeding and complementary feeding rate estimate.my predominant feeding rate(0-5 months) was 75.64% and Malawi demographic health survey report rate is 77.5%.my complementary feeding rate (0-23months) is 22.15% and the rate in the report is 19%.I used every step of the code that I was previously given to get the EXCLUSIVE BREASTFEEDING rate(please find it below).I have also indicated how I got the predominant and complementary feeding rate.

** 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]

*To calculate predominant breastfeeding rate I used this code
gen pred=0
replace pred=1 if diet==1
replace pred=1 if diet==0

*To calculate complementary feeding
gen comp=0
replace comp=1 if diet==2
replace comp=1 if diet==3
replace comp=1 if diet==4

Could anyone please advise me on the above percentages, if the differences I have found are acceptable or not;also if I missed any step to calculate the variables for exclusive breastfeeding, predominant feeding and complementary feeding. Your assistance will be highly appreciated.

Regards,
Rose

 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: Sat Jul 20 11:57:17 Coordinated Universal Time 2024