Hi,

These datasets are from WRDS from 2010-2017, One has director characteristics, directors compensation and firm financials. I am looking to merge these datasets.

A common company ID across all three datasets are firm CUSIP and TICKER, the former is more accurate. Some of the CUSIP codes are 8 digit, in accrodance with WRDS I created a 6 digit code.accross all datasets

Code:
gen cusip_6 = substr(cusip, 1, 6)
The data is shown in a way where it makes 1:1, 1:M and M:1 not possible as the CUSIP's aren't unique. As soon as I reached and attempted M:M I thought of asking as there are clear warnings of the method yielding nothing fruitful (even though it worked and seemed to match everything with another dataset but can't be sure due to multiple warnings).

I am currently trying to understand and attempt the -joinby- command.

I do apologize if I missed something out from the FAQ's,. Thank you for your help!

Data below is director characteristics (Riskmetrics/IRRC)

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str12 cusip str30 ticker str100 name double year str100 fullname str34 ethnicity double age str4 financial_expert
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2010 "DAVID M. LAWRENCE"             "CAUCASIAN"               70 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2010 "JAMES G. CULLEN"               "CAUCASIAN"               68 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2010 "A. BARRY RAND"                 "AFRICAN-AMERICAN"        66 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2010 "KOH BOON HWEE"                 "ASIAN"                   60 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2010 "ROBERT J. HERBOLD"             "CAUCASIAN"               68 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2010 "PAUL N. CLARK"                 "CAUCASIAN"               64 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2010 "HEIDI FIELDS"                  "CAUCASIAN"               56 "Yes"
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2010 "WILLIAM P. SULLIVAN"           "CAUCASIAN"               60 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "DAVID M. LAWRENCE"             "CAUCASIAN"               71 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "JAMES G. CULLEN"               "CAUCASIAN"               69 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "A. BARRY RAND"                 "AFRICAN-AMERICAN"        67 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "KOH BOON HWEE"                 "ASIAN"                   61 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "ROBERT J. HERBOLD"             "CAUCASIAN"                . ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "PAUL N. CLARK"                 "CAUCASIAN"               65 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "HEIDI FIELDS"                  "CAUCASIAN"               57 "Yes"
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "TADATAKA YAMADA"               "ASIAN"                   66 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2011 "WILLIAM P. SULLIVAN"           "CAUCASIAN"               62 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "DAVID M. LAWRENCE"             "CAUCASIAN"               72 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "JAMES G. CULLEN"               "CAUCASIAN"               70 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "A. BARRY RAND"                 "BLACK/AFRICAN AMERICAN"  68 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "BOON HWEE KOH"                 "ASIAN"                   62 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "ROBERT J. HERBOLD"             "CAUCASIAN"                . ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "PAUL N. CLARK"                 "CAUCASIAN"               66 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "HEIDI FIELDS"                  "CAUCASIAN"               58 "Yes"
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "TADATAKA YAMADA"               "ASIAN"                   67 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2012 "WILLIAM P. SULLIVAN"           "CAUCASIAN"               63 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "DAVID M. LAWRENCE"             "CAUCASIAN"               73 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "JAMES G. CULLEN"               "CAUCASIAN"               71 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "A. BARRY RAND"                 "BLACK/AFRICAN AMERICAN"  69 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "BOON HWEE KOH"                 "ASIAN"                   63 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "ROBERT J. HERBOLD"             "CAUCASIAN"                . ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "PAUL N. CLARK"                 "CAUCASIAN"               67 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "HEIDI FIELDS"                  "CAUCASIAN"               59 "Yes"
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "TADATAKA YAMADA"               "ASIAN"                   68 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2013 "WILLIAM P. SULLIVAN"           "CAUCASIAN"               64 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2014 "JAMES G. CULLEN"               "CAUCASIAN"               72 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2014 "A. BARRY RAND"                 "BLACK/AFRICAN AMERICAN"  70 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2014 "ROBERT JOHN HERBOLD"           "CAUCASIAN"               72 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2014 "PAUL N. CLARK"                 "CAUCASIAN"               68 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2014 "HEIDI K. FIELDS"               "CAUCASIAN"               60 "Yes"
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2014 "TADATAKA YAMADA"               "ASIAN"                   69 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2014 "WILLIAM P. SULLIVAN"           "CAUCASIAN"               65 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2014 "BOON HWEE KOH"                 "ASIAN"                   64 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "PAUL N. CLARK"                 "CAUCASIAN"               69 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "JAMES G. CULLEN"               "CAUCASIAN"               73 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "HEIDI K. FIELDS"               "CAUCASIAN"               61 "Yes"
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "ROBERT JOHN HERBOLD"           "CAUCASIAN"               72 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "BOON HWEE KOH"                 "ASIAN"                   65 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "MICHAEL R. MCMULLEN"           "CAUCASIAN"               54 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "A. BARRY RAND"                 "BLACK/AFRICAN AMERICAN"  71 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "GEORGE A. SCANGOS"             "CAUCASIAN"               67 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2015 "TADATAKA YAMADA"               "ASIAN"                   70 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "PAUL N. CLARK"                 "CAUCASIAN"               69 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "JAMES G. CULLEN"               "CAUCASIAN"               73 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "HEIDI K. FIELDS"               "CAUCASIAN"               61 "Yes"
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "ROBERT JOHN HERBOLD"           "CAUCASIAN"               73 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "BOON HWEE KOH"                 "ASIAN"                   65 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "MICHAEL R. MCMULLEN"           "CAUCASIAN"               54 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "DANIEL K. PODOLSKY"            "CAUCASIAN"               62 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "SUE H. RATAJ"                  "CAUCASIAN"               59 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "GEORGE A. SCANGOS"             "CAUCASIAN"               67 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2016 "TADATAKA YAMADA"               "ASIAN"                   71 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "PAUL CLARK"                    "CAUCASIAN"               69 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "JAMES CULLEN"                  "CAUCASIAN"               74 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "HEIDI FIELDS"                  "CAUCASIAN"               62 "Yes"
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "ROBERT HERBOLD"                "CAUCASIAN"               74 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "BOON HWEE KOH"                 "ASIAN"                   66 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "MICHAEL MCMULLEN"              "CAUCASIAN"               55 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "DANIEL PODOLSKY"               "CAUCASIAN"               63 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "SUE RATAJ"                     "CAUCASIAN"               59 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "GEORGE SCANGOS"                "CAUCASIAN"               68 ""   
"00846U101" "A"  "AGILENT TECHNOLOGIES, INC." 2017 "TADATAKA YAMADA"               "ASIAN"                   71 ""   
"013817101" "AA" "ALCOA INC."                 2010 "JOSEPH T. GORMAN"              "CAUCASIAN"               73 "Yes"
"013817101" "AA" "ALCOA INC."                 2010 "ARTHUR D. COLLINS JR."         "CAUCASIAN"               63 ""   
"013817101" "AA" "ALCOA INC."                 2010 "PATRICIA F. RUSSO"             "CAUCASIAN"               58 ""   
"013817101" "AA" "ALCOA INC."                 2010 "MICHAEL G. MORRIS"             "CAUCASIAN"               64 ""   
"013817101" "AA" "ALCOA INC."                 2010 "JUDITH M. GUERON"              "CAUCASIAN"               69 ""   
"013817101" "AA" "ALCOA INC."                 2010 "ERNESTO ZEDILLO"               "HISPANIC"                59 "Yes"
"013817101" "AA" "ALCOA INC."                 2010 "KATHRYN S. FULLER"             "CAUCASIAN"               64 ""   
"013817101" "AA" "ALCOA INC."                 2010 "CARLOS GHOSN"                  "HISPANIC"                57 ""   
"013817101" "AA" "ALCOA INC."                 2010 "E. STANLEY O'NEAL"             "AFRICAN-AMERICAN"        59 "Yes"
"013817101" "AA" "ALCOA INC."                 2010 "JAMES W. OWENS"                "CAUCASIAN"               65 "Yes"
"013817101" "AA" "ALCOA INC."                 2010 "KLAUS KLEINFELD"               "CAUCASIAN"               53 ""   
"013817101" "AA" "ALCOA INC."                 2010 "RATAN N. TATA"                 "ASIAN"                   73 ""   
"013817101" "AA" "ALCOA INC."                 2011 "ARTHUR D. COLLINS JR."         "CAUCASIAN"               64 "Yes"
"013817101" "AA" "ALCOA INC."                 2011 "PATRICIA F. RUSSO"             "CAUCASIAN"               59 ""   
"013817101" "AA" "ALCOA INC."                 2011 "MICHAEL G. MORRIS"             "CAUCASIAN"               64 "Yes"
"013817101" "AA" "ALCOA INC."                 2011 "JUDITH M. GUERON"              "CAUCASIAN"               70 ""   
"013817101" "AA" "ALCOA INC."                 2011 "ERNESTO ZEDILLO"               "HISPANIC"                60 "Yes"
"013817101" "AA" "ALCOA INC."                 2011 "KATHRYN S. FULLER"             "CAUCASIAN"               65 ""   
"013817101" "AA" "ALCOA INC."                 2011 "E. STANLEY O'NEAL"             "AFRICAN-AMERICAN"        60 "Yes"
"013817101" "AA" "ALCOA INC."                 2011 "JAMES W. OWENS"                "CAUCASIAN"               66 "Yes"
"013817101" "AA" "ALCOA INC."                 2011 "KLAUS KLEINFELD"               "CAUCASIAN"               54 ""   
"013817101" "AA" "ALCOA INC."                 2011 "RATAN N. TATA"                 "ASIAN"                   75 ""   
"013817101" "AA" "ALCOA INC."                 2012 "ARTHUR D. COLLINS JR."         "CAUCASIAN"               65 "Yes"
"013817101" "AA" "ALCOA INC."                 2012 "PATRICIA F. RUSSO"             "CAUCASIAN"               60 ""   
"013817101" "AA" "ALCOA INC."                 2012 "MICHAEL G. MORRIS"             "CAUCASIAN"               66 "Yes"
"013817101" "AA" "ALCOA INC."                 2012 "JUDITH M. GUERON"              "CAUCASIAN"               71 ""   
"013817101" "AA" "ALCOA INC."                 2012 "ERNESTO ZEDILLO PONCE DE LEON" "HISPANIC/LATIN AMERICAN" 61 "Yes"
"013817101" "AA" "ALCOA INC."                 2012 "KATHRYN S. FULLER"             "CAUCASIAN"               66 ""   
end

Director compensation (from execucomp on WRDS)

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str8 cusip str6 ticker double year str244 dirname double(cash_fees stock_awards)
"00036110" "AIR"  2010 "Peter Pace, USMC, Ret."         31.375   55.6
"00036110" "AIR"  2010 "Ronald R. Fogleman"              78.75  71.64
"00036110" "AIR"  2010 "Patrick J. Kelly"                 72.5  71.64
"00036110" "AIR"  2010 "Marc Jay Walfish"                   80  71.64
"00036110" "AIR"  2010 "Norman R. Bobins, BS, MBA"       73.75  71.64
"00036110" "AIR"  2010 "Ronald B. Woodard"                82.5  71.64
"00036110" "AIR"  2010 "James E. Goodwin"                   85  71.64
"00036110" "AIR"  2010 "Michael R. Boyce"                78.75  71.64
"00036110" "AIR"  2010 "James Gilbert Brocksmith, Jr."   86.25  71.64
"00036110" "AIR"  2010 "Gerald F. Fitzgerald, Jr."      25.625  71.64
"00036110" "AIR"  2011 "Peter Pace, USMC, Ret."          76.25  128.9
"00036110" "AIR"  2011 "Ronald R. Fogleman"              83.75  128.9
"00036110" "AIR"  2011 "Patrick J. Kelly"                81.25  128.9
"00036110" "AIR"  2011 "Marc Jay Walfish"                 82.5  128.9
"00036110" "AIR"  2011 "Norman R. Bobins, BS, MBA"        87.5  128.9
"00036110" "AIR"  2011 "Ronald B. Woodard"               91.25  128.9
"00036110" "AIR"  2011 "James E. Goodwin"                91.25  128.9
"00036110" "AIR"  2011 "Michael R. Boyce"                78.75  128.9
"00036110" "AIR"  2011 "James Gilbert Brocksmith, Jr."   96.25  128.9
"00036110" "AIR"  2012 "Peter Pace, USMC, Ret."           77.5   57.8
"00036110" "AIR"  2012 "Ronald R. Fogleman"               87.5   57.8
"00036110" "AIR"  2012 "Patrick J. Kelly"                   85   57.8
"00036110" "AIR"  2012 "Marc Jay Walfish"                86.25   57.8
"00036110" "AIR"  2012 "Norman R. Bobins, BS, MBA"       81.25   57.8
"00036110" "AIR"  2012 "Ronald B. Woodard"               91.25   57.8
"00036110" "AIR"  2012 "James E. Goodwin"                96.25   57.8
"00036110" "AIR"  2012 "Michael R. Boyce"                78.75   57.8
"00036110" "AIR"  2012 "Anthony K. Anderson"                60 54.628
"00036110" "AIR"  2012 "James Gilbert Brocksmith, Jr."    42.5   57.8
"00036110" "AIR"  2013 "Peter Pace, USMC, Ret."          78.75  103.4
"00036110" "AIR"  2013 "Ronald R. Fogleman"                120  103.4
"00036110" "AIR"  2013 "Patrick J. Kelly"                 82.5  103.4
"00036110" "AIR"  2013 "Marc Jay Walfish"                   80  103.4
"00036110" "AIR"  2013 "Norman R. Bobins, BS, MBA"       86.25  103.4
"00036110" "AIR"  2013 "Ronald B. Woodard"               96.25  103.4
"00036110" "AIR"  2013 "James E. Goodwin"                 92.5  103.4
"00036110" "AIR"  2013 "Michael R. Boyce"                 72.5  103.4
"00036110" "AIR"  2013 "Anthony K. Anderson"             86.25  103.4
"00036110" "AIR"  2014 "Peter Pace, USMC, Ret."          81.25  122.5
"00036110" "AIR"  2014 "Ronald R. Fogleman"                120  122.5
"00036110" "AIR"  2014 "Patrick J. Kelly"                   85  122.5
"00036110" "AIR"  2014 "Marc Jay Walfish"                 87.5  122.5
"00036110" "AIR"  2014 "Norman R. Bobins, BS, MBA"       88.75  122.5
"00036110" "AIR"  2014 "Ronald B. Woodard"               98.75  122.5
"00036110" "AIR"  2014 "James E. Goodwin"                96.25  122.5
"00036110" "AIR"  2014 "Michael R. Boyce"                 82.5  122.5
"00036110" "AIR"  2014 "Anthony K. Anderson"              87.5  122.5
"00036110" "AIR"  2015 "Peter Pace, USMC, Ret."          81.25  147.7
"00036110" "AIR"  2015 "Ronald R. Fogleman"              122.5  147.7
"00036110" "AIR"  2015 "Patrick J. Kelly"                   85  147.7
"00036110" "AIR"  2015 "Marc Jay Walfish"                 87.5  147.7
"00036110" "AIR"  2015 "Norman R. Bobins, BS, MBA"       83.75  147.7
"00036110" "AIR"  2015 "Ronald B. Woodard"                97.5  147.7
"00036110" "AIR"  2015 "James E. Goodwin"                 97.5  147.7
"00036110" "AIR"  2015 "Michael R. Boyce"                81.25  147.7
"00036110" "AIR"  2015 "Anthony K. Anderson"              87.5  147.7
"00036110" "AIR"  2015 "Jennifer L. Vogel"              38.332 48.659
"00036110" "AIR"  2016 "Peter Pace, USMC, Ret."           87.5 121.95
"00036110" "AIR"  2016 "Ronald R. Fogleman"             123.75 121.95
"00036110" "AIR"  2016 "Patrick J. Kelly"                91.25 121.95
"00036110" "AIR"  2016 "Marc Jay Walfish"                   90 121.95
"00036110" "AIR"  2016 "Norman R. Bobins, BS, MBA"       88.75 121.95
"00036110" "AIR"  2016 "Ronald B. Woodard"                 100 121.95
"00036110" "AIR"  2016 "James E. Goodwin"                96.25 121.95
"00036110" "AIR"  2016 "Michael R. Boyce"                   80 121.95
"00036110" "AIR"  2016 "Anthony K. Anderson"             78.75 121.95
"00036110" "AIR"  2016 "Duncan J. McNabb"                   11 21.013
"00036110" "AIR"  2016 "Jennifer L. Vogel"                87.5 121.95
"00036110" "AIR"  2017 "Peter Pace, USMC, Ret."             80 174.75
"00036110" "AIR"  2017 "Ronald R. Fogleman"             45.641 174.75
"00036110" "AIR"  2017 "Patrick J. Kelly"                78.75 174.75
"00036110" "AIR"  2017 "Marc Jay Walfish"               92.651 174.75
"00036110" "AIR"  2017 "Norman R. Bobins, BS, MBA"          85 174.75
"00036110" "AIR"  2017 "Ronald B. Woodard"               96.25 174.75
"00036110" "AIR"  2017 "James E. Goodwin"              115.453 174.75
"00036110" "AIR"  2017 "Michael R. Boyce"                81.25 174.75
"00036110" "AIR"  2017 "Anthony K. Anderson"              72.5 174.75
"00036110" "AIR"  2017 "Duncan J. McNabb"                 82.5 174.75
"00036110" "AIR"  2017 "Jennifer L. Vogel"               81.25 174.75
"00088630" "ADCT" 2010 "David A. Roberts"                  103     70
"00088630" "ADCT" 2010 "Mickey P. Foret"               114.068     70
"00088630" "ADCT" 2010 "William R. Spivey"               191.5     70
"00088630" "ADCT" 2010 "Lois M. Martin"                107.952     70
"00088630" "ADCT" 2010 "Krish A. Prabhu, Ph.D."            114     70
"00088630" "ADCT" 2010 "Larry W. Wangberg"              110.75     70
"00088630" "ADCT" 2010 "John D. Wunsch"                    107     70
"00088630" "ADCT" 2010 "John E. Rehfeld"               117.051     70
"00088630" "ADCT" 2010 "John J. Boyle, III"                106     70
"02376R10" "AAL"  2010 "Ray M. Robinson, Jr."               39 24.103
"02376R10" "AAL"  2010 "Judith Rodin"                       37 24.103
"02376R10" "AAL"  2010 "Rajat Kumar Gupta"                  38 24.103
"02376R10" "AAL"  2010 "Matthew K. Rose"                    39 24.103
"02376R10" "AAL"  2010 "Philip J. Purcell, III"             39 24.103
"02376R10" "AAL"  2010 "Roger T. Staubach"                  37 24.103
"02376R10" "AAL"  2010 "David L. Boren"                     39 18.949
"02376R10" "AAL"  2010 "Michael A. Miles"                   39 24.103
"02376R10" "AAL"  2010 "Ann McLaughlin Korologos"           39 18.949
"02376R10" "AAL"  2010 "John W. Bachmann"                   39 24.103
"02376R10" "AAL"  2010 "Alberto Ibargen"                    39 24.103
"02376R10" "AAL"  2010 "Armando M. Codina"                  37 18.949
end
and lastly Firm performnace measures (from CRSP/Compustat on WRDS)

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str10 cusip str8 tic double year str58 conm double(at ni mkvalt) str4 sic
"000361105" "AIR"    2009 "AAR CORP"                      1501.042   44.628    777.8348 "5080"
"000361105" "AIR"    2010 "AAR CORP"                      1703.727   69.826   1049.8206 "5080"
"000361105" "AIR"    2011 "AAR CORP"                      2195.653   67.723    485.2897 "5080"
"000361105" "AIR"    2012 "AAR CORP"                        2136.9       55    790.0029 "5080"
"000361105" "AIR"    2013 "AAR CORP"                        2199.5     72.9     961.308 "5080"
"000361105" "AIR"    2014 "AAR CORP"                          1515     10.2   1046.3954 "5080"
"000361105" "AIR"    2015 "AAR CORP"                        1442.1     47.7    842.5112 "5080"
"000361105" "AIR"    2016 "AAR CORP"                        1504.1     56.5   1200.3288 "5080"
"000886309" "ADCT.1" 2009 "ADC TELECOMMUNICATIONS INC"      1343.6   -474.3     805.644 "3661"
"000886309" "ADCT.1" 2010 "ADC TELECOMMUNICATIONS INC"      1474.5       62    1231.524 "3661"
"02376R102" "AAL"    2009 "AMERICAN AIRLINES GROUP INC"      25438    -1468   2571.1835 "4512"
"02376R102" "AAL"    2010 "AMERICAN AIRLINES GROUP INC"      25088     -471   2597.5755 "4512"
"02376R102" "AAL"    2011 "AMERICAN AIRLINES GROUP INC"      23848    -1979    117.3438 "4512"
"02376R102" "AAL"    2013 "AMERICAN AIRLINES GROUP INC"      42278    -1834   6591.9923 "4512"
"02376R102" "AAL"    2014 "AMERICAN AIRLINES GROUP INC"      43771     2882  37405.5843 "4512"
"02376R102" "AAL"    2015 "AMERICAN AIRLINES GROUP INC"      48415     7610  26452.7417 "4512"
"02376R102" "AAL"    2016 "AMERICAN AIRLINES GROUP INC"      51274     2676  23685.5569 "4512"
"02376R102" "AAL"    2017 "AMERICAN AIRLINES GROUP INC"      51396     1919  24740.6812 "4512"
"125141101" "CECE"   2009 "CECO ENVIRONMENTAL CORP"         77.515  -15.032     56.4416 "3564"
"125141101" "CECE"   2010 "CECO ENVIRONMENTAL CORP"         74.791    2.105     85.3412 "3564"
"125141101" "CECE"   2011 "CECO ENVIRONMENTAL CORP"         79.345    8.272     80.5638 "3564"
"125141101" "CECE"   2012 "CECO ENVIRONMENTAL CORP"         94.104    10.85    168.7421 "3564"
"125141101" "CECE"   2013 "CECO ENVIRONMENTAL CORP"        348.536    6.557    413.2812 "3564"
"125141101" "CECE"   2014 "CECO ENVIRONMENTAL CORP"        414.365   13.077    408.1892 "3564"
"125141101" "CECE"   2015 "CECO ENVIRONMENTAL CORP"        598.819   -5.602    260.4902 "3564"
"125141101" "CECE"   2016 "CECO ENVIRONMENTAL CORP"        498.634  -38.218    476.5599 "3564"
"125141101" "CECE"   2017 "CECO ENVIRONMENTAL CORP"        438.549   -3.029    177.3441 "3564"
"G3156P103" "ASA"    2009 "ASA GOLD AND PRECIOUS METALS"   581.896   65.193     515.484 "6799"
"G3156P103" "ASA"    2010 "ASA GOLD AND PRECIOUS METALS"    671.58   95.887           . "6799"
"G3156P103" "ASA"    2011 "ASA GOLD AND PRECIOUS METALS"   632.715  -31.981           . "6799"
"G3156P103" "ASA"    2012 "ASA GOLD AND PRECIOUS METALS"   468.013 -152.257           . "6799"
"G3156P103" "ASA"    2013 "ASA GOLD AND PRECIOUS METALS"   252.142 -212.673           . "6799"
"G3156P103" "ASA"    2014 "ASA GOLD AND PRECIOUS METALS"   223.333  -27.775           . "6799"
"G3156P103" "ASA"    2015 "ASA GOLD AND PRECIOUS METALS"    162.35  -60.285           . "6799"
"G3156P103" "ASA"    2016 "ASA GOLD AND PRECIOUS METALS"    245.02   83.257    208.5249 "6799"
"G3156P103" "ASA"    2017 "ASA GOLD AND PRECIOUS METALS"   245.562    1.744    213.2047 "6799"
"002444107" "AVX"    2009 "AVX CORP"                      2051.492  142.858   2415.0508 "3670"
"002444107" "AVX"    2010 "AVX CORP"                      2319.482  244.003   2536.8172 "3670"
"002444107" "AVX"    2011 "AVX CORP"                      2468.012  152.805   2248.9093 "3670"
"002444107" "AVX"    2012 "AVX CORP"                      2601.995  -64.312   2006.7327 "3670"
"002444107" "AVX"    2013 "AVX CORP"                      2384.988  127.037   2217.1528 "3670"
"002444107" "AVX"    2014 "AVX CORP"                      2459.015  225.871   2400.0713 "3670"
"002444107" "AVX"    2015 "AVX CORP"                      2409.819  101.535   2105.3744 "3670"
"002444107" "AVX"    2016 "AVX CORP"                      2477.413  125.785   2750.6934 "3670"
"002444107" "AVX"    2017 "AVX CORP"                      2672.766     4.91   2787.5827 "3670"
"723484101" "PNW"    2009 "PINNACLE WEST CAPITAL CORP"   11808.155    68.33   3710.4923 "4911"
"723484101" "PNW"    2010 "PINNACLE WEST CAPITAL CORP"   12362.703  350.053   4508.5165 "4911"
"723484101" "PNW"    2011 "PINNACLE WEST CAPITAL CORP"   13111.018  339.473   5263.4723 "4911"
"723484101" "PNW"    2012 "PINNACLE WEST CAPITAL CORP"   13379.615  381.542   5594.6981 "4911"
"723484101" "PNW"    2013 "PINNACLE WEST CAPITAL CORP"   13508.686  406.074   5830.8314 "4911"
"723484101" "PNW"    2014 "PINNACLE WEST CAPITAL CORP"   14313.532  397.595    7553.105 "4911"
"723484101" "PNW"    2015 "PINNACLE WEST CAPITAL CORP"   15028.258  437.257   7155.9904 "4911"
"723484101" "PNW"    2016 "PINNACLE WEST CAPITAL CORP"   16004.253  442.034   8687.6261 "4911"
"723484101" "PNW"    2017 "PINNACLE WEST CAPITAL CORP"   17019.082  488.456   9519.0354 "4911"
"002535300" "AAN"    2009 "AARON'S INC"                   1321.456  112.601   1463.4506 "7359"
"002535300" "AAN"    2009 "AARON'S INC"                   1321.456  112.601   1463.4506 "7359"
"002535300" "AAN"    2010 "AARON'S INC"                   1502.072  118.376   1632.9739 "7359"
"002535300" "AAN"    2011 "AARON'S INC"                   1735.149  113.767   2018.0752 "7359"
"002535300" "AAN"    2012 "AARON'S INC"                   1812.929  173.043   2141.3616 "7359"
"002535300" "AAN"    2013 "AARON'S INC"                   1827.176  120.666   2144.9358 "7359"
"002535300" "AAN"    2014 "AARON'S INC"                   2456.844   78.233   2215.9582 "7359"
"002535300" "AAN"    2015 "AARON'S INC"                   2658.875  135.709    1625.514 "7359"
"002535300" "AAN"    2016 "AARON'S INC"                   2615.736  139.283   2285.6535 "7359"
"002535300" "AAN"    2017 "AARON'S INC"                   2692.264  292.536   2790.2572 "7359"
"002824100" "ABT"    2009 "ABBOTT LABORATORIES"          52416.623 5745.838  83747.5603 "2834"
"002824100" "ABT"    2010 "ABBOTT LABORATORIES"          59462.266 4626.172  74116.0034 "2834"
"002824100" "ABT"    2011 "ABBOTT LABORATORIES"          60276.893 4728.449  88302.4112 "2834"
"002824100" "ABT"    2012 "ABBOTT LABORATORIES"          67234.944  5962.92 103271.6885 "2834"
"002824100" "ABT"    2013 "ABBOTT LABORATORIES"              42953     2576  59338.5963 "2834"
"002824100" "ABT"    2014 "ABBOTT LABORATORIES"              41275     2284  67891.7357 "2834"
"002824100" "ABT"    2015 "ABBOTT LABORATORIES"              41247     4423  66137.3852 "2834"
"002824100" "ABT"    2016 "ABBOTT LABORATORIES"              52666     1400  56572.8983 "2834"
"002824100" "ABT"    2017 "ABBOTT LABORATORIES"              76250      477  99507.3661 "2834"
"81765M106" "SERV.1" 2009 "SERVIDYNE INC"                   40.952   -1.885     12.4988 "8700"
"81765M106" "SERV.1" 2010 "SERVIDYNE INC"                   26.228   -2.319      8.5651 "8700"
"004446100" "ACETQ"  2010 "ACETO CORP"                     231.851    6.581     145.628 "5160"
"004446100" "ACETQ"  2011 "ACETO CORP"                     311.665    8.968    178.6202 "5160"
"004446100" "ACETQ"  2012 "ACETO CORP"                      299.28   16.981    243.2411 "5160"
"004446100" "ACETQ"  2013 "ACETO CORP"                      323.43   22.328    387.6858 "5160"
"004446100" "ACETQ"  2014 "ACETO CORP"                     467.984       29    521.9241 "5160"
"004446100" "ACETQ"  2015 "ACETO CORP"                     489.774   33.483    717.8906 "5160"
"004446100" "ACETQ"  2016 "ACETO CORP"                     540.778   34.766    647.8346 "5160"
"004446100" "ACETQ"  2017 "ACETO CORP"                    1038.185   11.376    464.9523 "5160"
"004816104" "ACU"    2009 "ACME UNITED CORP"                42.309    2.842     29.0514 "3420"
"004816104" "ACU"    2010 "ACME UNITED CORP"                49.581    2.573     29.2169 "3420"
"004816104" "ACU"    2011 "ACME UNITED CORP"                55.222    2.811     29.7825 "3420"
"004816104" "ACU"    2012 "ACME UNITED CORP"                67.828    3.549        34.5 "3420"
"004816104" "ACU"    2013 "ACME UNITED CORP"                68.079    4.003     47.6949 "3420"
"004816104" "ACU"    2014 "ACME UNITED CORP"                79.308    4.789     65.7871 "3420"
"004816104" "ACU"    2015 "ACME UNITED CORP"                81.421    4.794     58.2552 "3420"
"004816104" "ACU"    2016 "ACME UNITED CORP"                92.066    5.851     85.0203 "3420"
"004816104" "ACU"    2017 "ACME UNITED CORP"                114.73    4.052     78.9516 "3420"
"05587G104" "BKTI"   2009 "BK TECHNOLOGIES CORP"            31.421    2.363     42.1262 "3663"
"05587G104" "BKTI"   2010 "BK TECHNOLOGIES CORP"            34.792     -.66     24.3162 "3663"
"05587G104" "BKTI"   2011 "BK TECHNOLOGIES CORP"            31.847    -.493     14.8709 "3663"
"05587G104" "BKTI"   2012 "BK TECHNOLOGIES CORP"             33.96    2.065     22.7556 "3663"
"05587G104" "BKTI"   2013 "BK TECHNOLOGIES CORP"            34.023    1.142     45.7949 "3663"
"05587G104" "BKTI"   2014 "BK TECHNOLOGIES CORP"            36.986    1.623      65.592 "3663"
"05587G104" "BKTI"   2015 "BK TECHNOLOGIES CORP"            39.449    1.041     54.1001 "3663"
"05587G104" "BKTI"   2016 "BK TECHNOLOGIES CORP"            42.544    2.689     65.1938 "3663"
end