 The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » How to find at least one malnourished in a household
How to find at least one malnourished in a household Tue, 09 June 2020 08:31  nilanjanpatra@gmail.com Messages: 7Registered: June 2020 Member
Dear Sir/ Ma'am,
I am working with NFHS-4 (India) household data file (IAHR71FL) with SPSS.
I need to find out the number of households with at least one (child or adult) malnourished for all-India.
For child malnutrition, I need Weight-for-Age (Underweight) for children below 5 years of age (below - 2 SD or above 2 SD).
For adult malnutrition, men age 15-54 and women age 15-49 who are not pregnant and who have not had a birth in the two months before the survey (BMI is not normal: less than 18.5 or more than 24.9).

Please help me to create SPSS syntax for the above-mentioned problem.

Thanks and regards,

Nilanjan Patra
Re: How to find at least one malnourished in a household [message #19393 is a reply to message #19386] Wed, 10 June 2020 07:14  nilanjanpatra@gmail.com Messages: 7Registered: June 2020 Member
I would like to know if my SPSS syntax is correct to see if at least one child in household is underweight.

DO IF (hv103\$01 = 1 & 0 <= hc1\$1 < 60) .
RECODE hc71\$1 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal1.
END IF .
EXECUTE .
fre chi_mal1.

DO IF (hv103\$02 = 1 & 0 <= hc1\$2 < 60) .
RECODE hc71\$2 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal2.
END IF.
EXECUTE.
fre chi_mal2.
DO IF (hv103\$03 = 1 & 0 <= hc1\$3 < 60) .
RECODE hc71\$3 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal3.
END IF.
EXECUTE.
fre chi_mal3.
DO IF (hv103\$04 = 1 & 0 <= hc1\$4 < 60) .
RECODE hc71\$4 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal4.
END IF.
EXECUTE.
fre chi_mal4.
DO IF (hv103\$05 = 1 & 0 <= hc1\$5 < 60) .
RECODE hc71\$5 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal5.
END IF.
EXECUTE.
fre chi_mal5.
DO IF (hv103\$06 = 1 & 0 <= hc1\$6 < 60) .
RECODE hc71\$6 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal6.
END IF.
EXECUTE.
fre chi_mal6.
DO IF (hv103\$07 = 1 & 0 <= hc1\$7 < 60) .
RECODE hc71\$7 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal7.
END IF.
EXECUTE.
fre chi_mal7.
DO IF (hv103\$08 = 1 & 0 <= hc1\$8 < 60) .
RECODE hc71\$8 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal8.
END IF.
EXECUTE.
fre chi_mal8.
DO IF (hv103\$09 = 1 & 0 <= hc1\$9 < 60) .
RECODE hc71\$9 (SYSMIS=SYSMIS) (-600 thru -200.5=1) (200.5 thru 600=1) (-200 thru 200=0) INTO chi_mal9.
END IF.
EXECUTE.
fre chi_mal9.

compute chi_mal=0.
if (chi_mal1=1 or chi_mal2=1 or chi_mal3=1 or chi_mal4=1 or chi_mal5=1 or chi_mal6=1 or chi_mal7=1 or chi_mal8=1 or chi_mal9=1 ) chi_mal=1.
val lab chi_mal 0'no' 1'yes'.
var lab chi_mal 'any child malnutrition'.
fre chi_mal.
 Previous Topic: How to find at least one malnourished in a household Next Topic: Sample size NDHS 2018
Goto Forum:

Current Time: Mon Jun 14 13:53:44 Coordinated Universal Time 2021