Hey,
I also want to merge international, so non-US, firms from Compustat Global with analyst data from IBES but I am not able to do it.
I tried to use the CCM linking table, but then I am left with Canadian firms only, so this is no opportunity.
I tried to use the ISIN and SEDOL from Compustat to obtain the IBES CUSIP but that does not work either.
Is there a way to combine the two databases for international (also not cross-listed) firms? If yes, how can I do that?
By the way, I am also using Stata.
Thanks for your help!