The DHS Program User Forum: Merging data files » MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI.

Home » Data » Merging data files » MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. (DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI.)

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

Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. [message #22076 is a reply to message #22075]

Thu, 28 January 2021 14:30

Bridgette-DHS
Messages: 3203
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The Stata code to do this is given below. It shows the logic; you will have to convert to R. "_merge==3" identifies the cases that are in both files. Remember that when you use data in the AR file, you should apply the HIV weight, hiv05.

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\HTAR71FL.DTA", clear
rename hivclust v001
rename hivnumb v002
rename hivline v003
sort v001 v002 v003
save e:\DHS\DHS_data\scratch\HTARtemp.dta, replace

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\HTIR71FL.DTA", clear
sort v001 v002 v003
merge v001 v002 v003 using e:\DHS\DHS_data\scratch\HTARtemp.dta
tab _merge
keep if _merge==3

Report message to a moderator

[Message index]

		MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: YVES on Thu, 28 January 2021 12:38
		Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: Bridgette-DHS on Thu, 28 January 2021 14:30
		Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: YVES on Fri, 29 January 2021 08:45
		Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: YVES on Mon, 08 February 2021 08:06
		Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: Bridgette-DHS on Mon, 08 February 2021 08:35
		Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: YVES on Mon, 08 February 2021 09:31
		Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: YVES on Tue, 09 February 2021 15:14
		Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: YVES on Tue, 09 February 2021 15:26
		Re: MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI. By: Bridgette-DHS on Wed, 17 February 2021 08:56

Previous Topic:	Merging household and women's individual data Myanmar 2015-2016
Next Topic:	coverage of variables v717 and mv717 in Mali V and VI waves

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Dec 4 18:41:00 Coordinated Universal Time 2024