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  |
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 |
|
|
|
Current Time: Wed Dec 4 10:23:44 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
