| Merging Mali 2001 HW to KR [message #30522] |
Sat, 14 December 2024 03:22  |
Khandys Ag.
Messages: 1
Registered: December 2024
|
Member |
|
|
Greetings,
I hope you are all doing well. I am attempting to merge the Mali 2001 HW dataset with the Mali 2001 KR dataset. I followed the merging procedure provided with the HW dataset and I was able to merge the dataset to the household recode file. However, when I try to merge it with the children recode dataset I get the following error in STATA:
variables v001 v002 b16 do not uniquely identify observations in the using data.
Similarly, I had the same issue with the Senegal 2005 HW dataset. I was able to troubleshoot my problem, by doing drop if _merge ==2 when I merged the HW recode onto the household member recode. I was then able to merge this household recode file with the HW observations onto the Sengal file, but this led to the following merge results :
Result Number of obs
-----------------------------------------
Not matched 8,325
from master 7,696 (_merge==1)
from using 629 (_merge==2)
Matched 3,248 (_merge==3)
-----------------------------------------
If possible, I would greatly appreciate it if you could confirm whether my merging procedure for Senegal 2005 was done properly and provide guidance and how best to code the Mali 2001 datasets. Any guidance on how to merge these datasets would be greatly appreciated, as my previous procedure (without using the drop if _merge==1) seems to have worked on other datasets. I only experienced this issue with the Mali 2001 datasets and partially with the Senegal 2005 datasets.
Thank you for your help.
[Updated on: Sat, 14 December 2024 07:37] Report message to a moderator |
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
