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

[Message index]

		Merging 2015 Angola HIV data with standard DHS By: Koray on Fri, 03 May 2024 08:44
		Re: Merging 2015 Angola HIV data with standard DHS By: Janet-DHS on Fri, 10 May 2024 15:30

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: Wed Jul 31 22:15:52 Coordinated Universal Time 2024