The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Calculating cases for IYCF
Calculating cases for IYCF [message #11097] Wed, 26 October 2016 14:05 Go to next message
anuth is currently offline  anuth
Messages: 9
Registered: November 2015
Location: Finland
Member
Hello DHS team,

I am working on PDHS 2012-13 and calculating some IYCF variables. My cases should be the youngest child living with respondent who are less than 24 months. To calculate this i performed following steps in Under 5 years child file:

1. Select- Age of child <24 months
2. Select- Living with whom=0
3. Select- BIDX=1

But the number of child differ in my calculation and what is given in PDHS 2012-13 report.

My calculation is

Age group of child under 2 years
Frequency Percent Valid Percent Cumulative Percent
Valid Less than 6 months 1075 27,4 27,4 27,4
6 to 8 months 493 12,5 12,5 39,9
9 to 11 months 535 13,6 13,6 53,5
12 to 17 months 1123 28,6 28,6 82,1
18 to 23 months 703 17,9 17,9 100,0
Total 3929 100,0 100,0


But in PDHS 2012-13 report the total number of under 2 years child eligible for IYCF questionnaire is 3,206 ( from table 11.5, page 200)

Grateful if you could help me to find where i am wrong or what i am missing)

Thank you,
Anupa



A
Re: Calculating cases for IYCF [message #11100 is a reply to message #11097] Wed, 26 October 2016 18:12 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 507
Registered: January 2013
Senior Member
This is a common misunderstanding. The youngest child living with the mother is not necessarily one with BIDX = 1. BIDX = 1 is for the last child born, but if the last child born had died or does not live with the mother, then the youngest child living with the mother may have BIDX = 2.

Try the following code:
* Cases should be sorted already, but in case they are not
sort caseid bidx
* Last child in the last 2 years living with mother
* age in months
gen age = v008-b3
lab var age "Age in months"
* keep if under 24 months and living with mother
keep if age<24 & b9==0
* ... and keep the last born of those. If caseid is the same as the prior case, then not the last born.
drop if _n > 0 & caseid == caseid[_n-1]
* generate variable for still breastfeeding
recode m4 (95=1 "Still breastfeeding")(else=0 "Not breastfeeding"), gen(bf)
lab var bf "Currently breastfeeding"
* generate age groupings
recode age (0/5 = 0 "0-5")(6/8 = 1 "6-8")(9/11 = 2 "9-11")(12/17 = 3 "12-17")(18/23 = 4 "18-23"), gen(ageg)
lab var ageg "Age groups"

* tabulate current breastfeeding status by age group
tab ageg bf [iw=v005/1000000]


Re: Calculating cases for IYCF [message #11411 is a reply to message #11100] Fri, 16 December 2016 02:51 Go to previous messageGo to next message
Roselync is currently offline  Roselync
Messages: 11
Registered: December 2016
Location: Taiwan
Member
Dear DHS team and colleagues,
I recently analyzed the individual dataset for 2010 Malawi demographic and health survey and I used SPSS.I selected youngest children living with their mothers aged less than 24 months. I estimated the prevalence rates of child feeding practices but surprisingly my results didn't match those that are in the 2010 report. I found that Exclusive breastfeeding is at 95.5% instead of 71.4% and the rest of the other breastfeeding practices are also higher than expected. My concern is how can I go about to extract the variables for exclusive breastfeeding and predominant feeding since these were not clearly pointed out in the recode manual. Do I use current breastfeeding variable to estimate the exclusive breastfeeding rate? and for predominant feeding, do I compute some variables(drank plain water, juice and milk and breastmilk) to make one composite variable for predominant feeding? Also how do I manage the missing cases in these variables? I also tried the above suggestions to extract the appropriate sample size but still more there is a difference. Mine was 7333 and the report found a sample size of 7724.Any suggestions will be highly appreciated.

Thank you
Re: Calculating cases for IYCF [message #11421 is a reply to message #11411] Mon, 19 December 2016 08:49 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1000
Registered: 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]


Re: Calculating cases for IYCF [message #11422 is a reply to message #11421] Mon, 19 December 2016 09:43 Go to previous messageGo to next message
Roselync is currently offline  Roselync
Messages: 11
Registered: December 2016
Location: Taiwan
Member
Dear Bridget,
Thank you so much for the response. Will work on the information you have given me and will give feedback once I come up with the results

Regards,
Rose
Re: Calculating cases for IYCF [message #11516 is a reply to message #11421] Fri, 06 January 2017 04:34 Go to previous messageGo to next message
Roselync is currently offline  Roselync
Messages: 11
Registered: December 2016
Location: Taiwan
Member
Dear DHS team and colleagues,
I managed to find the exclusive breastfeeding rate that is similar to that of the Malawi DHS REPORT.However, am still finding challenges to find similar the predominant feeding rate and complementary feeding rate.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 did the following to get the rates

following the previous given code
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)


*To calculate predominant breastfeeding rate
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 advise me on the above percentages, if the differences I have found are acceptable or not and also if I used the right syntax to calculate the variables for predominant feeding and complementary feeding. Your assistance will be highly appreciated.

Regards,
Rose


Re: Calculating cases for IYCF [message #11522 is a reply to message #11516] Sun, 08 January 2017 09:34 Go to previous messageGo to next message
Roselync is currently offline  Roselync
Messages: 11
Registered: 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


Re: Calculating cases for IYCF [message #11531 is a reply to message #11522] Mon, 09 January 2017 09:04 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1000
Registered: February 2013
Senior Member
Following is a response from DHS Senior Research Associate, Shireen Assaf:

After creating your water, liquid, milk and solid variables, please use the following code to match the report.

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

*complimentary feeding is category #5 (+solids) and this matches the report for this age group which is 19.1%
ta feeding if age<6 [iw=v005/1000000]

*creating the predominant breastfeeding variable. 
recode feeding (0 4 5=0) (1/3=1), gen(predom)

*this matches the report of 77.5% for predominant breastfeeding
ta predom if age<6 [iw=v005/1000000]
Re: Calculating cases for IYCF [message #11532 is a reply to message #11531] Mon, 09 January 2017 09:19 Go to previous messageGo to next message
Roselync is currently offline  Roselync
Messages: 11
Registered: December 2016
Location: Taiwan
Member
Dear Bridget,
Thank you so much for the response and assistance, will use the code as stated and will give feedback

Regards,
Rose
Re: Calculating cases for IYCF [message #11554 is a reply to message #11532] Tue, 10 January 2017 08:55 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1000
Registered: February 2013
Senior Member
Following is an additional response from DHS Senior Research Associate, Shireen Assaf:

The denominator of 1656 is correct. In Table 11.3 this is the number of youngest children under age 2 (10th column), the 1698 is the number of all children under age 2 (12 column or last column). For matching the predominant feeding and complimentary feeding please use the provided code which creates the feeding variable and recodes this variable to obtain predominant feeding.
Re: Calculating cases for IYCF [message #11555 is a reply to message #11554] Tue, 10 January 2017 09:06 Go to previous messageGo to next message
Roselync is currently offline  Roselync
Messages: 11
Registered: December 2016
Location: Taiwan
Member
Dear Bridget,
Thank you so much for the clarification, I have cross checked in the report, its clear now. For the predominant and complementary feeding I also managed to get the rate that matches with the report. Thank you so much for the assistance, I really appreciate.

Regards,
Rose
Re: Calculating cases for IYCF [message #12184 is a reply to message #11531] Thu, 06 April 2017 07:32 Go to previous messageGo to next message
Roselync is currently offline  Roselync
Messages: 11
Registered: December 2016
Location: Taiwan
Member
Dear DHS team and colleagues,
I am trying to analyze data from the 2010 Malawi DHS using Stata and I am looking at the prevalence rate of child feeding practices like exclusive breastfeeding,predominant,early initiation of breast feeding, complementary feeding and bottle feeding which I managed to get through assistance rendered on this forum. To calculate predominant feeding and complementary feeding I was given the following syntax

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 var feeding feeding

*complimentary feeding is category #5 (+solids) and this matches the report for this age group which is 19.1%
ta feeding if age<6 [iw=v005/1000000]

*creating the predominant breastfeeding variable.
recode feeding (0 4 5=0) (1/3=1), gen(predom)

*this matches the report of 77.5% for predominant breastfeeding
ta predom if age<6 [iw=v005/1000000]

Now I was wondering if it is also possible to extract bottle feeding for 0-5 months which is 1.9% from the same variable "FEEDING" regardless of the fact that bottle feeding already exists as a separate variable(m38). My main issue is I want to be able to get a total of 100 when I add up complementary feeding,exclusive,predominant and bottle-feeding for 0-5 months. Your favorable assistance will be highly appreciated.

Regards,
Rose
Re: Calculating cases for IYCF [message #12190 is a reply to message #12184] Thu, 06 April 2017 14:33 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1000
Registered: February 2013
Senior Member

Following is a response from DHS Senior Research Associate, Shireen Assaf:


From what I understand from your question you would like to recode the feeding variable in a way that contains a category that is bottle feeding. However, none of the variables used to construct the feeding variable include the variable on whether the child was bottle fed or not. The feeding variable is only concerned with the types of food and not the mechanism the food was delivered. The closest thing I could think of was to recode it as follows:

recode feeding (0=0 "not breastfed") (1=1 ebf) (2/3=2 "liquid+water") (4=3 "other milk") (5=4 "complimentary feeding"), gen(feed2)

This would give you the categories of not-breastfed, exclusive breastfeeding, liquid+water, other milk, and complimentary feeding. Predominate feeding is the combination of ebf and liquid+water, so you could combine the categories 1 and 2 above if you are interested in having that category. Of course you could not have ebf and predominate breastfeeding as two separate categories since predominate breastfeeding includes the exclusive breastfeeding category. The "other milk" category can be the closest thing to bottle feeding perhaps, but I'm not sure about this. Here I am making the assumption that the children that are given other types of milk are given this milk through a bottle. However, really if you want to know about whether the child was bottle fed you need m38 but this would not be part of the feeding variable.

I guess my confusion is why you need this to total to 100, because the categories you mention are not mutually exclusive. For instance, bottle-feeding and predominant feeding may not separate as you could bottle feed the child with liquids other than milk.
Re: Calculating cases for IYCF [message #12199 is a reply to message #12190] Fri, 07 April 2017 11:01 Go to previous message
Roselync is currently offline  Roselync
Messages: 11
Registered: December 2016
Location: Taiwan
Member
Dear Bridgette,
Thank you so much for your response. It has been helpful. The reason why I needed the practices to total to 100 is that, I understand that these breastfeeding practices were extracted from the same population. For example, if we try to look at bottle feeding,predominant,exclusive breastfeeding and complementary feeding for 0-5 months, we find that it was extracted from the same population of 1656 yet when we try to combine these practices the total is about 101.4.So I guess my confusion was if the 'other milk' category as well as some components of complementary feeding and predominant feeding be the closest thing to bottle feeding. So I just wanted to be sure before I run a logistic regression with bottle feeding which happens to be one of the main outcomes(dependent variable).

Thanks,
Rose
Previous Topic: Vaccinations
Goto Forum:
  


Current Time: Sat May 27 15:22:27 Eastern Daylight Time 2017