Welcome to wrds.us, a Wharton Research Data Services (WRDS) user community. This website contains tutorials, code samples and forums geared towards using WRDS with SAS. If you are looking for WRDS' website, click here.
|How to deal with missing CEO identifier(CEOANN) and total compensation in Executivecomp?|
I am downloading CEO compensation data from Executive Comp database from 1992-1997. When I used the CEO flag (ceoann) provided in the database to identify CEO, I found that I cannot identify all CEOs in all firm-year observations since some CEO identifiers are missing. Moreover I think there are some mistakes as well, for example, Executivecomp identifies one officer is CEO in 1993 but the year he/she became CEO is 1999.
I can use two variables, Date became CEO and Date left as CEO to fill some missed CEO flag. I also search on the internet to get information, such as Forbes. However, I still cannot identify all CEOs. I searched DEF-14A filing and 10-K filing to identify CEO, however, I found that the earliest date for those filings is 1994 so I cannot accurately identify CEO in each firm in 1992 or 1993.
For the missing compensation data(total compensation and components, especilly value of option granted), should I look up information in DEF-14A and 10-K? But the same problem that I can only find filings back to 1994 exists, so I cannot find compensation data in 1992 or 1993 when they are missing in Executivecomp.
I am wondering is there a good way to deal with these issues in the database?
Thank you very very much!!!
|Latest posts in the repository|
|C++ code to compute ‘Jackknife’ Herfindahl indices|
|SAS macro to download WRDS datasets and create indices|
|Macro to create table with two groups comparing means and medians|
|Macro to create Pearson-Spearman correlations and p-values|
|Macro to compute industry-year adjusted values|
|Macro to adjust timeseries data for inflation (CPI)|
|Match Compustat (Funda) with Audit Analytics (Auditfees)|
|SEC Filings on EDGAR|
|An alternative interpretation of the discontinuity in earnings distributions|
|Accrual reliability, earnings persistence and stock prices|
|Downloading 10-K filings from SEC's EDGAR|
|Google market-to-book and return on assets versus industry|
|Saving time by using macros|
|Saving time by generating LaTeX tables|
|Estimating the earnings response coefficient (ERC)|
|Restatement event study|
|Compustat: Compute return on equity (ROE)|
|WRDS using SAS: Getting started|
|Latest forum threads|
|Searching by Industry (SIC Code) / Compustat Global by smallkahuna on > 11/26/2013 06:31 am|
|US based companies only by uma on > 11/07/2013 08:39 am|
|Matching accounting fundamentals from Compustat to CSRP monthly prices using STATA by Ahmed on > 11/05/2013 03:22 pm|
|CEO succession events by Jdijkers on > 11/04/2013 06:21 am|
|question about discretionary accrual models by Zenghui on > 10/27/2013 07:43 am|
|search by key words by Rochelle on > 10/26/2013 01:44 pm|
|compustat - foreign firms by Zenghui on > 10/21/2013 05:42 pm|
|about matching ISIN to gvkey? by Nan on > 10/16/2013 11:27 pm|
|Best way to replicate 'entropy measure of diversification' - segments by Jdijkers on > 10/16/2013 09:00 am|
|Do we delete certain stocks in event study? by luckygirl2009 on > 10/10/2013 10:52 pm|