The DHS Program User Forum: Merging data files » Merge PR and KR in wave 3, b16 does not exist

Home » Data » Merging data files » Merge PR and KR in wave 3, b16 does not exist

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

Re: Merge PR and KR in wave 3, b16 does not exist [message #15192 is a reply to message #14961]

Thu, 14 June 2018 11:06

Bridgette-DHS
Messages: 3203
Registered: February 2013

Senior Member

Following is a response from DHS Technical Specialist, Shireen Assaf:

The following code should work for a KR PR merge. I'm using the Rwanda most recent survey as an example.

use RWKR70FL.DTA, clear             
               
               rename v001 hv001
               rename v002 hv002
               rename b16  hvidx
               
               * dropping those that are not in the household so we can merge with PR file
               drop if hvidx==0 | hvidx==.

               sort hv001 hv002 hvidx
               
               save temp.dta, replace
               
               use RWPR70FL.DTA, clear             

               sort hv001 hv002 hvidx
               merge 1:1 hv001 hv002 hvidx using temp.dta
               
               erase temp.dta

Report message to a moderator

[Message index]

		Merge PR and KR in wave 3, b16 does not exist By: nibiti on Sat, 19 May 2018 12:59
		Re: Merge PR and KR in wave 3, b16 does not exist By: Bridgette-DHS on Mon, 21 May 2018 12:58
		Re: Merge PR and KR in wave 3, b16 does not exist By: nibiti on Tue, 22 May 2018 08:28
		Re: Merge PR and KR in wave 3, b16 does not exist By: Bridgette-DHS on Thu, 14 June 2018 11:06
		Re: Merge PR and KR in wave 3, b16 does not exist By: kingx025 on Sun, 08 July 2018 23:16
		Re: Merge PR and KR in wave 3, b16 does not exist By: zelalem on Thu, 28 November 2019 07:27
		Re: Merge PR and KR By: ask_ans_sri on Wed, 16 December 2020 06:34

Previous Topic:	Survey identifiers
Next Topic:	Merging household and women's individual data Myanmar 2015-2016

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Dec 4 10:32:01 Coordinated Universal Time 2024