Home » Data » IPUMS Demographic and Health Surveys (IPUMS-DHS) » Merge HIV-Positive Data with Individuals
| Re: Merge HIV-Positive Data with Individuals [message #16746 is a reply to message #16739] |
Tue, 26 February 2019 15:41  |
kingx025
Messages: 95
Registered: August 2016
Location: Minneapolis. Minnesota
|
Senior Member |
|
|
I also posted answers on the IPUMS User Forum, and I repeat those answers here.
To link IPUMS DHS data to the HIV test result data:
I found the following post on the DHS User forum, about merging HIV test result files with other DHS data files:
"I believe there are person identifiers in the HIV dataset called hivclust, hivnumb, and hivline, the combination of which should be a person's unique identifier. These represent the cluster, household, and line number variables, respectively. The easiest way is to rename these variables to v001, v002, and v003 (as these variables are called in the IR dataset), respectively. If merging with male recode dataset, then you would rename these variables to mv001, mv002, and mv003. After renaming hivclust, hivnumb, and hivline, and sorting by the appropriate variables (v001, v002, and v003 for women and mv001, mv002, and mv003 for men's dataset), you should be able to merge the datasets on these variables."
If you chose women as your unit of analysis in IPUMS-DHS and opt for showing the original DHS variable names, you can select V001 (IPUMS name: CLUSTERNO), V002 (IPUMS name: HHNUM), and V003 (IPUMS name: LINENO) as elements of your customized data extract. Then you would rename the HIV dataset variable names to match and merge on these variables. I would do this for one dataset at a time, or add some other linking variables to distinguish between samples, such as COUNTRY and YEAR.
When we add men as a unit of analysis (very soon), the MV001, MV002, and MV003 identifier variables will be available for IPUMS-DHS samples, as well.
We are currently working on harmonizing standard variables for men for 115 DHS samples and expect those data will be available through IPUMS-DHS by May, 2019, at the latest.
I hope this helps.
Dr. Miriam King
IPUMS-DHS Project Manager (www.idhsdata.org)
|
|
|
|
Current Time: Mon Nov 25 12:20:28 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
