*// [ OPEN THE DATA - PR RECODE FILE (MWPR7HFL) ] **.
** CHILD NUTRITIONAL STATUS.
** Table 11.1 Nutritional status of children.
** MALAWI DHS 2015-16 **.
** **.
GET
  FILE='C:\Users\User1\Documents\MW_2015-16_DHS_05242018_253_52565\MW_2015-16_DHS_03042019_835_52565_SPSS\MWPR7HSV\MWPR7HFL.SAV'.
DATASET NAME DataSet1 WINDOW=FRONT.

************************************************************************************************************************************.

** WEIGHT VARIABLE.
COMPUTE weight = hv005/1000000.

WEIGHT BY weight.

** COMPLEX SURVEY VARIABLES.
COMPUTE psu = hv021.
COMPUTE strata = hv023.

************************************************************************************************************************************.

RENAME VARIABLES (hc27 = sex) (hv270 = wealth) (hv025 = residence) (hv024 = region).

************************************************************************************************************************************.

** CHILD AGE IN MONTHS.
RECODE hc1 (0 THRU 5 = 1) (6 THRU 8 = 2) (9 THRU 11 = 3) 
(12 THRU 17 = 4) (18 THRU 23 = 5) (24 THRU 35 = 6) (36 THRU 47 = 7) 
(48 THRU 59 = 8) INTO child_age.
VARIABLE LABELS child_age 'Child age (months)'.
EXECUTE.
VALUE LABELS child_age 1 "0-5 months" 2 "6-8 months" 3 "9-11 months" 4 "12-17 months" 5 "18-23 months" 6 "24-35 months" 7 "36-47 months" 8 "48-59 months".

SELECT IF child_age  LE 8.

************************************************************************************************************************************.

** STUNTING = Height-for-age.
COMPUTE stunting=$SYSMIS.
      IF hv103=1 stunting=0.
      IF missing(hc70) stunting=$SYSMIS.
      IF (hc70>=9996) stunting= $SYSMIS.
      IF (hc70 LT -200 AND hv103=1) stunting = 1.
EXECUTE.
VARIABLE LABELS stunting 'Stunting children'.
VALUE LABELS stunting 0 "Not stunting" 1 "Stunting" .

************************************************.
COMPUTE ND = V445/100.
RECODE ND (0 thru 18.49=1) (18.50 thru 24.99=2) (25.00 thru 59.99 =3) (ELSE=SYSMIS) INTO BMI.
VARIABLE LABELS BMI "Mother's BMI".
EXECUTE.

DO IF ((HC70 < 9996) & (V213 = 0) & (V222 > 1) & (HV103 = 1) & (V015 = 1) & (V447 = 0)).
COUNT FW=HC70(Lowest thru -201).
END IF.
EXECUTE.

SORT CASES BY BMI.
SPLIT FILE LAYERED BY BMI.

Frequencies FW. 

************************************************************************************************************************************.

** WASTING = Weight-for-height.
COMPUTE wasting=$SYSMIS.
      IF hv103=1 wasting=0.
      IF missing(hc72) wasting=$SYSMIS.
      IF (hc72>=9996) wasting= $SYSMIS.
      IF (hc72 LT -200 AND hv103=1) wasting = 1.
EXECUTE.
VARIABLE LABELS wasting 'Wasting children'.
VALUE LABELS wasting 0 "Not wasting" 1 "Wasting" .

************************************************************************************************************************************.

** UNDERWEIGHT = Weight-for-age.
COMPUTE underweight=$SYSMIS.
      IF hv103=1 underweight=0.
      IF missing(hc71) underweight=$SYSMIS.
      IF (hc71>=9996) underweight= $SYSMIS.
      IF (hc71 LT -200 AND hv103=1) underweight = 1.
EXECUTE.
VARIABLE LABELS underweight 'Underweight children'.
VALUE LABELS underweight 0 "Not underweight" 1 "Underweight" .

************************************************************************************************************************************.
************************************************************************************************************************************.
************************************************************************************************************************************..
************************************************************************************************************************************.
************************************************************************************************************************************.

SELECT IF stunting LE 1.

** CHECK.
FREQUENCIES VARIABLES= stunting
  /ORDER=ANALYSIS.

************************************************************************************************************************************.

CROSSTABS
  /TABLES=child_age sex wealth residence region BY stunting
  /FORMAT=AVALUE TABLES
  /CELLS=ROW
  /COUNT ROUND CELL.

************************************************************************************************************************************.