The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merge PR and KR in wave 3, b16 does not exist
Merge PR and KR in wave 3, b16 does not exist [message #14951] Sat, 19 May 2018 12:59 Go to previous message
nibiti is currently offline  nibiti
Messages: 20
Registered: April 2018
Location: Göttingen
Hi all,

I am trying to merge PR with KR datasets for Sub-Saharan Africa, using PR as the base file. I have encountered a problem that many seem to have faced in this forum. My Stata tells me that my "variables hv001 hv002 and hvidx do not uniquely identify the observations in the using data".

Now, I have tried to find an answer in other forum threads (like this one: 46&) and the suggested answer seems to use b16 as identifier instead.

However, I face two problems:

1. b16 seems to not have been part of wave 3 and is not included in any of the wave 3 datasets. Is there a way in which I can still merge PR and KR datasets for wave 3? What identifier should be used instead?

Edit: I found my own answer here: &goto=10942&S=Google where it says that wave 3 is indeed not available.

2. For wave 4 to 7 I still receive the same error message again. That my variables (hv001/v001, hv002/v002, hvidx/b16) do not uniquely identify my observations.

Edit: I also tried dropping b16 for values of 0 or 99, but the error message remains.

Many thanks in advance!

Best regards

[Updated on: Sat, 19 May 2018 13:37]

Report message to a moderator

Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Mismatch between reported and generated output on merged file
Next Topic: Couple file from male and female dataset
Goto Forum:

Current Time: Thu Aug 13 04:52:39 Eastern Daylight Time 2020