Hi all,

I am trying to merge two data sets from Compustat to get Tobin's Q. I try to merge the two datasets based on the ISIN number and year. However, the files wont merge. Ive tried duplicates drop and there are no missing data on my datasets. ISIN number is string and year is float. when merging I get the error that the variables are not uniquely identified in the master dataset.

I don't know that the problem might be. Could someone please help me out with this?

Regards,
Iulia