Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem after merging two datasets: nothing is matched while cusip codes can be found in both datasets

    Hi all,

    I have merged two datasets with the following code:

    use "/Users/qi/Desktop/Data Finance Thesis/Datasets stata/Finance_datamergedboarddata.dta "
    merge 1:1 cusip year using "/Users/qi/Desktop/Data Finance Thesis/Datasets stata/Compensation_CEO_dta"

    After merging these two datasets Stata gives the following table:

    Result Number of obs
    -----------------------------------------
    Not matched 2,550
    from master 1,870 (_merge==1)
    from using 680 (_merge==2)

    Matched 0 (_merge==3)
    -----------------------------------------

    However, I don't understand why nothing is matched because many cusip codes are both in the master file and using file.
    Also, many other variables are the same in the master and using file (e.g. the names of the company, gvkey and names of the directors).

    Does someone know why my merged datafile does not find any matches and also how to fix this problem?

    I'm using Stata 17 on a macOS Catalina version 10.15.7

    Below a sample of my master data set and using data set

    Master file:

    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input str45 name double year str11 cusip str100 BoardName double at str4 TimeRole
    "ACCO BRANDS - ESG Combined Score"             2016 "00081T108" "ACCO BRANDS CORP"                                                                                   2064.5 ".6"  
    "ACCO BRANDS - ESG Combined Score"             2017 "00081T108" "ACCO BRANDS CORP"                                                                                   2799.1 "1.6" 
    "ACCO BRANDS - ESG Combined Score"             2018 "00081T108" "ACCO BRANDS CORP"                                                                                   2786.4 "2.6" 
    "ACCO BRANDS - ESG Combined Score"             2019 "00081T108" "ACCO BRANDS CORP"                                                                                   2788.6 "3.6" 
    "ACCO BRANDS - ESG Combined Score"             2020 "00081T108" "ACCO BRANDS CORP"                                                                                   3048.7 "4.6" 
    "ANI PHARMACEUTICALS - ESG Combined Score"     2016 "00182C103" "ANI PHARMACEUTICALS INC (BioSante Pharmaceuticals Inc prior to 07/2013)"                           322.864 "3.5" 
    "ANI PHARMACEUTICALS - ESG Combined Score"     2017 "00182C103" "ANI PHARMACEUTICALS INC (BioSante Pharmaceuticals Inc prior to 07/2013)"                           412.138 "4.5" 
    "ANI PHARMACEUTICALS - ESG Combined Score"     2018 "00182C103" "ANI PHARMACEUTICALS INC (BioSante Pharmaceuticals Inc prior to 07/2013)"                           430.604 "5.5" 
    "ANI PHARMACEUTICALS - ESG Combined Score"     2019 "00182C103" "ANI PHARMACEUTICALS INC (BioSante Pharmaceuticals Inc prior to 07/2013)"                           456.789 "6.5" 
    "ANI PHARMACEUTICALS - ESG Combined Score"     2020 "00182C103" "ANI PHARMACEUTICALS INC (BioSante Pharmaceuticals Inc prior to 07/2013)"                            461.19 ".3"  
    "ANGI A - ESG Combined Score"                  2016 "00183L102" "ANGI INC (ANGI Homeservices Inc prior to 03/2021)"                                                 295.517 "1.3" 
    "ANGI A - ESG Combined Score"                  2017 "00183L102" "ANGI INC (ANGI Homeservices Inc prior to 03/2021)"                                                1467.262 ".3"  
    "ANGI A - ESG Combined Score"                  2018 "00183L102" "ANGI INC (ANGI Homeservices Inc prior to 03/2021)"                                                1808.027 ".1"  
    "ANGI A - ESG Combined Score"                  2019 "00183L102" "ANGI INC (ANGI Homeservices Inc prior to 03/2021)"                                                1921.611 "1.1" 
    "ANGI A - ESG Combined Score"                  2020 "00183L102" "ANGI INC (ANGI Homeservices Inc prior to 03/2021)"                                                2368.182 "2.1" 
    "ABBVIE - ESG Combined Score"                  2016 "00287Y109" "ABBVIE INC"                                                                                          66099 "3.9" 
    "ABBVIE - ESG Combined Score"                  2017 "00287Y109" "ABBVIE INC"                                                                                          70786 "4.9" 
    "ABBVIE - ESG Combined Score"                  2018 "00287Y109" "ABBVIE INC"                                                                                          59352 "5.9" 
    "ABBVIE - ESG Combined Score"                  2019 "00287Y109" "ABBVIE INC"                                                                                          89115 "6.9" 
    "ABBVIE - ESG Combined Score"                  2020 "00287Y109" "ABBVIE INC"                                                                                         150565 "7.9" 
    "ACCELERATE DIAGNOSTICS - ESG Combined Score"  2016 "00430H102" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)"                              82.852 "4.3" 
    "ACCELERATE DIAGNOSTICS - ESG Combined Score"  2017 "00430H102" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)"                             125.512 "5.3" 
    "ACCELERATE DIAGNOSTICS - ESG Combined Score"  2018 "00430H102" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)"                             185.265 "6.3" 
    "ACCELERATE DIAGNOSTICS - ESG Combined Score"  2019 "00430H102" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)"                             134.424 "7.3" 
    "ACCELERATE DIAGNOSTICS - ESG Combined Score"  2020 "00430H102" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)"                              93.425 ".8"  
    "ACLARIS THERAPEUTICS - ESG Combined Score"    2016 "00461U105" "ACLARIS THERAPEUTICS INC"                                                                          176.085 "1.2" 
    "ACLARIS THERAPEUTICS - ESG Combined Score"    2017 "00461U105" "ACLARIS THERAPEUTICS INC"                                                                          243.509 "2.2" 
    "ACLARIS THERAPEUTICS - ESG Combined Score"    2018 "00461U105" "ACLARIS THERAPEUTICS INC"                                                                          275.566 "3.2" 
    "ACLARIS THERAPEUTICS - ESG Combined Score"    2019 "00461U105" "ACLARIS THERAPEUTICS INC"                                                                           98.297 "4.2" 
    "ACLARIS THERAPEUTICS - ESG Combined Score"    2020 "00461U105" "ACLARIS THERAPEUTICS INC"                                                                           70.784 "5.2" 
    "ACORDA THERAPEUTICS - ESG Combined Score"     2016 "00484M601" "ACORDA THERAPEUTICS INC"                                                                          1342.335 "10.8"
    "ACORDA THERAPEUTICS - ESG Combined Score"     2017 "00484M601" "ACORDA THERAPEUTICS INC"                                                                          1197.969 "11.8"
    "ACORDA THERAPEUTICS - ESG Combined Score"     2018 "00484M601" "ACORDA THERAPEUTICS INC"                                                                          1299.666 "12.8"
    "ACORDA THERAPEUTICS - ESG Combined Score"     2019 "00484M601" "ACORDA THERAPEUTICS INC"                                                                           799.718 "13.8"
    "ACORDA THERAPEUTICS - ESG Combined Score"     2020 "00484M601" "ACORDA THERAPEUTICS INC"                                                                            632.68 "14.8"
    "ACTIVISION BLIZZARD - ESG Combined Score"     2016 "00507V109" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)"                                           17452 "8.4" 
    "ACTIVISION BLIZZARD - ESG Combined Score"     2017 "00507V109" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)"                                           18668 ".5"  
    "ACTIVISION BLIZZARD - ESG Combined Score"     2018 "00507V109" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)"                                           17835 "1.5" 
    "ACTIVISION BLIZZARD - ESG Combined Score"     2019 "00507V109" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)"                                           19845 "2.5" 
    "ACTIVISION BLIZZARD - ESG Combined Score"     2020 "00507V109" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)"                                           23109 "3.5" 
    "ACUITY BRANDS - ESG Combined Score"           2016 "00508Y102" "ACUITY BRANDS INC"                                                                                    2948 "11.1"
    "ACUITY BRANDS - ESG Combined Score"           2017 "00508Y102" "ACUITY BRANDS INC"                                                                                  2899.6 "12.1"
    "ACUITY BRANDS - ESG Combined Score"           2018 "00508Y102" "ACUITY BRANDS INC"                                                                                  2988.8 "13.1"
    "ACUITY BRANDS - ESG Combined Score"           2019 "00508Y102" "ACUITY BRANDS INC"                                                                                  3172.4 "14.1"
    "ACUITY BRANDS - ESG Combined Score"           2020 "00508Y102" "ACUITY BRANDS INC"                                                                                  3491.7 ".6"  
    "ADTRAN - ESG Combined Score"                  2016 "00738A106" "ADTRAN INC"                                                                                        667.235 "9.7" 
    "ADTRAN - ESG Combined Score"                  2017 "00738A106" "ADTRAN INC"                                                                                        669.094 "10.7"
    "ADTRAN - ESG Combined Score"                  2018 "00738A106" "ADTRAN INC"                                                                                        628.027 "11.7"
    "ADTRAN - ESG Combined Score"                  2019 "00738A106" "ADTRAN INC"                                                                                        545.118 "12.7"
    "ADTRAN - ESG Combined Score"                  2020 "00738A106" "ADTRAN INC"                                                                                        525.679 "13.7"
    "AERIE PHARMACEUTICALS - ESG Combined Score"   2016 "00771V108" "AERIE PHARMACEUTICALS INC"                                                                         248.254 "3.2" 
    "AERIE PHARMACEUTICALS - ESG Combined Score"   2017 "00771V108" "AERIE PHARMACEUTICALS INC"                                                                         290.276 "4.2" 
    "AERIE PHARMACEUTICALS - ESG Combined Score"   2018 "00771V108" "AERIE PHARMACEUTICALS INC"                                                                         285.044 "5.2" 
    "AERIE PHARMACEUTICALS - ESG Combined Score"   2019 "00771V108" "AERIE PHARMACEUTICALS INC"                                                                         452.608 "6.2" 
    "AERIE PHARMACEUTICALS - ESG Combined Score"   2020 "00771V108" "AERIE PHARMACEUTICALS INC"                                                                         402.045 "7.2" 
    "ADVANSIX - ESG Combined Score"                2016 "00773T101" "ADVANSIX INC"                                                                                      904.957 ".2"  
    "ADVANSIX - ESG Combined Score"                2017 "00773T101" "ADVANSIX INC"                                                                                     1050.274 "1.2" 
    "ADVANSIX - ESG Combined Score"                2018 "00773T101" "ADVANSIX INC"                                                                                     1034.626 "2.2" 
    "ADVANSIX - ESG Combined Score"                2019 "00773T101" "ADVANSIX INC"                                                                                     1235.969 "3.2" 
    "ADVANSIX - ESG Combined Score"                2020 "00773T101" "ADVANSIX INC"                                                                                     1263.407 "4.2" 
    "AGIOS PHARMACEUTICALS - ESG Combined Score"   2016 "00847X104" "AGIOS PHARMACEUTICALS INC"                                                                         619.094 "3.4" 
    "AGIOS PHARMACEUTICALS - ESG Combined Score"   2017 "00847X104" "AGIOS PHARMACEUTICALS INC"                                                                         614.397 "4.4" 
    "AGIOS PHARMACEUTICALS - ESG Combined Score"   2018 "00847X104" "AGIOS PHARMACEUTICALS INC"                                                                         858.457 "5.4" 
    "AGIOS PHARMACEUTICALS - ESG Combined Score"   2019 "00847X104" "AGIOS PHARMACEUTICALS INC"                                                                         890.741 ".8"  
    "AGIOS PHARMACEUTICALS - ESG Combined Score"   2020 "00847X104" "AGIOS PHARMACEUTICALS INC"                                                                         852.952 "1.8" 
    "AKEBIA THERAPEUTICS - ESG Combined Score"     2016 "00972D105" "AKEBIA THERAPEUTICS INC"                                                                           300.216 "2.8" 
    "AKEBIA THERAPEUTICS - ESG Combined Score"     2017 "00972D105" "AKEBIA THERAPEUTICS INC"                                                                           364.247 "3.8" 
    "AKEBIA THERAPEUTICS - ESG Combined Score"     2018 "00972D105" "AKEBIA THERAPEUTICS INC"                                                                            996.54 "4.8" 
    "AKEBIA THERAPEUTICS - ESG Combined Score"     2019 "00972D105" "AKEBIA THERAPEUTICS INC"                                                                           771.201 "5.8" 
    "AKEBIA THERAPEUTICS - ESG Combined Score"     2020 "00972D105" "AKEBIA THERAPEUTICS INC"                                                                           644.139 "6.8" 
    "ALLISON TNSM.HOLDINGS - ESG Combined Score"   2016 "01973R101" "ALLISON TRANSMISSION HOLDINGS INC"                                                                  4218.6 ".9"  
    "ALLISON TNSM.HOLDINGS - ESG Combined Score"   2017 "01973R101" "ALLISON TRANSMISSION HOLDINGS INC"                                                                    4205 "1.9" 
    "ALLISON TNSM.HOLDINGS - ESG Combined Score"   2018 "01973R101" "ALLISON TRANSMISSION HOLDINGS INC"                                                                    4237 ".5"  
    "ALLISON TNSM.HOLDINGS - ESG Combined Score"   2019 "01973R101" "ALLISON TRANSMISSION HOLDINGS INC"                                                                    4450 "1.5" 
    "ALLISON TNSM.HOLDINGS - ESG Combined Score"   2020 "01973R101" "ALLISON TRANSMISSION HOLDINGS INC"                                                                    4477 "2.5" 
    "ALSP.HLTHCR.SLTN. - ESG Combined Score"       2016 "01988P108" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" 3832.159 "1.2" 
    "ALSP.HLTHCR.SLTN. - ESG Combined Score"       2017 "01988P108" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)"  4230.15 "2.2" 
    "ALSP.HLTHCR.SLTN. - ESG Combined Score"       2018 "01988P108" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" 3181.484 "3.2" 
    "ALSP.HLTHCR.SLTN. - ESG Combined Score"       2019 "01988P108" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" 3205.739 "4.2" 
    "ALSP.HLTHCR.SLTN. - ESG Combined Score"       2020 "01988P108" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" 2917.618 "5.2" 
    "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2016 "02043Q107" "ALNYLAM PHARMACEUTICALS INC"                                                                       1262.81 "9"   
    "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2017 "02043Q107" "ALNYLAM PHARMACEUTICALS INC"                                                                       1994.73 "10"  
    "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2018 "02043Q107" "ALNYLAM PHARMACEUTICALS INC"                                                                      1574.802 "11"  
    "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2019 "02043Q107" "ALNYLAM PHARMACEUTICALS INC"                                                                      2395.134 "12"  
    "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2020 "02043Q107" "ALNYLAM PHARMACEUTICALS INC"                                                                      3407.061 "13"  
    end
    Using file
    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input str50 CONAME str8 cusip str250 Title double(TDC2 SHROWN_TOT_PCT)
    "ABBVIE INC"                   "00287Y10" "Chairman & CEO"                                   23367.788  .022
    "ABBVIE INC"                   "00287Y10" "Chairman & CEO"                                   32353.208  .021
    "ABBVIE INC"                   "00287Y10" "Chairman & CEO"                                   18059.618  .026
    "ABBVIE INC"                   "00287Y10" "Chairman & CEO"                                   15997.625  .026
    "ABBVIE INC"                   "00287Y10" "Chairman & CEO"                                   15118.724  .033
    "ACTIVISION BLIZZARD INC"      "00507V10" "CEO & Director"                                    33065.56  .321
    "ACTIVISION BLIZZARD INC"      "00507V10" "CEO & Director"                                  153330.522  .329
    "ACTIVISION BLIZZARD INC"      "00507V10" "CEO & Director"                                   11803.331  .333
    "ACTIVISION BLIZZARD INC"      "00507V10" "CEO & Director"                                   10985.655  .312
    "ACTIVISION BLIZZARD INC"      "00507V10" "CEO & Director"                                  154613.318  .413
    "ADTRAN INC"                   "00738A10" "Chairman & CEO"                                    3563.571 1.371
    "ADTRAN INC"                   "00738A10" "Chairman & CEO"                                    4439.528 1.395
    "ADTRAN INC"                   "00738A10" "Chairman & CEO"                                    1998.293 1.342
    "ADTRAN INC"                   "00738A10" "Chairman & CEO"                                    1962.156 1.259
    "ADTRAN INC"                   "00738A10" "Chairman & CEO"                                    2898.033 1.179
    "ADVANSIX INC"                 "00773T10" "CEO, President & Director"                          734.491     0
    "ADVANSIX INC"                 "00773T10" "CEO, President & Director"                         2738.882     0
    "ADVANSIX INC"                 "00773T10" "CEO, President & Director"                         2672.017  .175
    "ADVANSIX INC"                 "00773T10" "CEO, President & Director"                         3183.819 1.227
    "ADVANSIX INC"                 "00773T10" "CEO, President & Director"                         3725.573 1.526
    "ALLSCRIPTS HEALTHCARE SOLTNS" "01988P10" "CEO & Director"                                    6601.865  .426
    "ALLSCRIPTS HEALTHCARE SOLTNS" "01988P10" "CEO & Director"                                    7724.584  .531
    "ALLSCRIPTS HEALTHCARE SOLTNS" "01988P10" "CEO & Director"                                    7801.251  .669
    "ALLSCRIPTS HEALTHCARE SOLTNS" "01988P10" "CEO & Director"                                    7508.612  .778
    "ALLSCRIPTS HEALTHCARE SOLTNS" "01988P10" "CEO & Director"                                    7947.718  .924
    "APPLIED OPTOELECTRONICS INC"  "03823U10" "Founder, Chairman of the Board, President & CEO"    808.946 1.063
    "APPLIED OPTOELECTRONICS INC"  "03823U10" "Founder, Chairman of the Board, President & CEO"  27824.936 2.204
    "APPLIED OPTOELECTRONICS INC"  "03823U10" "Founder, Chairman of the Board, President & CEO"  10319.196 2.543
    "APPLIED OPTOELECTRONICS INC"  "03823U10" "Founder, Chairman of the Board, President & CEO"   2114.482 2.711
    "APPLIED OPTOELECTRONICS INC"  "03823U10" "Founder, Chairman of the Board, President & CEO"      845.7 1.979
    "AXON ENTERPRISE INC"          "05464C10" "Co-Founder, CEO & Director"                        1540.628 2.392
    "AXON ENTERPRISE INC"          "05464C10" "Co-Founder, CEO & Director"                        5918.409 2.324
    "AXON ENTERPRISE INC"          "05464C10" "Co-Founder, CEO & Director"                      268758.042 1.225
    "AXON ENTERPRISE INC"          "05464C10" "Co-Founder, CEO & Director"                          38.529 1.044
    "AXON ENTERPRISE INC"          "05464C10" "Co-Founder, CEO & Director"                          27.967  1.52
    "BIO-TECHNE CORP"              "09073M10" "CEO, President & Director"                         6013.748  .587
    "BIO-TECHNE CORP"              "09073M10" "CEO, President & Director"                         7302.257   .96
    "BIO-TECHNE CORP"              "09073M10" "CEO, President & Director"                         9664.639 1.442
    "BIO-TECHNE CORP"              "09073M10" "CEO, President & Director"                        11011.036  .359
    "BIO-TECHNE CORP"              "09073M10" "CEO, President & Director"                        23652.736  2.35
    "BLACKBAUD INC"                "09227Q10" "President, CEO & Director"                         5709.266  .567
    "BLACKBAUD INC"                "09227Q10" "President, CEO & Director"                         7992.151  .554
    "BLACKBAUD INC"                "09227Q10" "President, CEO & Director"                          9289.69  .574
    "BLACKBAUD INC"                "09227Q10" "President, CEO & Director"                         11133.21  .548
    "BLACKBAUD INC"                "09227Q10" "President, CEO & Director"                          9470.95  .613
    "BOTTOMLINE TECHNOLOGIES INC"  "10138810" "President, CEO & Director"                         3489.638  1.16
    "BOTTOMLINE TECHNOLOGIES INC"  "10138810" "President, CEO & Director"                         2967.632 1.034
    "BOTTOMLINE TECHNOLOGIES INC"  "10138810" "President, CEO & Director"                         6703.447 1.001
    "BOTTOMLINE TECHNOLOGIES INC"  "10138810" "President, CEO & Director"                         8373.383 1.135
    "BOTTOMLINE TECHNOLOGIES INC"  "10138810" "President, CEO & Director"                         5670.558 1.147
    "BRADY CORP"                   "10467410" "President, CEO & Director"                         2778.419   .04
    "BRADY CORP"                   "10467410" "President, CEO & Director"                         3612.304  .052
    "BRADY CORP"                   "10467410" "President, CEO & Director"                         5955.853  .071
    "BRADY CORP"                   "10467410" "President, CEO & Director"                         7432.943  .216
    "BRADY CORP"                   "10467410" "President, CEO & Director"                         5256.402  .075
    "CABOT CORP"                   "12705510" "President, CEO & Director"                         2683.491  .226
    "CABOT CORP"                   "12705510" "President, CEO & Director"                         4452.145  .316
    "CABOT CORP"                   "12705510" "President, CEO & Director"                         7088.695  .396
    "CABOT CORP"                   "12705510" "President, CEO & Director"                         5089.332  .648
    "CABOT CORP"                   "12705510" "President, CEO & Director"                         4243.123  .902
    "CALLAWAY GOLF CO"             "13119310" "President, CEO & Director"                         5493.355  .451
    "CALLAWAY GOLF CO"             "13119310" "President, CEO & Director"                         5340.644  .933
    "CALLAWAY GOLF CO"             "13119310" "President, CEO & Director"                         6229.556 1.149
    "CALLAWAY GOLF CO"             "13119310" "President, CEO & Director"                         5710.518 1.387
    "CALLAWAY GOLF CO"             "13119310" "President, CEO & Director"                         4929.381    .8
    "CARPENTER TECHNOLOGY CORP"    "14428510" "President, CEO & Director"                         2686.792  .085
    "CARPENTER TECHNOLOGY CORP"    "14428510" "President, CEO & Director"                         5533.154  .204
    "CARPENTER TECHNOLOGY CORP"    "14428510" "President, CEO & Director"                         5469.439  .321
    "CARPENTER TECHNOLOGY CORP"    "14428510" "President, CEO & Director"                         3349.665  .332
    "CARPENTER TECHNOLOGY CORP"    "14428510" "President, CEO & Director"                          3550.66  .444
    "CATALENT INC"                 "14880610" "Chairman & CEO"                                   13086.324  .499
    "CATALENT INC"                 "14880610" "Chairman & CEO"                                    7302.629  .779
    "CATALENT INC"                 "14880610" "Chairman & CEO"                                   11199.239  .189
    "CATALENT INC"                 "14880610" "Chairman & CEO"                                    9538.172  .533
    "CATALENT INC"                 "14880610" "Chairman & CEO"                                    3728.234  .531
    "CEVA INC"                     "15721010" "CEO & Director"                                    1475.486  .264
    "CEVA INC"                     "15721010" "CEO & Director"                                    1699.628  .129
    "CEVA INC"                     "15721010" "CEO & Director"                                     592.128  .309
    "CEVA INC"                     "15721010" "CEO & Director"                                    1070.148  .456
    "CEVA INC"                     "15721010" "CEO & Director"                                    2569.795  .333
    "CHURCH & DWIGHT INC"          "17134010" "President, CEO & Chairman"                         2660.309  .228
    "CHURCH & DWIGHT INC"          "17134010" "President, CEO & Chairman"                         2409.622  .332
    "CHURCH & DWIGHT INC"          "17134010" "President, CEO & Chairman"                         2890.189  .601
    "CHURCH & DWIGHT INC"          "17134010" "President, CEO & Chairman"                         3377.324  .605
    "CHURCH & DWIGHT INC"          "17134010" "President, CEO & Chairman"                        22462.537  .643
    "CHURCHILL DOWNS INC"          "17148410" "CEO & Director"                                    5457.261  .811
    "CHURCHILL DOWNS INC"          "17148410" "CEO & Director"                                    7447.193 1.146
    "CHURCHILL DOWNS INC"          "17148410" "CEO & Director"                                   21120.369 1.312
    "CHURCHILL DOWNS INC"          "17148410" "CEO & Director"                                   10601.294 1.375
    "CHURCHILL DOWNS INC"          "17148410" "CEO & Director"                                   10491.139 1.434
    "CIENA CORP"                   "17177930" "CEO, President & Director"                         6240.092  .242
    "CIENA CORP"                   "17177930" "CEO, President & Director"                         7635.212  .225
    "CIENA CORP"                   "17177930" "CEO, President & Director"                         9129.584  .172
    "CIENA CORP"                   "17177930" "CEO, President & Director"                        11016.365  .115
    "CIENA CORP"                   "17177930" "CEO, President & Director"                        11202.255  .154
    "CIRCOR INTL INC"              "17273K10" "President, CEO & Director"                         2041.046  .107
    "CIRCOR INTL INC"              "17273K10" "President, CEO & Director"                         2068.656  1.46
    "CIRCOR INTL INC"              "17273K10" "President, CEO & Director"                         2826.398 1.849
    "CIRCOR INTL INC"              "17273K10" "President, CEO & Director"                         2033.846 2.322
    "CIRCOR INTL INC"              "17273K10" "President, CEO & Director"                         3603.037 2.965
    end
    Thanks in advance!

  • #2
    cuisp can't be the identifier then. If you have panel data for a 1 to 1, you usually wanna match on panel ID AND your time variable year

    Comment


    • #3
      In your master dataset we see CUSIP code "00287Y109" while in your using file we see CUSIP code "00287Y10". So 9 characters in the master dataset and 8 characters in the using file. Wikipedia tells us the 9th character in the CUSIP is a check digit created from the first 8 characters and has no meaning. The using dataset apparently omits the check digit.

      The codes must match exactly in the two datasets for merge to work. Perhaps the following is what you need to do.
      Code:
      use "/Users/qi/Desktop/Data Finance Thesis/Datasets stata/Finance_datamergedboarddata.dta"
      clonevar cusip cusip9 = cusip // * save a copy of the original cusip
      replace cusip = substr(cusip,1,8)
      merge 1:1 cusip year using "/Users/qi/Desktop/Data Finance Thesis/Datasets stata/Compensation_CEO_dta"

      Comment


      • #4
        Thank you both for your help, William your code worked!

        Comment

        Working...
        X