The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » matching data with the report
Re: matching data with the report [message #14984 is a reply to message #14834] Wed, 23 May 2018 13:37
 Bridgette-DHS Messages: 2270Registered: February 2013 Senior Member

Following is a response from DHS Technical Specialist, Rukundo Benedict:

Dear User,

It sounds like you need ensure that you are selecting the sample correctly. The code below provides some guidance. Also note that for the 2016 Ethiopia DHS you will need to use b19 for age (i.e. months=b19).

```For diet, the sample is among youngest children 6-23mo living with the mother
*// Age of the child in months .
COMPUTE months = (V008 - B3 ).
RECODE Months (0,1 = 1) (2,3 = 2) (4,5=3) (6,7,8=4) (9 thru 11 = 5) (12 thru 17=6) (18 thru 23=7) (24 thru 35 = 8) (36 thru 47=9) (48 thru 59=10) INTO ChAge.
VARIABLE LABELS ChAge "Age in months".
VALUE LABELS ChAge 1"0-1" 2"2-3" 3"4-5" 4"6-8" 5"9-11" 6"12-17" 7"18-23" 8"24-35" 9"36-47" 10"48-59".

*// Selecting living children 6-59 .
SELECT IF ( months >= 6 & months <= 59 & B5 = 1).

*// Weighting table.
COMPUTE rweight = V005 / 1000000.
WEIGHT BY rweight.

*// eggs, any meat, organ meat, fish/shellfish.
IF ( V414G=1 | V414H=1 | V414M=1 | V414N=1) MeatF = 1.
*// fruits & vegetables rich in vitamin A.
IF ( V414I = 1 | V414J =1 | V414K=1 ) Fruits = 1.

*// Percentage who consumed foods rich in vitamin A in past 24 hours1 .
IF ( Fruits = 1 | MeatF ) VitaminA = 1.
VARIABLE LABELS VitaminA "Percentage who consumed foods rich in vitamin A in past 24 hours1".
*// Percentage who consumed foods rich in iron in past 24 hours 2.
IF ( MeatF = 1 ) Iron = 1.
VARIABLE LABELS Iron "Percentage who consumed foods rich in iron in past 24 hours2".
*// Number of children 6-23.
IF ( Youngest > 0 ) Chld623 = 1.
VARIABLE LABELS chld623  "".
VALUE LABELS chld623  1"Number of children".
IF ( Youngest > 0 ) Label1 = 1.
VARIABLE LABELS Label1  "".
VALUE LABELS Label1  1"Among youngest children age 6-23 months living with the mother:".

For supplements, the sample is all children age 6-59 months
*//  Vitamin A date in months .
IF ( H33M >= 1 & H33M <= 12 & H33Y >= 2006 & H33Y <= 2020) VAdate = V008 - (( H33Y-1900) *12 + H33M).
IF ( VAdate <= 6 ) LastVA = 1.
*//  vitamin A and salt for living children .
+ IF ( LastVA = 1 | H34 = 1 ) VAsupple = 1.
VARIABLE LABELS VAsupple "Percentage given vitamin A supplements in past 6 months".
*// Percentage given iron supple- ments in past 7 days.
+ IF ( H42= 1 ) Iron7day = 1.
VARIABLE LABELS Iron7day "Percentage given iron supple- ments in past 7 days".
IF ( Months >= 6 & Months <= 59 & B5 = 1 ) Chld659 = 1.
VARIABLE LABELS Chld659 "Number of children".

For iodized salt, it is only children 6-59 months living in a household tested for iodized salt:
*//  children 6-59 & household salt tested.
+ IF (HV234A = 1) Iodine = 1.
VARIABLE LABELS Iodine "Percentage living in house holds with iodized salt4".
*// Number of children 6-59 living in HH tested for iodine.
IF ( Months >= 6 & Months <= 59 & B5 = 1 & HV234A >= 0 & HV234A <= 1 ) IodineHH = 1.
VARIABLE LABELS IodineHH "".
VALUE LABELS IodineHH 1"Number of children".
IF ( Months >= 6 & Months <= 59 & B5 = 1 & HV234A >= 0 & HV234A <= 1 ) Label3 = 1.
VARIABLE LABELS Label3  "".
VALUE LABELS Label3  1"Among children age 6-59 months living in households tested for iodized salt:".
```

In response to your second question, the DHS does not collect data on the quantity of food consumed by children 6-23months; we collect data only on the types of foods and liquids consumed by children in the previous 24hrs.

 matching data with the report By: Fana on Tue, 08 May 2018 11:49 Re: matching data with the report By: Bridgette-DHS on Wed, 23 May 2018 13:37 Re: matching data with the report By: Hassen on Thu, 24 May 2018 21:58 Re: matching data with the report By: Fana on Thu, 31 May 2018 09:26 Re: matching data with the report By: Bridgette-DHS on Tue, 05 June 2018 07:50 Re: matching data with the report By: abebe on Sun, 14 April 2019 19:22 Re: matching data with the report By: Bridgette-DHS on Fri, 26 April 2019 10:37 Re: matching data with the report By: abebe on Fri, 26 April 2019 11:46 Re: matching data with the report By: abebe on Wed, 22 May 2019 19:16 Re: matching data with the report By: Bridgette-DHS on Sun, 16 June 2019 06:33 Re: matching data with the report By: Bridgette-DHS on Tue, 18 June 2019 16:33
 Previous Topic: Anthropometry_Ethiopia_2011DHS Next Topic: SPA data set related question
Goto Forum:

Current Time: Wed May 12 17:07:11 Coordinated Universal Time 2021