The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Minimum Meal frequency in BDHS 2014
Re: Minimum Meal frequency in BDHS 2014 [message #14176 is a reply to message #14175] Thu, 01 March 2018 11:15 Go to previous messageGo to previous message
Louis is currently offline  Louis
Messages: 3
Registered: February 2018
Location: Ghana
Member
actually this is the little i have been able to do.

clonevar age= v222
codebook b9_01
keep if age<24
keep if b9_01==0
tab b9_01
drop if _n > 0 & caseid == caseid[_n-1]
drop if age <6
tab m4_1
codebook m4_1
*Weighting
gen v005_wgt= v005/1000000

*Age group recoding
*NB; clonevar age already deifned @ 26
recode age (6/8=1 "6-8")(9/11=2 "9-11") (12/17=3 "12-17") (18/23=4 "18-23"), gen (age_g)

*recode of m4_1 as number of breastfed and number of nonbreastfed children 6-23months
recode m4_1 (93/94=0 "Number of non-breastfed children 6-23 months") (95=1 "Number of breastfed children 6-23 months"), gen (still_feeding)
replace still_feeding=0 if still_feeding==.


*****MINIMUM DIETARY DIVERSITY MMD*****
*** MDD 7 food groups**
capture drop grpa
gen grpa=1 if v411a==1| v411==1|v414p==1|v414v==1
label value grpa grpa
tab grpa
capture drop grpb
gen grpb=1 if v414e==1| v414f==1| v412a==1
label value grpb grpb
tab grpb
capture drop grpc
gen grpc=1 if v414k==1| v414i==1| v414j==1
label value grpc grpc
tab grpc
capture drop grpd
gen grpd=1 if v414l==1
label value grpd grpd
tab grpd
capture drop grpe
gen grpe=1 if v414g==1
label value grpe grpe
tab grpe
capture drop grpf
gen grpf=1 if v414h==1| v414m==1|v414n==1
label value grpf grpf
tab grpf
capture drop grpg
gen grpg=1 if v414o==1
label value grpg grpg
tab grpg
** 7 Food groups***
egen dietd = rsum(grpa grpb grpc grpd grpe grpf grpg) if grpa~=.| grpb~=.| grpc~=.| grpd~=.| grpe~=.| grpf~=.| grpg~=.
** 4+ Foods FOR ALL CHILDREN***
recode dietd (1/3 .=0 "Not diverse") (4/7=1 "Diverse"), gen(diet4)
ta diet4 [iw=v005/1000000]
label value diet4 diet4
label var diet4 " Minimum dietary diversity"
tab diet4

**MDD for breastfed children**
gen mdd1=.
replace mdd1=1 if diet4==1& still_feeding==1
replace mdd1=0 if diet4==0 & still_feeding==1
label define mdd1 0"Not Diverse" 1"Diverse"
label values mdd1 mdd1
label var mdd1 " Minimum dietary diversity for Breastfed children"
tab mdd1
***MDD for nonbreastfed children***
gen mdd0=.
replace mdd0=1 if diet4==1& still_feeding==0
replace mdd0=0 if diet4==0 & still_feeding==0
label define mdd0 0"Not Diverse" 1"Diverse"
label values mdd0 mdd0
label var mdd0 " Minimum dietary diversity for nonbreastfed children"
tab mdd0

tab age_g diet4 [iw=v005/1000000], r
tab age_g mdd1 [iw=v005/1000000], r
tab age_g mdd0 [iw=v005/1000000], r


******* MINIMUM MEAL FREQUENCY MMF *******
*Minimum meal freq for group1*
capture drop mm1
gen byte mm1=.
replace mm1=1 if m39_1>=2 & still_feeding==1
replace mm1= 0 if m39_1<2 & still_feeding==1
tab mm1
label define mm1 0 "Not Freq" 1"Freq"
label values mm1 mm1
tab mm1
*Minimum meal freq for breastfed children aged 6-8months*
gen byte mmf1=.
replace mmf1=1 if mm1==1& age_g==1
replace mmf1=0 if mm1==0 & age_g==1
label define mmf1 0 "Not Freq" 1 "Freq"
label values mmf1 mmf1
tab mmf1
tab age_g mmf1,r
*Minimum meal freq for group2*
capture drop mm2
gen byte mm2=.
replace mm2=1 if m39_1>=3 & still_feeding==1
replace mm2= 0 if m39_1<3 & still_feeding==1
label define mm2 0 "Not Freq" 1"Freq"
label values mm2 mm2
tab mm2
*Minimum meal freq for breastfed children aged 9-11months*
capture drop mmf2
gen byte mmf2=.
replace mmf2=1 if mm2==1& age_g==2
replace mmf2=0 if mm2==0 & age_g==2
label define mmf2 0 "Not Freq" 1 "Freq"
label values mmf2 mmf2
tab mmf2
tab age_g mmf2,r
*Minimum meal freq for breastfed children aged 12-17months*
capture drop mmf3
gen byte mmf3=.
replace mmf3=1 if mm2==1& age_g==3
replace mmf3=0 if mm2==0 & age_g==3
label define mmf3 0 "Not Freq" 1 "Freq"
label values mmf3 mmf3
tab mmf3
tab age_g mmf3,r
*Minimum meal freq for breastfed children aged 18-23months*
capture drop mmf4
gen byte mmf4=.
replace mmf4=1 if mm2==1& age_g==4
replace mmf4=0 if mm2==0 & age_g==4
label define mmf4 0 "Not Freq" 1 "Freq"
label values mmf4 mmf4
tab mmf4
tab age_g mmf4,r
**Minimum meal freq for breastfed children aged 6-23months combined*
capture drop mmfb
egen byte mmfb= rowtotal (mmf1 mmf2 mmf3 mmf4), missing
label define mmfb 0 "Not Freq" 1 "Freq"
label values mmfb mmfb
tab mmfb
tab age_g mmfb,r
tab age_g mmfb [iweight=v005_wgt], r


****MMF FOR NON-BREASTFED CHILDREN***

** GENERATING MILK OR MILK PRODUCTS**
tab1 v411 v411a v414v, m
capture drop milk
gen byte milk= v411+ v411a +v414v
label var milk "Milk or milk products"
tab milk

** Non breastfed MMF proper**
egen sm= rowtotal (m39_1 milk), missing
tab sm
capture drop mmfn
gen byte mmfn=.
replace mmfn=1 if sm>=4 & still_feeding==0
replace mmfn=0 if sm<4 & still_feeding==0
label define mmfn 0 "Not Freq" 1 "Freq"
label values mmfn mmfn
tab mmfn
tab age_g mmfn [iweight=v005_wgt], r
label var mmfn " Minimum meal frequency for non-breastfed children 6-23 months"


**Total minimum meal frequency for all children 6-23 months**
egen MMF= rowtotal (mmfb mmfn), missing
label var MMF " Minimum meal frequency for all children 6-23 months"
label values MMF MMF
label define MMF 0" Not Freq" 1" Freq"
tab MMF
tab age_g MMF [iweight=v005_wgt], r


my problem now is how to generate the breast milk, milk or milk products to match the values in the report.

Sincerely,
Louis
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Turkey 2008 child weight and height
Next Topic: Merge two data set
Goto Forum:
  


Current Time: Mon Nov 18 13:39:02 Coordinated Universal Time 2024