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 #17827 is a reply to message #17819] Tue, 18 June 2019 16:33 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1763
Registered: February 2013
Senior Member
Following is a response from Senior DHS Data Processing Specialist, Ladys Ortiz:

I will be helping you to solve the issue you have by trying to replicate one of the denominators of table 11.8. To replicate the last 2 columns of table 11.8 you will need to use two datasets: KR and HR. The variables needed to select children living children 6-59 months old are: B5 and B19. To get the iodine information you will need variable HV234A from the "HR" dataset.

Please see below, the SPSS syntax I put together for you, and the frequencies that match the last column of table 11.8 of the final report.

If you have any other questions let me know.

*** Step 1: Open KR data file  Note that the PATH below is based on the folders structure I have on my computer.
GET  FILE='C:\Work2019\ETKR70FL.SAV'.

*** Step 2: Rename ID variables to match Household data.
RENAME VARIABLES V001 = hv001, V002 = HV002.
EXECUTE.

*** Step 3: Merge HR  data to children data.
MATCH FILES /FILE=*
  /TABLE='C:\Work2019\ETHR70FL.SAV'
  /BY HV001 HV002.
EXECUTE.

*** Step 4: Compute Weight variable.
COMPUTE WT = V005 / 1000000.
WEIGHT BY WT.

*** Step 5: Select denominator.
*** Children 6-59 months old and alive and household tested for iodine.
COMPUTE Chld_eligible= (B19 >= 6 & B19 <= 59 & B5 = 1 & HV234a <= 1).
VARIABLE LABELS Chld_eligible 'Children eligible for table 11.8 (last column)'.
VALUE LABELS Chld_eligible 0 'Not Selected' 1 'Selected'.
FILTER BY Chld_eligible.
EXECUTE.

FREQUENCIES Chld_eligible.
*** Step 1: Open KR data file.
GET  FILE='C:\Work2019\ETKR70FL.SAV'.

*** Step 2: Rename ID variables to match Household data.
RENAME VARIABLES V001 = hv001, V002 = HV002.
EXECUTE.
*** Step 3: Merge Idione data to children data.

MATCH FILES /FILE=*
  /TABLE='C:\Work2019\ETHR70FL.SAV'
  /BY HV001 HV002.
EXECUTE.

*** Step 4: Weight variable.
COMPUTE wt = V005 / 1000000.
WEIGHT BY WT.

*** Step 5: Select denominator.
*** Children 6-59 months old and alive and household tested for iodine = 0,1.
COMPUTE Chld_eligible= (B19 >= 6 & B19 <= 59 & B5 = 1 & HV234a <= 1).
VARIABLE LABELS Chld_eligible 'Children eligible for table 11.8 (last column)'.
VALUE LABELS Chld_eligible 0 'Not Selected' 1 'Selected'.
FILTER BY Chld_eligible.
EXECUTE.

FREQUENCIES Chld_eligible.

/index.php?t=getfile&id=1447&private=0
 
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: Sun Mar 29 20:52:51 Eastern Daylight Time 2020