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 next message Go to previous message](/theme/default/images/down.png) |
nibiti
Messages: 20 Registered: April 2018 Location: Göttingen
|
Member |
|
|
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: https://userforum.dhsprogram.com/index.php?t=msg&goto=28 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: https://userforum.dhsprogram.com/index.php?t=msg&th=1900 &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
Timo
[Updated on: Sat, 19 May 2018 13:37] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Fri Aug 30 20:21:09 Coordinated Universal Time 2024
|