The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS
Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS [message #827] Wed, 09 October 2013 11:22 Go to next message
EvisH is currently offline  EvisH
Messages: 8
Registered: August 2013
Location: Arlington
Member
I am trying to merge the HIV to the Individual (men and women) datasets for 2005 and 2012 for Cote d'Ivoire. I have sorted(by cluster, household and line) the data on the HIV 2005 dataset and have noticed that there are duplicate records (or at least it looks like it); meaning that there are several records that have the same info in the three variables (cluster, household and line). For example, there are two records that have 1s in the three variables, four records that have 1s in the first two variables but 3s in the third one (line). I am not sure how the merging is going to happen in this case with this issue. Can you please provide an explanation to what this means and what do you suggest for merging the HIV 2005 and Individual Women 2005 datasets together?

The 2012 HIV dataset doesn't have this issue.

Report message to a moderator

Re: Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS [message #871 is a reply to message #827] Fri, 25 October 2013 12:43 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3188
Registered: February 2013
Senior Member
In Cote d'Ivoire 2005 there is an additional ID variable: HIVSTRUCT in the HIV dataset and SSTRUCT in the Women's dataset. You need this additional ID to do the merge correctly.

Bridgette-DHS

Report message to a moderator

Re: Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS [message #974 is a reply to message #871] Wed, 11 December 2013 12:19 Go to previous message
EvisH is currently offline  EvisH
Messages: 8
Registered: August 2013
Location: Arlington
Member
Thank you, Bridgette.

[Updated on: Wed, 11 December 2013 12:19]

Report message to a moderator

Previous Topic: Merging HIV with Individual file
Next Topic: Merging HIV Data Set with Household
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Thu Nov 7 11:18:47 Coordinated Universal Time 2024
.:: Contact :: Home :: Privacy Policy ::.

Powered by: FUDforum 3.0.9.
Copyright ©2001-2018 FUDforum Bulletin Board Software

The information provided on this Web site is not official U.S. Government information and
does not represent the views or positions of the U.S. Agency for International Development or the U.S. Government...