| Home » Topics » Biomarkers » Slight difference in HIV numbers in South Africa 2016 dataset (IR, MR) (Slight difference in HIV numbers within subgroups age, region, education, wealth) Goto Forum:
	| 
		
			| Re: Slight difference in HIV numbers in South Africa 2016 dataset (IR, MR) [message #21669 is a reply to message #21634] | Mon, 07 December 2020 09:16  |  
			| 
				
				
					|  Bridgette-DHS Messages: 3230
 Registered: February 2013
 | Senior Member |  |  |  
	| Following is a response from DHS Research & Data Analysis Director, Tom Pullum:
 
 I was able to get a match by merging with the PR file and then selecting the women for whom hv117=1 (for men you would select on hv118=1).  These are the women (and men) who were eligible for the individual interviews, whether or not they were actually interviewed individually.
 
 I tried this because the biomarkers are part of the household survey and the covariates in the table are part of the household survey.  However, your approach--merging with the IR file (and MR file) was completely reasonable, and the differences are very small.
 
 
 set more off
 use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\ZAAR71FL.DTA", clear
 
 rename hivclust hv001
 rename hivnumb hv002
 rename hivline hvidx
 
 sort hv001 hv002 hvidx
 save e:\DHS\DHS_data\scratch\ZAARtemp.dta, replace
 
 use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\ZAPR71FL.DTA", clear
 
 keep hv001 hv002 hvidx hv024 hv104 hv105 hv117 hv118
 sort hv001 hv002 hvidx
 merge hv001 hv002 hvidx using e:\DHS\DHS_data\scratch\ZAARtemp.dta
 
 tab _merge
 keep if _merge==3
 drop _merge
 
 tab hv024 [iweight=hiv05/1000000] if hv117==1
 
 
   
	
	 Attachment: hv024.png (Size: 19.31KB, Downloaded 747 times)
 |  
	|  |  | 
 
 Current Time: Fri Oct 31 01:44:05 Coordinated Universal Time 2025 |