The DHS Program User Forum
Discussions regarding The DHS Program data and results
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)
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 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3040
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

/index.php?t=getfile&id=1647&private=0
  • Attachment: hv024.png
    (Size: 19.31KB, Downloaded 442 times)
 
Read Message
Read Message
Previous Topic: Locating glucose variables - South Africa 2016 DHS
Next Topic: Matching blood pressure results
Goto Forum:
  


Current Time: Thu Apr 25 12:45:57 Coordinated Universal Time 2024