The DHS Program User Forum: Merging data files » Merging household and women's individual data Myanmar 2015-2016

Home » Data » Merging data files » Merging household and women's individual data Myanmar 2015-2016

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

Re: Merging household and women's individual data Myanmar 2015-2016 [message #22033 is a reply to message #22032]

Fri, 22 January 2021 09:29

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

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

You need to include line number. In the PR file that's hvidx and in the IR file it's v003.

use "/Users/t/Desktop/Actual dataset/PR2.DTA"

rename hv001 v001
rename hv002 v002
rename hvidx v003
sort v001 v002 v003
save "/Users/Desktop/Actual dataset/PR2.DTA", replace

use "/Users/t/Desktop/Actual dataset/IR.DTA"
sort v001 v002 v003

merge m:1 v001 v002 v003 using PR2

Report message to a moderator

[Message index]

		Merging household and women's individual data Myanmar 2015-2016 By: smiedem on Wed, 06 January 2021 17:21
		Re: Merging household and women's individual data Myanmar 2015-2016 By: Bridgette-DHS on Thu, 14 January 2021 13:50
		Re: Merging household and women's individual data Myanmar 2015-2016 By: anikhpg42@gmail.com on Fri, 22 January 2021 03:37
		Re: Merging household and women's individual data Myanmar 2015-2016 By: Bridgette-DHS on Fri, 22 January 2021 09:29
		Re: Merging household and women's individual data Myanmar 2015-2016 By: anikhpg42@gmail.com on Fri, 22 January 2021 20:54

Previous Topic:	Merge PR and KR in wave 3, b16 does not exist
Next Topic:	MERGING HIV DATASETS AND WOMEN DATASETS, DHS 2016-2017, HAITI.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jul 21 23:06:24 Coordinated Universal Time 2025