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
 Bridgette-DHS Messages: 1794Registered: 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.

 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: sadya2018@gmail.com 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: Fri Jun 5 21:27:10 Eastern Daylight Time 2020