The DHS Program User Forum: Merging data files » Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS

Home » Data » Merging data files » Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS

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

Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS [message #827]

Wed, 09 October 2013 11:22

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

[Message index]

		Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS By: EvisH on Wed, 09 October 2013 11:22
		Re: Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS By: Bridgette-DHS on Fri, 25 October 2013 12:43
		Re: Cote d'Ivoire Merging HIV and Women/Men datasets using SPSS By: EvisH on Wed, 11 December 2013 12:19

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 7 11:28:49 Coordinated Universal Time 2024