The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merge HIV data with individuals
Merge HIV data with individuals [message #3788] Wed, 11 February 2015 09:02 Go to next message
cgranberg is currently offline  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!
Re: Merge HIV data with individuals [message #3798 is a reply to message #3788] Fri, 13 February 2015 09:47 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1814
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






Re: Merge HIV data with individuals [message #3801 is a reply to message #3798] Sat, 14 February 2015 17:00 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 702
Registered: January 2013
Senior Member
See this thread for information about merging the HIV data to the IR data.
Re: Merge HIV data with individuals [message #3806 is a reply to message #3801] Mon, 16 February 2015 10:54 Go to previous message
cgranberg is currently offline  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
Previous Topic: Merging Household+Female+Male files
Next Topic: merging different countries data
Goto Forum:
  


Current Time: Tue Jul 7 22:29:49 Eastern Daylight Time 2020