how to merge Riskmetrics director data?
Posted: 06 May 2013 10:44 AM   [ Ignore ]
Sr. Member
RankRankRankRank
Total Posts:  169
Joined  2011-09-20

Wrds riskmetrics have two director datasets.

1. directors.sas7bdat   1996-2007
2. rmdirectors.sas7bdat 2008-2011

I would like to know if a CEO is on board of one company in 2007, and is he on the board (own or other company’s board) in 2008?
can i just use cusip (company) and fyear and the director ID to do this? With the assumption that the director IDs are the same accross two databases.

I thought there must be some one merged these two datasets. I would like to learn how this is done “carefully”.

A google scholar search with “director riskmetrics merge” didn’t give me any paper useful for this topic.
Wrds website warns that be very careful in merging these two datasets, however they didn’t say any details.

Any suggestions is highly appreciated!

Thanks!

 Signature 

Zenghui
A humble student of business

Profile
 
 
Posted: 07 May 2013 08:41 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Zenghui,

The new riskmetrics director table has these variables:
LEGACY_PPS_ID Num 8 Legacy IRRC company ID
LEGACY_DIRECTOR_ID Num 8 Legacy IRRC director ID

So it seems they facilitate a match with the earlier dataset. I suppose ‘being careful’ is about the variables in the table. For starters, there are more variables in the newer version, but I suppose the way variables are measured could differ as well.

Hope this helps (a little),

best regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 07 May 2013 02:48 PM   [ Ignore ]   [ # 2 ]
Sr. Member
RankRankRankRank
Total Posts:  169
Joined  2011-09-20

Joost,

Thanks!

That help.

Zenghui

 Signature 

Zenghui
A humble student of business

Profile
 
 
Posted: 07 May 2013 04:10 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

cool smile

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile