The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » HIV » HIV data merging
HIV data merging [message #9535] Sun, 10 April 2016 08:22 Go to next message is currently offline
Messages: 1
Registered: April 2016
Location: Addis Ababa, Ethiopia
Dear All

I have accessed The 2011 Ethiopian DHS data to conduct further analysis on tested HIV positives with factors which is not incorporated in DHS report. Nevertheless the data set did not have the HIV test result merged with other variables, How can I merge the dataset or how can I get the merged dataset.

Re: HIV data merging [message #9547 is a reply to message #9535] Tue, 12 April 2016 12:47 Go to previous message
user-rhs is currently offline  user-rhs
Messages: 132
Registered: December 2013
Senior Member
Hi Minilik,
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.

Previous Topic: v852A/B/C missing from Swaziland 2006 DHS
Next Topic: Women's Empowerment indicator in SAS
Goto Forum:

Current Time: Thu Jun 30 09:44:36 Coordinated Universal Time 2022