The DHS Program User Forum: HIV » Merging 2015 Angola HIV data with standard DHS

Home » Topics » HIV » Merging 2015 Angola HIV data with standard DHS

Show: Today's Messages :: Show Polls :: Message Navigator

Merging 2015 Angola HIV data with standard DHS [message #29173]

Fri, 03 May 2024 08:44

Koray
Messages: 11
Registered: June 2023

Member

Hello... Please I need help. Below are my steps in merging HIV data with the 2015 Angola standard DHS.

Prepare the AR file
use "...A0AR71FL.DTA", clear

gen cluster=hivclust
gen hh=hivnumb
gen line=hivline
sort cluster hh line

* Prepare the IR file
use "...AOIR71FL.DTA", clear

gen cluster=v001
gen hh=v002
gen line=v003
sort cluster hh line

* Do the merge
merge 1:1 cluster hh line using

Outcome
merge 1:1 cluster hh line using " C:\Users\Gbang\Downloads\AO_2015-16_DHS_05032024_1157_156908 \AO
> AR71DT\AOAR71FL.DTA"

Result # of obs.
-----------------------------------------
not matched 13,403
from master 7,745 (_merge==1)
from using 5,658 (_merge==2)

matched 6,634 (_merge==3)

Almost 50% of the data were not matching. Where did I go wrong?

Report message to a moderator

Re: Merging 2015 Angola HIV data with standard DHS [message #29213 is a reply to message #29173]

Fri, 10 May 2024 15:30

Janet-DHS
Messages: 938
Registered: April 2022

Senior Member

Following is a response from DHS staff member, Tom Pullum:
Nothing is wrong with what you did. The AR file is approximately evenly divided between women and men. You matched the women.

Report message to a moderator

Previous Topic:	HIV knowledge
Next Topic:	Merging of SA DHS 2016 HIV dataset ZAAR and ZAPR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 4 07:37:14 Coordinated Universal Time 2025