The DHS Program User Forum: Merging data files » Merge HIV data with individuals

Home » Data » Merging data files » Merge HIV data with individuals

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

Merge HIV data with individuals [message #3788]

Wed, 11 February 2015 09:02

cgranberg
Messages: 3
Registered: February 2015
Location: Sweden

Member

Hello!
I have data from Kenya DHS 2008-09.
This is my problem:
I have the dataset for only the women. I also have the dataset for the HIV results. I want to connect each women to the HIV test results. I know that blood was not taken from all of the women but that is not a problem. So how do I connect a HIV test result to the right woman? Is there an easy way to merge the dataset so the test results appear on the right row (because each row is one participant as I have understood it)?

Thanks in advance!

Report message to a moderator

Re: Merge HIV data with individuals [message #3798 is a reply to message #3788]

Fri, 13 February 2015 09:47

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

There are several forum posts on merging, below are a couple of links to such discussions:

Message 2365

Message 71

Report message to a moderator

Re: Merge HIV data with individuals [message #3801 is a reply to message #3798]

Sat, 14 February 2015 17:00

Trevor-DHS
Messages: 805
Registered: January 2013

Senior Member

See this thread for information about merging the HIV data to the IR data.

Report message to a moderator

Re: Merge HIV data with individuals [message #3806 is a reply to message #3801]

Mon, 16 February 2015 10:54

cgranberg
Messages: 3
Registered: February 2015
Location: Sweden

Member

Thank you for your answer. I have found the steps to take Though I am struggling with how to perform all of them. I am working with the software R and I can't figure out how to sort the variables, which seems to be important in most of the answers to this question. Any suggestions on how to sort by identifying variable in R?

Thanks
Caroline

Report message to a moderator

Previous Topic:	Merging Household+Female+Male files
Next Topic:	merging different countries data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon May 26 00:11:36 Coordinated Universal Time 2025