Hell everyone,

I have a dataset with V2 - country code

(in the codebook each country has a code so I believe the initial value of the V2 are codes):

Code:
tab V2 (master dataset)
Array



I need to add to the dataset the GDP per capita variable. For this I have created the excel file with 2 columns: V2 and GDP per capita and saved this file as .dta.

As recommended in previous posts I have used
Code:
merge 1:1 V2 using "/.../GDP_per_capita.Wave_6.dta"
Problem: I am receiving the error variable V2 does not uniquely identify observations in the master data no matter if I am having in the GDP dataset country names (to match the V2 from master dataset) or codes correspond to each of the country.

With names: Array




With codes for each country: Array




Could you advise where can be a problem?

Thanks!