| 
		
			| Gambia DHS 2013 [message #11139] | Tue, 08 November 2016 04:43  |  
			| 
				
				
					|  Ceesay1 Messages: 3
 Registered: October 2016
 Location: Taiwan
 | Member |  |  |  
	| Hello Everyone, 
 I have downloaded the Gambia's DHS2013 and currently trying to analysis it. I am interested in the predictors of HIV prevalence in the Gambia.
 
 To do that, I first merge the GMIR with the GMAR datasets to get the HIV testing results for women and I similarly merged GMMR and the the GMAR datasets. The two newly created datasets were appended to hive the hivtests datasets for men and women. For example:
 1.In the men dataset, I did:
 keep  mv001 mv002 mv003 mv012
 rename mv001 v001
 rename mv002 v002
 rename mv003 v003
 rename mv012 v012
 gen long id=((1000+v001)*10000)+(v002*100)+v003
 gen gender="men"
 
 2.Women dataset:
 keep  v001 v002 v003 v012
 gen long id=((1000+v001)*10000)+(v002*100)+v003
 gen gender="women"
 
 I appended the above two which give rise to a dataset( Gender included). For the HIV test dataset, I kept id hiv03 hiv05.
 
 Finally merged the the new dataset which has gender included with HIV dataset:
 
 use "C:\Users\IHP0015\Desktop\Gambia_Stata\menwomen.DTA", clear
 merge 1:1 id using "C:\Users\IHP0015\Desktop\Gambia_Stata\hiv.DTA"
 
 
 
 The next attempt is to attempt to replicate some of the tables in the Gambia DHS report but to my dismay, all of the figures I produced were close but different.
 
 Does anyone have an idea for the way forward?
 
 Thanks
 
 
 |  
	|  |  |