HIV data merging [message #9535] |
Sun, 10 April 2016 08:22  |
minewdem@gmail.com
Messages: 1 Registered: April 2016 Location: Addis Ababa, Ethiopia
|
Member |
|
|
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.
Thanks
Minilik
|
|
|
Re: HIV data merging [message #9547 is a reply to message #9535] |
Tue, 12 April 2016 12:47  |
 |
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.
RHS
|
|
|