Hi Stata experts,

I am trying to merge Refinitiv ESG data Compustat data. ESG data has 8 digit cusip. But Compustat has 9 digit cusip. Can anyone help me, please? I tried using cusip converter from WRDS tools. It has converted the cusip and the 9 digit cusip is saved as a Stata file. But some cusip are like 10014,200 which I do not understand. Also, I do not know how to incorporate these 9 digit cusips with appropriate observations.

I tried merging the datasets using ogrid (as gvkey) as Refinitiv variable definition says orgid is the unique id assigned to each firm. But the merged file has significantly low merged observations.

I highly appreciate your time and kindness.

Best regards,

Jahan Ismat