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
Related Posts with Merging Refinitiv ESG data with Compustat data
Destringing vars and changing commas to dotsHi all I have some datasets in which Italian notation has been used - this means that commas have …
Descompositioncan someone explain to me about the gap descomposition methods and which are commands in Stata? I wa…
Curious error when listing longI'm working with latitude and longitude variables but I ran into a curious error: Code: clear input…
Find the most recent observationHi, I have a year-firm panel data. How should I write the code to find the most recent observation …
Unable to cd and use the file in DropboxHi Everyone, I have difficulty to cd the file to Dropbox and use the file in Dropbox. Here are my s…
Subscribe to:
Post Comments (Atom)
0 Response to Merging Refinitiv ESG data with Compustat data
Post a Comment