** OPEN THE DATA **. *** I AM USING Stata DATA - I HAD NOT DOWNLOADED THE SPSS FILES (this code will also work for the SPSS file) ***. CD "C:\Users\User01\Documents\DHS DATA\NIGERIA_2018\NGKR7ADT". GET STATA FILE='NGKR7AFL.DTA'. DATASET NAME DataSet1 WINDOW=FRONT. ********************************************. ** GENERATE THE WEIGHT VARIABLE & WEIGHT DATA **. COMPUTE weight = V005/1000000. WEIGHT BY weight. ********************************************. ** PREPARE COMPLEX SURVEY VARIABLES **. COMPUTE psu = V021. COMPUTE strata = V023. ********************************************. ** RENAME A FEW VARIABLES TO BE USE IN ANALYSIS **. RENAME VARIABLES (V013 = age) (V149 = education) (V190 = wealth) (V025 = residence) (V024 = region). ********************************************. SORT CASES CASEID (A). STRING hhid (A12). COMPUTE hhid = SUBSTR(caseid,1,12). VARIABLE LABELS hhid "hhid". EXECUTE. ********************************************. ** REARRANGE DATA. ADD FILES FILE * /KEEP CASEID hhid ALL. EXECUTE. ********************************************. COMPUTE child_age = b19. RECODE child_age (0 THRU 1 = 1) (2 THRU 3 = 2) (4 THRU 5 = 3) (6 THRU 8 = 4) (9 THRU 11 = 5) (12 THRU 17 = 6) (18 THRU 23 = 7) (ELSE=SYSMIS) into child_age_grp. VALUE LABELS child_age_grp 1 "0-1" 2 "2-3" 3"4-5" 4 "6-8" 5 "9-11" 6 "12-17" 7 "18-23". VARIABLE LABELS child_age_grp 'Age group of child in months'. EXECUTE. ********************************************. * KEEP IF CHILD IS UNDER 24 MONTHS OLD AND LIVING WITH MOTHER. SELECT IF child_age LT 24 & B9 EQ 0. *SELECT IF B5 EQ 1. ********************************************. * FIND THE YOUNGEST CHILD LIVING WITH THE MOTHER FOR EACH MOTHER. SORT CASES BY V001 V002 V003. AGGREGATE /OUTFILE=* MODE=ADDVARIABLES /BREAK=V001 V002 V003 /MINBIDX "MINBIDX"=MIN(BIDX). EXECUTE. * NEED TO DROP THOSE THAT ARE BIDX EQ 2 AND MINBIDX EQ 1. SELECT IF (BIDX LE MINBIDX) . EXECUTE. ********************************************. * COMPONENTS OF CHILD FEEDING. *// Plain water. COMPUTE PlainW = 0. IF (V409 GE 1 & V409 LE 7 = 1) PlainW = 1. EXECUTE. *// Non milk . COMPUTE NonMilk = 0. IF (V410 EQ 1 OR V413 EQ 1) NonMilk = 1. IF (V412c GE 1 & V412c LE 7) NonMilk = 1. EXECUTE. *// Milk . COMPUTE Milk = 0. IF (V411 EQ 1 OR V411A EQ 1 OR V412A EQ 1 OR V414P EQ 1) Milk = 1. EXECUTE. *// Currently breastfeeding . COMPUTE CBreastF=0. IF (M4 = 95) CBreastF = 1. VALUE LABELS CBreastF 0"Not breastfeeding" 1"Currently breastfeeding". *// Ever bottle-fed . COMPUTE BF=0. IF (M38 = 1) BF = 1. VALUE LABELS BF 0"Not bottle-fed" 1"Ever bottle-fed". *// Complementary food . COMPUTE Complem = 0. IF (V414E EQ 1 OR V414F EQ 1 OR V414G EQ 1 OR V414H EQ 1 OR V414I EQ 1 OR V414J EQ 1 OR V414K EQ 1 OR V414L EQ 1 OR V414M EQ 1 OR V414N EQ 1 OR V414O EQ 1 OR V414P EQ 1 OR V414S EQ 1 OR V414V EQ 1) Complem = 1. IF V412A EQ 1 Complem = 1. EXECUTE. ********************************************. COMPUTE diet = 7. IF (PlainW EQ 0 & NonMilk EQ 0 & Milk EQ 0 & Complem EQ 0) diet = 0. IF (PlainW EQ 1 & NonMilk EQ 0 & Milk EQ 0 & Complem EQ 0) diet = 1. IF (NonMilk EQ 1 & Milk EQ 0 & Complem EQ 0) diet = 2. IF (Milk EQ 1 & Complem EQ 0) diet = 3. IF (Milk EQ 0 & Complem EQ 1) diet = 4. IF (Milk EQ 1 & Complem EQ 1) diet = 5. IF (CBreastF EQ 0) diet = 6. VARIABLE LABELS diet 'Breastfeeding status - checks'. EXECUTE. COMPUTE feeding = 1. IF (PlainW EQ 1) feeding = 2. IF (NonMilk EQ 1) feeding = 3. IF (Milk EQ 1) feeding = 4. IF (Complem EQ 1) feeding = 5. IF (CBreastF EQ 0) feeding = 0. VARIABLE LABELS feeding 'Breastfeeding status - final'. VALUE LABELS feeding 0"Not breastfeeding" 1"Exclusively breastfed" 2"Plain water" 3"Non-milk liquids" 4"Other milk" 5"Complementary foods". EXECUTE. ********************************************. * Breastfeeding prevalence. RECODE feeding (1 THRU 5 = 1) (0 = 0) INTO current_breast. VALUE LABELS current_breast 0 "Not breastfeeding" 1 "Breastfeeding". VARIABLE LABELS current_breast 'Currently breastfeeding'. EXECUTE. *creating the predominant breastfeeding variable. RECODE feeding (1 THRU 3 = 1) (0 4 5 = 0) INTO predom. VALUE LABELS predom 0 "Not predominant" 1 "Predominant". VARIABLE LABELS predom 'Predominantly breastfeeding'. EXECUTE. ** EVER BREASTFED **. RECODE M4 (94 = 0) (ELSE= 1) INTO EverBF. VALUE LABELS EverBF 0 "Not ever breastfed" 1 "Ever breastfed". VARIABLE LABELS EverBF 'Ever breastfed'. EXECUTE. ********************************************. ** EXCLUSIVE BREASTFEEDING. RECODE feeding (1 = 1) (ELSE= 0) INTO exclusive_feed. VALUE LABELS exclusive_feed 0 "Not exclusive" 1 "Exclusive". VARIABLE LABELS exclusive_feed 'Exclusive breastfeeding'. EXECUTE. ********************************************. SELECT IF feeding LE 5. ******************************************************************************************. ** SELECT ONLY CHILDREN AGED LESS THAN 6 MONTHS **. SELECT IF child_age LT 6. ********************************************. ** CHECK **. FREQUENCIES VARIABLES= exclusive_feed /ORDER=ANALYSIS. CROSSTABS /TABLES= child_age_grp BY exclusive_feed /FORMAT=AVALUE TABLES /CELLS=ROW /COUNT ROUND CELL. ******************************************************************************************.