Merge Person ID in Thomson Reuters with IRRC director ID in Riskmetrics
Posted: 07 July 2014 11:36 PM   [ Ignore ]
Newbie
Rank
Total Posts:  9
Joined  2014-07-07

I have these person IDs from Thomson Reuters (TR) and director IDs from riskmetrics (RM), and I am trying to merge traders in TR with director in RM. Do anybody know that whether person ID and irrc director ID are identical to each person? If yes, that will save my day. Alternatively, I also have traders’ full name (all in upper case) from TR and first, middle and last of each trader (only the first letter is in upper case) from RM. However, if to do the merge, the upper and lower case will be a pain. Do anybody know any easier way to do the match?


Come on Guys. Really need a help!

Profile
 
 
Posted: 09 July 2014 10:24 PM   [ Ignore ]   [ # 1 ]
Newbie
Rank
Total Posts:  9
Joined  2014-07-07

I found out the solution in this forum. If anybody is search for the same problem. This link might help: http://www.wrds.us/index.php/forum_wrds/viewthread/219/#374

Profile