/***************************************************************************** This do file merges together all the endline data from SPOON GUATEMALA to creates complete datasets at the household, child, and caregiver level Updated on 8/25/2022 *****************************************************************************/ ******************** MERGE DATA FILES **************************** ** CHILD DATA SET ** * all children (n=1638) // 1314 households use "${el_processed}/demographics_el.dta", clear sort folio personid keep folio personid communityid id_caregiver id_persona male age bday dad_house mom_house momID dadID twin child_order merge 1:1 personid using "${el_processed}/practice_el.dta" keep if _merge==3 // only those with practice information drop _merge merge m:1 folio using "${el_processed}/household_el.dta", keepusing(T1 T2 Control tratamiento* bl_only el_only population attrited fecha_ini comunidad_elegible) keep if _merge==3 drop _merge * Age in days, based on birthday gen edad_dias= fecha_ini - bday label var edad_dias "Edad en dias" * Re-label variables in english *Treatment lab var T1 "T1: SQ-LNS + behavior change" lab var T2 "T2: MNPs + behavior change" lab var Control "Control: MNPs" *Demographics label var agemonths "Age (months)" label var male "Male=1" *label var married "Married=1" label var dad_house "Dad lives at home" * Practices label var p1 "Early initiation of breastfeeding" label var p2a "Exclusive breastfeeding under 6 months" label var p3 "Ever breastfed" label var p5 "Introduction of solid, semi-solid or soft foods" label var p4a "Continued breastfeeding until 1 year old" label var p4b "Continued breastfeeding until 2 years old" label var p6 "Consumption of iron-rich or iron-fortified foods" label var p7 "Given vitamin A during last 12 months" label var p8 "Given powdered vitamins and minerals in last 12 months" label var p9 "Recieved Vitacereal in last 12 months" label var p15 "Duration of breastfeeding (months)" label var p14 "No bottle feeding" label var p12a "Minimum dietary diversity" label var p12b "Minimum dietary diversity (foods score >= 5)" label var p12c "Minimum dietary diversity (foods score >= 6)" label var p12d "Minimum dietary diversity (foods score >= 7)" label var p13 "Consumption of iron-rich or iron-fortified food" label var p10 "Verbal stimulation" label var p11 "Additional stimulation" lab var practice_index "Practice index" save "${el_processed}/child_all_el.dta", replace // includes all children with practice information * Target children -- subset of children with anthro data AND in the defined age interval (n=1290) use "${el_processed}/child_all_el.dta", clear merge 1:1 folio id_persona using "${el_processed}/endline_anthro.dta" drop _merge save "${el_processed}/child_all_el.dta", replace keep if target1==1 save "${el_processed}/child_target_el.dta", replace *CAREGIVER DATA SET use "${el_processed}/demographics_el.dta", clear keep folio personid communityid id_caregiver mom momID id_persona male age educ_prim_c age indigenous married read write work educ_prim* educ_sec* merge m:1 folio using "${el_processed}/household_el.dta", keepusing(T1 T2 Control tratamiento* bl_only el_only population attrited comunidad_elegible) // _merge ==1 are none // _merge ==2 are from using (354, most incomplete/missing surveys ) drop if _merge==2 drop _merge merge 1:1 personid using "${el_processed}/dec-grit-rosenberg_el.dta", gen(mom_merge) merge 1:1 folio id_persona using "${el_processed}/knowledge_el.dta", gen(know_merge) tab mom mom_merge, m tab mom know_merge, m preserve keep if know_merge==3 save "${el_processed}/caregiver_all_el.dta", replace restore // this is mom indicator from endline prep, includes mothers of all children in demographics data egen mom_test = max(mom), by(folio) ** save only moms of target children * first identify households with target children merge 1:1 personid using "${el_processed}/child_target_el.dta", keepusing(personid target1) drop _merge * find moms of just the target children egen max_child=max(target1), by(folio) * new indicator just using these children gen momID_child=momID if target1==1 egen max_momID=max(momID_child), by(folio) egen min_momID=min(momID_child), by(folio) // in case there is more than one child/mom in house gen mom_sub=1 if id_persona==max_momID | id_persona==min_momID distinct folio if max_child==1 & max_momID==. * some households don't have mother IDs recorded... assume mom is one that completed knowledge questions tab mom_sub mom_merge, m tab mom_sub know_merge, m // 5 "moms" that are not in knowledge, dec, grit, rosenberg data... // 86 "moms" that ARE in knowledge, dec, grit, rosenberg data that were not counted... * see which households have knowledge survey responses but not target children... egen know_test = max(know_merge), by(folio) tab know_test max_child, m * if there is a target child in house and knowledge survey was completed assume the person who completed survey is mom egen mom_sub_test = max(mom_sub), by(folio) count if know_merge==3 & mom_sub_test==. & max_child==1 & max_momID==. // 17 moms replace mom_sub=1 if max_child==1 & know_merge==3 & mom_sub_test==. // a couple with more than one mom who answered - 61091, 5120141; keep drop mom_sub_test egen mom_sub_test = max(mom_sub), by(folio) // re-code after replacement duplicates tag folio target1 momID, gen(dup_child) // 12 kids with same mom replace dup_child=. if target1==. gen know_complete=1 if know_merge==3 duplicates tag folio know_complete, gen(dup_know) count if dup_know>0 & know_merge==3 & max_child==1 & mom_sub_test==. * save target ID at household level gen targetID = id_persona if target1==1 egen target_max = max(targetID), by(folio) egen target_min = min(targetID), by(folio) * more simple indicator -- anyone that completed knowledge survey AND has target child in household (allows for non-mom caregivers) gen caregiver = 1 if know_merge==3 & max_child==1 /// 17 are male keep if caregiver==1 // 5 male drop id_caregiver gen double id_caregiver = id_persona if caregiver==1 * two caregivers in house 5120141, only one actually has answers for knowledge survey; keep drop if folio==5120141 & id_persona==1 * Re-label variables in English *Treatment lab var T1 "T1: SQ-LNS + behavior change" lab var T2 "T2: MNPs + behavior change" lab var Control "Control: MNPs" *Demographics label var age "Age (years)" label var indigenous "Indigenous=1" label var married "Married=1" label var read "Read=1" label var educ_prim_i "Primary school incomplete=1" label var educ_prim_c "Primary school complete=1" label var educ_sec_c "High school complete=1" label var work "Works=1" label var write "Write=1" label var decisiones "Decision-making power" label var grit "Grit score" label var rosenberg "Rosenberg score" *Knowledge gen know_diarheasignal=. label var know_diarheasignal "Risk signs in children with diarhea" label var know_diarheasignal_dehydr "Dehydration" label var know_diarheasignal_irritable "Fidgeting and irritability" label var know_diarheasignal_blood "Presence of blood in stool (dysentery)" label var know_diarheasignal_deepeyes "Droopy nozzle / Deep eyes" label var know_diarheasignal_lowurine "Little urine, no urine / crying no tears" label var know_diarheasignal_pliegue "Presence of the ''pliegue'' sign" label var know_diarheasignal_freqdeposit "Frequent depositions / copious depositions" label var know_diarheasignal_decay "Accentuated decay (children without energy)" gen know_dangerflu=. label var know_dangerflu "Risk signs in children with the flu" label var know_dangerflu_fastbreathe "Fast or short breath" label var know_dangerflu_whistle "Whistle while breathing" label var know_dangerflu_chestheat "Chest boil" label var know_dangerflu_twodayfever "High fever for more than 2 days" label var know_dangerflu_deeprib "Ribs sinking" label var know_dangerflu_ingestdig "Difficulty drinking and/or eating" gen know_dangerskin=. label var know_dangerskin "Risk signs in children skin diseases" label var know_dangerskin_dry "Abundant dry skin" label var know_dangerskin_itch "Constant burning or itching" label var know_dangerskin_rash "Presence of rashes or discharge" label var know_dangerskin_sores "Presence of sores" gen know_feedsick=. label var know_feedsick "How to feed a less than 2 years old sick child" label var know_feedsick_lessfood "Give less food than normal" label var know_feedsick_equalfood "Give same amount of food as normal" label var know_feedsick_morefood "Give more food than normal" label var know_feedsick_lessliquid "Give more liquids than normal" label var know_feedsick_equalliquid "Give same amount of liquids as normal" label var know_feedsick_moreliquid "Give more liquids than normal" label var know_feedsick_lessmilk "Give less breastmilk than normal" label var know_feedsick_equalmilk "Give same amount of breastmilk as normal" label var know_feedsick_moremilk "Give more breastmilk than normal" gen know_distribute=. label var know_distribute "Food distirbution critear among family members" label var know_distribute_econ "Economic contribution to the household" label var know_distribute_work "The work that each one does" label var know_distribute_age "Ages of members" label var know_distribute_foodneed "Food and nutrient needs" label var know_distribute_preference "Liking certain foods" label var know_distribute_tradition "By custom or family tradition" gen know_agebreastfeed=. label var know_agebreastfeed_months "Maximum age to exclusively breastfeed a child" gen know_whynewborncalostro=. label var know_whynewborncalostro "First milk from mother after birth" label var know_whynewborncalostro_avail "Always available" label var know_whynewborncalostro_famecon "Benefits the family economy" label var know_whynewborncalostro_MELA "Benefits the recovery of the mother" label var know_whynewborncalostro_nutrient "Child recieves all nutrients that they need" label var know_whynewborncalostro_defense "Child recieves defenses for their entire life" label var know_whynewborncalostro_lesssick "Child gets sick less frequently" label var know_whynewborncalostro_vaccine "It is like a first vaccine" gen know_freqbreastfeed=. label var know_freqbreastfeed "Frequency of breasfteed to child between 0 and 6 months old" label var know_freqbreastfeed_want "Whenever the baby wants" label var know_freqbreastfeed_hunger "Whenever the baby looks like they are hungry" label var know_freqbreastfeed_cry "Whenever the baby cries" gen know_knowhundry=. label var know_knowhundry "How to know if a baby is hungry" label var know_knowhundry_lickfinger "When the baby sucks their fingers" label var know_knowhungry_restless "When the baby is restless" label var know_knowhungry_seekbreast "When the baby looks for the breast" label var know_knowhungry_cry "When the baby starts to cry" gen know_lowmilk=. label var know_lowmilk "What to do if a mother of a <6 months old baby doesn't have enough milk" label var know_lowmilk_morefreq "Breastfeed more often" label var know_lowmilk_otherliquid "Give the baby other liquids or food" label var know_lowmilk_hydrate "Mother needs to drink more water" label var know_lowmilk_moreliquid "Mother needs to drink more liquids" label var know_lowmilk_eatmore "Mother should eat more" label var know_lowmilk_betterfood "Mother should eat better" label var know_lowmilk_boxedmilk "Give boxed milk" gen know_notwithbaby=. label var know_notwithbaby "What to feed to the baby if mother can't be around" label var know_notwithbaby_breastmilk "Breastmilk" label var know_notwithbaby_boxedmilk "Boxed milk" label var know_notwithbaby_formula "Mil in special formula for babies" label var know_notwithbaby_cowmilk "Cow milk" label var know_notwithbaby_goatmilk "Goat milk" label var know_notwithbaby_pump "Self milking" label var know_notwithbaby_nothing "Nothing" gen know_ageotherliquid=. label var know_ageotherliquid_age "Age to start giving liquids other than breastmilk" gen know_agesolidfood=. label var know_agesolidfood_age "Age to start giving food" gen know_rznbreastmilk=. label var know_rznbreastmilk "Reasons to give <6 months old baby only breastmilk" label var know_rznbreastmilk_protect "Protect the baby from disease" label var know_rznbreastmilk_grow "Helps the baby grow better" label var know_rznbreastmilk_completefood "Breastmilk contains everything a baby needs" label var know_rznbreastmilk_notpregnant "Mother is less likely to get pregnant" label var know_rznbreastmilk_periodstop "Stop mother's period" label var know_rznbreastmilk_safe "Breastmilk is clean, safe and convenient" label var know_rznbreastmilk_cheap "Breastmilk is cheap" label var know_rznbreastmilk_lowexpense "Reduce medial expenses" label var know_rznbreastmilk_cantchew "Because the baby can't chew (baby has no teeth)" label var know_rznbreastmilk_medadvice "Medical advice" gen know_maxagebreastfeed=. label var know_maxagebreastfeed_age "Maximum age to breastfeed the baby" gen know_milkplusfood=. label var know_milkplusfood "Importance of giving a <6 months old baby complementary foods" label var know_milkplusfood_morefood "Get more food" label var know_milkplusfood_addnutrient "Get nutrients that the breastmillk falls short of" label var know_milkplusfood_newfood "Know new foods" label var know_milkplusfood_adaptmixed "Adapts to receive a mixed diet" label var know_milkplusfood_adaptfamily "Adapts to the food the family eats" label var know_milkplusfood_newsmell "Learns other smells and flavors" gen know_timewashhands=. label var know_timewashhands "Time to wash hands" label var know_timewashhands_eat "Before eating" label var know_timewashhands_toilet "After going to the toilet" label var know_timewashhands_feed "Before giving food to the baby" label var know_timewashhands_diapers "After changing diapers or cleaning the baby" label var know_timewashhands_cook "Before preparing and touching food" gen know_washhands=. label var know_washhands "How to wash hands" label var know_washhands_soap "Soap" label var know_washhands_detergent "Detergent (powder)" label var know_washhands_liqsoap "Liquid soap" label var know_washhands_ash "Ashes" label var know_washhands_alcohol "Alcohol in gel" gen know_purewater=. label var know_purewater "How to purify water" label var know_purewater_boil "Boil" label var know_purewater_chlorine "Treat with chlorine" label var know_purewater_SODIS "SODIS method" label var know_purewater_iodine "Treat with iodine" label var know_purewater_filter "Filter" gen know_malnutrition=. label var know_malnutrition "Main causes of malnutrition" label var know_malnutrition_insuffood "Food is insuficient" label var know_malnutrition_irregeat "Eat at irregular times" label var know_malnutrition_illness "Diseases" label var know_malnutrition_stopbreast "Abrupt breastfeed stop" label var know_malnutrition_careless "The baby is not being given food with care" label var know_malnutrition_novariety "There is no variety in their diet" label var know_diarheasignal_score "Risk signs in children with diarrhea" label var know_dangerflu_score "Risk signs in children with cold" label var know_dangerskin_score "Risk signs in children with skin diseases" label var know_feedsick_score "How to feed a less than 2 years old sick child" label var know_distribute_score "Food distirbution critear among family members" label var know_agebreastfeed_score "Maximum age for exclusive breastfeed" label var know_firstbreastfeed_score "Time between birth and first breastfeed" label var know_newborncalostro_score "First milk from mother after birth" label var know_whynewborncalostro_score "Importance of first milk from mother after birth" label var know_freqbreastfeed_score "Frequency of breasfteed to child between 0 and 6 months old" label var know_knowhungry_score "How to know if a baby is hungry" label var know_lowmilk_score "What to do if a mother of a <6 months old baby doesn't have enough milk" label var know_breastfeedagain_score "Can a mother that breastfeeds a <6 months old baby keep feeding if gets pregnant again" label var know_notwithbaby_score "What to feed to the baby if mother can't be around" label var know_ageotherliquid_score "Minimum age to give liquids other than breastmilk" label var know_agesolidfood_score "Minimum age to give solid food to baby" label var know_rznbreastmilk_score "Reasons to give <6 months old baby only breastmilk" label var know_maxagebreastfeed_score "Maximum age to breastfeed a child" label var know_milkplusfood_score "Importance of giving a <6 months old baby complementary foods" label var know_whichfood68_score "Type of food for 6-8 months old child" label var know_whichfood911_score "Type of food for 9-11 months old child" label var know_whichfood12_score "Type of food for 12+ months old child" label var know_quantfood68_score "Amount of food for 6-8 months old child" label var know_quantfood911_score "Amount of food for 9-11 months old child" label var know_quantfood12_score "Amount of food for 12+ months old child" label var know_freqfood68_score "Feeding frequency for 6-8 months old child" label var know_freqfood911_score "Feeding frequency for 9-12 months old child" label var know_freqfood12_score "Feeding frequency for 12+ months old child" label var know_timewashhands_score "Time to wash hands" label var know_washhands_score "How to wash hands" label var know_actsick_score "What to do when child presents signs of danger: diarrhea, cold, skin diseases" label var know_purewater_score "How to purify water" label var know_malnutrition_score "Main causes of malnutrition" lab var knowledge_indexV1 "Knowledge index" lab var knowledge_indexV2 "Weighted knowledge index" *Decisions label var d1 "Decisions about food in the house" label var d2 "Decisions about mother's clothes" label var d3 "Decisions about spouse's clothes" label var d4 "Decisions about children's clothes" label var d5 "Decisions about children's education" label var d6 "Decisions about children's health" label var d7 "Decisiones about household expenses" label var d8 "Decisions about giving money to mom's parents" label var d9 "Decisions about giving money to spouse's parents" label var d10 "Decisions about mom's work" label var d11 "Decisions about spouse's work" label var d12 "Decisions about where to live" label var d13 "Decisions about contraception, if any" label var d14 "Decisions about prenatal care" label var d15 "Decisions about papanicolau exam" label var d16 "Decisions about place of delivery" label var decisiones "Decision-making power" save "${el_processed}/caregiver_target_el.dta", replace * HOUSEHOLD DATA SET use "${el_processed}/household_el.dta", clear *Treatment lab var T1 "T1: SQ-LNS + behavior change" lab var T2 "T2: MNPs + behavior change" lab var Control "Control: MNPs" *Household Composition lab var size "Number of members" lab var prop_males0_5 "Proportion of males 0-5 years" lab var prop_males6_18 "Proportion of males 6-18 years" lab var prop_males19_49 "Proportion of males 19-49 years" lab var prop_males50 "Proportion of males 50+ years" lab var prop_females0_5 "Proportion of females 0-5 years" lab var prop_females6_18 "Proportion of females 6-18 years" lab var prop_females19_49 "Proportion of females 19-49 years" lab var prop_females50 "Proportion of females 50+ years" *Assets label var improved_water "Improved water indicator (WHO standard)" label var improved_sanitation "Improved sanitation indicator (WHO standard)" label var tv "Television" label var cable "Cable TV antena" label var radio "Radio / Sound system" label var homephone "Landline phone" label var cellphone "Cellphone" label var stove "Stove" label var fridge "Fridge" label var washer "Washing machine" label var ac "Air conditioner unit" label var sewing_machine "Sewer machine" label var computer "Computer" label var car "Car" label var boat "Boat" label var motorcycle "Motorcycle" label var bicycle "Bicycle" label var electricity "Electric plant / Solar panels" label var wealth "Wealth index" label var inc_h "Household monthly income" * first identify households with target children merge 1:m folio using "${el_processed}/child_target_el.dta", keepusing(target1) drop if _merge==1 // drop those not in target file drop _merge duplicates drop //dropped 14 duplicate households (2 kids) save "${el_processed}/household_target_el.dta", replace