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 #14961 is a reply to message #14958]

Tue, 22 May 2018 08:28

nibiti
Messages: 20
Registered: April 2018
Location: Göttingen

Member

Hi Tom,

thanks for your reply. I have dropped the KR wave 3 data now.

But do you also have an answer for my second question? hv001/v001, hv002/v002 and hvidx/b16 do not uniquely identify the data in wave 4 and in wave 6, independent of the country (I am using all Sub-Saharan African countries).

I am using the exact same code for wave 5 and there the merge works fine. But for wave 4 and wave 6 it does not seem to work. My code broadly looks like this:

In KR file:
rename v001 hv001
rename v002 hv002
rename b16 hvidx

In PR file:
sort hv001 hv002 hvidx
merge 1:1 hv001 hv002 hvidx using "KR.dta"

This leads to the following error message:

"variables hv001 hv002 hvidx do not uniquely
identify observations in the using data
r(459);"

Any ideas?

Best
Timo

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 Jul 23 18:18:49 Coordinated Universal Time 2025