The DHS Program User Forum: Ethiopia » matching data with the report

Home » Countries » Ethiopia » matching data with the report

Show: Today's Messages :: Show Polls :: Message Navigator

Re: matching data with the report [message #17827 is a reply to message #17819]

Tue, 18 June 2019 16:33

Bridgette-DHS
Messages: 1806
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

Attachment: child_eligible.png
(Size: 6.72KB, Downloaded 217 times)

Report message to a moderator

[Message index]

		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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 6 19:50:00 Eastern Daylight Time 2020