*Use IAKR71FL.DTA

*Declare survey data
gen wt=v005/1000000
svyset v001 [pweight=wt], strata(v022) vce(linearized) singleunit(missing) || v002

*Keep children under 2
gen age=v008-b3
keep if age<24

* Child lives with respondent, not elsewhere
keep if b9==0
bysort v001 v002 v003: egen minbidx=min(bidx) 
* Need to drop those that are bidx==2 and minbidx==1
drop if bidx>minbidx

** Exclusive breast feeding
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)

gen ebf=0 
replace ebf=1 if diet==0 
lab de A 0 "No" 1 "Yes"
la val ebf A
lab var ebf "Exclusive BF"

** For matching Table 62, page 112 for exclusive breastfeeding in 0-5 month children in MP**      
ta ebf if age<6 & v024==19 [iw=v005/1000000] 
ta ebf if age<4 & v024==19 [iw=v005/1000000] 
ta ebf if age>=6 & age<=9 & v024==19 [iw=v005/1000000] 
ta ebf if age>=12 & age<=15 & v024==19 [iw=v005/1000000] 
ta ebf if age>=12 & age<=23 & v024==19 [iw=v005/1000000] 

bysort v001 v002 v003: egen minbidx=min(bidx) 
* Need to drop those that are bidx==2 and minbidx==1
drop if bidx>minbidx