Merging Refinitiv ESG data with Compustat data

[Jahan Ismat]

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

[Clyde Schechter]

You don't show example data, so you will have to adapt the following pseudocode. I assume that the variables containing the CUSIP are named cusip in both data sets, and is stored as a string variable.

use compustat_data_set, clear
gen cusip8 = substr(cusip, 1, 8)

will give you the 8-digit cusip in the Compustat data. Then in the ESG data, -rename cusip cusip8-. Now you will be able to combine the two data sets using cusip8 as a merge key variable.

[Jahan Ismat]

Dear Clyde Schechter,

Thank you for the help.

Regards,
Ismat