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 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1806
Registered: 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.


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Anthropometry_Ethiopia_2011DHS
Next Topic: SPA data set related question
Goto Forum:
  


Current Time: Thu Jul 2 18:05:10 Eastern Daylight Time 2020