| Merging HIV Data Set with Household [message #1156] |
Tue, 14 January 2014 18:30  |
rnarahar2
Messages: 1
Registered: January 2014
Location: Ann Arbor
|
Member |
|
|
Hello,
I am trying to merge the household level Standard DHS data set with the HIV biomarker data set for several countries. I realize that the HIV barcode is the unique identifier that links the data, but it seems that its not unique in household level Standard DHS data. When I perform the merge, I have twice the cases of HIV in the Standard Household dataset as the original HIV data set. I am not sure how to perform this merge in STATA without this issue. Please kindly provide some guidance.
Warm regards,
Ramya
|
|
|
|
| Re: Merging HIV Data Set with Household [message #1204 is a reply to message #1156] |
Tue, 21 January 2014 12:19  |
Bridgette-DHS
Messages: 3230
Registered: February 2013
|
Senior Member |
|
|
Here is a response from Senior Data Processing Specialist, Noureddine Abderrahim.
To merge the HIV data with the individual data, match the identification of the respondent with the identification of the respondent in the HIV data file. For women use V001, V002, and V003 and match them with HIVCLUST, HIVNUMB, and HIVLINE. For men use MV001, MV002, and MV003 and match them with HIVCLUST, HIVCLUST, and HIVLINE. In case the data is coming from the household, use HV001, HV002, and HVIDX to match them with HIVCLUST, HIVNUMB, and HIVLINE.
[Updated on: Tue, 21 January 2014 12:22] Report message to a moderator |
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
