Hi all,
I want to merge two datasets and made sure that the key variables that I use for the merge have the same name in both the master data file and the using data file.
However, when I try to merge, Stata reports the following error: variables ISIN year do not uniquely identify observations in the using data (r459).
I used the following code:
merge 1:1 ISIN year using "/Users/qivanderkolk/Downloads/CEO_Yearvariable.dta"
Stata reports the error: variables ISIN year do not uniquely identify observations in the using data r(459).
I tried it again by using the variable Ticker year instead of ISIN year but I get the same error. But besides year, ISIN and Ticker there are no variables that are in both the master data file and the using datafile.
What am I doing wrong?
Does anyone know which code I can use to merge these two data sets?
Below a sample of my master data set and using data set.
Master dataset:
Using dataset:
Thanks in advance!
I want to merge two datasets and made sure that the key variables that I use for the merge have the same name in both the master data file and the using data file.
However, when I try to merge, Stata reports the following error: variables ISIN year do not uniquely identify observations in the using data (r459).
I used the following code:
merge 1:1 ISIN year using "/Users/qivanderkolk/Downloads/CEO_Yearvariable.dta"
Stata reports the error: variables ISIN year do not uniquely identify observations in the using data r(459).
I tried it again by using the variable Ticker year instead of ISIN year but I get the same error. But besides year, ISIN and Ticker there are no variables that are in both the master data file and the using datafile.
What am I doing wrong?
Does anyone know which code I can use to merge these two data sets?
Below a sample of my master data set and using data set.
Master dataset:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str12 ISIN str45 name double(year v at mkvalt) "US00846U1016" "AGILENT TECHS. - ESG Combined Score" 2016 88.42 7802 14093.1958 "US00846U1016" "AGILENT TECHS. - ESG Combined Score" 2017 87.48 8426 21903.9593 "US00846U1016" "AGILENT TECHS. - ESG Combined Score" 2018 89.44 8541 20584.7549 "US00846U1016" "AGILENT TECHS. - ESG Combined Score" 2019 88.66 9452 23412.1283 "US00846U1016" "AGILENT TECHS. - ESG Combined Score" 2020 88.65 9627 31259.7538 "US03823U1025" "APPLIED OPTOELECTRONICS - ESG Combined Score" 2016 17.54 322.318 431.296 "US03823U1025" "APPLIED OPTOELECTRONICS - ESG Combined Score" 2017 17.98 452.984 735.6368 "US03823U1025" "APPLIED OPTOELECTRONICS - ESG Combined Score" 2018 17 466.84 305.6683 "US03823U1025" "APPLIED OPTOELECTRONICS - ESG Combined Score" 2019 17.91 466.825 239.2632 "US03823U1025" "APPLIED OPTOELECTRONICS - ESG Combined Score" 2020 17.1 480.805 213.6861 "US00751Y1064" "ADV.AUTO PARTS - ESG Combined Score" 2016 33.27 8315.033 12472.4309 "US00751Y1064" "ADV.AUTO PARTS - ESG Combined Score" 2017 54.78 8482.301 7370.6798 "US00751Y1064" "ADV.AUTO PARTS - ESG Combined Score" 2018 62.67 9040.648 11409.5516 "US00751Y1064" "ADV.AUTO PARTS - ESG Combined Score" 2019 43.49 11248.525 11088.1971 "US00751Y1064" "ADV.AUTO PARTS - ESG Combined Score" 2020 52.08 11839.636 10452.5211 "US00287Y1091" "ABBVIE - ESG Combined Score" 2016 74.88 66099 99723.1641 "US00287Y1091" "ABBVIE - ESG Combined Score" 2017 70.79 70786 153974.989 "US00287Y1091" "ABBVIE - ESG Combined Score" 2018 50.58 59352 136332.7846 "US00287Y1091" "ABBVIE - ESG Combined Score" 2019 56.9 89115 130942.8685 "US00287Y1091" "ABBVIE - ESG Combined Score" 2020 48.59 150565 189134.001 "US00081T1088" "ACCO BRANDS - ESG Combined Score" 2016 57.89 2064.5 1408.1864 "US00081T1088" "ACCO BRANDS - ESG Combined Score" 2017 60.04 2799.1 1301.5448 "US00081T1088" "ACCO BRANDS - ESG Combined Score" 2018 70.07 2786.4 696.6382 "US00081T1088" "ACCO BRANDS - ESG Combined Score" 2019 74.89 2788.6 902.7252 "US00081T1088" "ACCO BRANDS - ESG Combined Score" 2020 74.04 3048.7 802.2684 "US00404A1097" "ACADIA HEALTHCARE CO. - ESG Combined Score" 2016 19.41 6024.726 2869.3728 "US00404A1097" "ACADIA HEALTHCARE CO. - ESG Combined Score" 2017 29.55 6424.502 2840.7678 "US00404A1097" "ACADIA HEALTHCARE CO. - ESG Combined Score" 2018 47 6172.504 2248.1852 "US00404A1097" "ACADIA HEALTHCARE CO. - ESG Combined Score" 2019 53.83 6879.142 2913.9255 "US00404A1097" "ACADIA HEALTHCARE CO. - ESG Combined Score" 2020 52.47 6499.362 4424.0862 "IE00B4BNMY34" "ACCENTURE CLASS A - ESG Combined Score" 2016 78.16 20609.004 71377.395 "IE00B4BNMY34" "ACCENTURE CLASS A - ESG Combined Score" 2017 78.45 22689.89 80490.2333 "IE00B4BNMY34" "ACCENTURE CLASS A - ESG Combined Score" 2018 73.63 24449.083 108041.6475 "IE00B4BNMY34" "ACCENTURE CLASS A - ESG Combined Score" 2019 72.57 29789.88 125991.3336 "IE00B4BNMY34" "ACCENTURE CLASS A - ESG Combined Score" 2020 73.81 37078.593 152155.4484 "US00484M6012" "ACORDA THERAPEUTICS - ESG Combined Score" 2016 23.68 1342.335 858.5584 "US00484M6012" "ACORDA THERAPEUTICS - ESG Combined Score" 2017 24.94 1197.969 995.8163 "US00484M6012" "ACORDA THERAPEUTICS - ESG Combined Score" 2018 27.45 1299.666 738.8192 "US00484M6012" "ACORDA THERAPEUTICS - ESG Combined Score" 2019 37.7 799.718 97.31 "US00484M6012" "ACORDA THERAPEUTICS - ESG Combined Score" 2020 37.3 632.68 39.2122 "US00461U1051" "ACLARIS THERAPEUTICS - ESG Combined Score" 2016 11.09 176.085 707.2413 "US00461U1051" "ACLARIS THERAPEUTICS - ESG Combined Score" 2017 24.6 243.509 760.9336 "US00461U1051" "ACLARIS THERAPEUTICS - ESG Combined Score" 2018 22.72 275.566 304.5493 "US00461U1051" "ACLARIS THERAPEUTICS - ESG Combined Score" 2019 21.42 98.297 78.4085 "US00461U1051" "ACLARIS THERAPEUTICS - ESG Combined Score" 2020 36.34 70.784 291.8552 "US00724F1012" "ADOBE (NAS) - ESG Combined Score" 2016 62.58 12707.114 50814.2537 "US00724F1012" "ADOBE (NAS) - ESG Combined Score" 2017 75.6 14535.556 89149.3151 "US00724F1012" "ADOBE (NAS) - ESG Combined Score" 2018 78.43 18768.682 122349.7701 "US00724F1012" "ADOBE (NAS) - ESG Combined Score" 2019 67.3 20762.4 149298.3907 "US00724F1012" "ADOBE (NAS) - ESG Combined Score" 2020 77.67 24284 229187.13 "IE00BD845X29" "ADIENT - ESG Combined Score" 2016 36.89 13033 . "IE00BD845X29" "ADIENT - ESG Combined Score" 2017 39.62 13170 7822.9966 "IE00BD845X29" "ADIENT - ESG Combined Score" 2018 35.15 10942 3671.3968 "IE00BD845X29" "ADIENT - ESG Combined Score" 2019 39.73 10342 2149.5382 "IE00BD845X29" "ADIENT - ESG Combined Score" 2020 34.96 10261 1627.183 "US00738A1060" "ADTRAN - ESG Combined Score" 2016 52.79 667.235 1083.3492 "US00738A1060" "ADTRAN - ESG Combined Score" 2017 47.36 669.094 938.1848 "US00738A1060" "ADTRAN - ESG Combined Score" 2018 53.51 628.027 512.8457 "US00738A1060" "ADTRAN - ESG Combined Score" 2019 35.93 545.118 474.9178 "US00738A1060" "ADTRAN - ESG Combined Score" 2020 50.83 525.679 712.5196 "US00771V1089" "AERIE PHARMACEUTICALS - ESG Combined Score" 2016 23.28 248.254 1266.4232 "US00771V1089" "AERIE PHARMACEUTICALS - ESG Combined Score" 2017 20.16 290.276 2207.643 "US00771V1089" "AERIE PHARMACEUTICALS - ESG Combined Score" 2018 28 285.044 1641.7919 "US00771V1089" "AERIE PHARMACEUTICALS - ESG Combined Score" 2019 47.22 452.608 1123.0591 "US00771V1089" "AERIE PHARMACEUTICALS - ESG Combined Score" 2020 56.57 402.045 632.5652 "US00847X1046" "AGIOS PHARMACEUTICALS - ESG Combined Score" 2016 20.9 619.094 1761.8406 "US00847X1046" "AGIOS PHARMACEUTICALS - ESG Combined Score" 2017 38.55 614.397 2791.3824 "US00847X1046" "AGIOS PHARMACEUTICALS - ESG Combined Score" 2018 39.56 858.457 2684.4781 "US00847X1046" "AGIOS PHARMACEUTICALS - ESG Combined Score" 2019 51.73 890.741 3266.1478 "US00847X1046" "AGIOS PHARMACEUTICALS - ESG Combined Score" 2020 57.55 852.952 3002.509 "US02208R1068" "ALTRA INDUSTRIAL MOTION - ESG Combined Score" 2016 24.9 869.824 1003.9014 "US02208R1068" "ALTRA INDUSTRIAL MOTION - ESG Combined Score" 2017 28.18 920.657 1464.5232 "US02208R1068" "ALTRA INDUSTRIAL MOTION - ESG Combined Score" 2018 42.11 4337.243 1614.2779 "US02208R1068" "ALTRA INDUSTRIAL MOTION - ESG Combined Score" 2019 44.86 4283.7 2325.5148 "US02208R1068" "ALTRA INDUSTRIAL MOTION - ESG Combined Score" 2020 45.42 4208.1 3585.0461 "US03820C1053" "APPLIED INDL.TECHS. - ESG Combined Score" 2016 12.43 1312.529 1763.033 "US03820C1053" "APPLIED INDL.TECHS. - ESG Combined Score" 2017 11.78 1387.595 2305.3711 "US03820C1053" "APPLIED INDL.TECHS. - ESG Combined Score" 2018 13.43 2285.741 2715.0155 "US03820C1053" "APPLIED INDL.TECHS. - ESG Combined Score" 2019 28.89 2331.697 2374.8734 "US03820C1053" "APPLIED INDL.TECHS. - ESG Combined Score" 2020 26.74 2283.551 2415.1169 "US00971T1016" "AKAMAI TECHS. - ESG Combined Score" 2016 44.73 4373.146 11552.6434 "US00971T1016" "AKAMAI TECHS. - ESG Combined Score" 2017 60.98 4602.844 11049.8407 "US00971T1016" "AKAMAI TECHS. - ESG Combined Score" 2018 52.16 5461.77 9950.2374 "US00971T1016" "AKAMAI TECHS. - ESG Combined Score" 2019 57.48 7006.886 13993.6464 "US00971T1016" "AKAMAI TECHS. - ESG Combined Score" 2020 58.29 7764.13 17082.9229 "US00972D1054" "AKEBIA THERAPEUTICS - ESG Combined Score" 2016 17.75 300.216 401.9926 "US00972D1054" "AKEBIA THERAPEUTICS - ESG Combined Score" 2017 20.97 364.247 708.0053 "US00972D1054" "AKEBIA THERAPEUTICS - ESG Combined Score" 2018 23.39 996.54 646.3906 "US00972D1054" "AKEBIA THERAPEUTICS - ESG Combined Score" 2019 28.32 771.201 768.986 "US00972D1054" "AKEBIA THERAPEUTICS - ESG Combined Score" 2020 31.91 644.139 414.6072 "IE00BFRT3W74" "ALLEGION - ESG Combined Score" 2016 37.06 2247.4 6097.536 "IE00BFRT3W74" "ALLEGION - ESG Combined Score" 2017 46.86 2542 7563.1327 "IE00BFRT3W74" "ALLEGION - ESG Combined Score" 2018 58.97 2810.2 7543.5153 "IE00BFRT3W74" "ALLEGION - ESG Combined Score" 2019 58.81 2967.2 11547.847 "IE00BFRT3W74" "ALLEGION - ESG Combined Score" 2020 71.37 3069.4 10615.3689 "US02043Q1076" "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2016 32.52 1262.81 3217.631 "US02043Q1076" "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2017 47.43 1994.73 12662.6924 "US02043Q1076" "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2018 37.06 1574.802 7376.8151 "US02043Q1076" "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2019 58.14 2395.134 12920.692 "US02043Q1076" "ALNYLAM PHARMACEUTICALS - ESG Combined Score" 2020 50.33 3407.061 15128.508 end
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str12 ISIN str100 BoardName str41 RoleName long BoardID int year str4 TimeRole "US90214J1016" "2U INC" "CEO" 2057807 2016 "2.8" "US90214J1016" "2U INC" "CEO" 2057807 2017 "3.8" "US90214J1016" "2U INC" "CEO" 2057807 2018 "4.8" "US90214J1016" "2U INC" "CEO" 2057807 2019 "5.8" "US90214J1016" "2U INC" "CEO" 2057807 2020 "6.8" "US88554D2053" "3D SYSTEMS CORP (3 D Systems prior to 04/2003)" "President/CEO" 276 2016 ".7" "US88554D2053" "3D SYSTEMS CORP (3 D Systems prior to 04/2003)" "President/CEO" 276 2017 "1.7" "US88554D2053" "3D SYSTEMS CORP (3 D Systems prior to 04/2003)" "President/CEO" 276 2018 "2.7" "US88554D2053" "3D SYSTEMS CORP (3 D Systems prior to 04/2003)" "President/CEO" 276 2019 "3.7" "US88554D2053" "3D SYSTEMS CORP (3 D Systems prior to 04/2003)" "President/CEO" 276 2020 ".6" "US88579Y1010" "3M CO (Minnesota Mining & Manufacturing Co prior to 02/2002)" "Chairman/President/CEO" 20777 2016 "4.6" "US88579Y1010" "3M CO (Minnesota Mining & Manufacturing Co prior to 02/2002)" "Chairman/President/CEO" 20777 2017 "5.6" "US88579Y1010" "3M CO (Minnesota Mining & Manufacturing Co prior to 02/2002)" "CEO" 20777 2018 ".4" "US88579Y1010" "3M CO (Minnesota Mining & Manufacturing Co prior to 02/2002)" "Chairman/President/CEO" 20777 2019 ".5" "US88579Y1010" "3M CO (Minnesota Mining & Manufacturing Co prior to 02/2002)" "Chairman/President/CEO" 20777 2020 "1.5" "US00287Y1091" "ABBVIE INC" "Chairman/CEO" 1921326 2016 "3.9" "US00287Y1091" "ABBVIE INC" "Chairman/CEO" 1921326 2017 "4.9" "US00287Y1091" "ABBVIE INC" "Chairman/CEO" 1921326 2018 "5.9" "US00287Y1091" "ABBVIE INC" "Chairman/CEO" 1921326 2019 "6.9" "US00287Y1091" "ABBVIE INC" "Chairman/CEO" 1921326 2020 "7.9" "US00430H1023" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)" "President/CEO" 569 2016 "4.3" "US00430H1023" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)" "President/CEO" 569 2017 "5.3" "US00430H1023" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)" "President/CEO" 569 2018 "6.3" "US00430H1023" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)" "President/CEO" 569 2019 "7.3" "US00430H1023" "ACCELERATE DIAGNOSTICS INC (Accelr8 Technology Corp prior to 12/2012)" "President/CEO" 569 2020 ".8" "US00081T1088" "ACCO BRANDS CORP" "Chairman/President/CEO" 665743 2016 ".6" "US00081T1088" "ACCO BRANDS CORP" "Chairman/President/CEO" 665743 2017 "1.6" "US00081T1088" "ACCO BRANDS CORP" "Chairman/President/CEO" 665743 2018 "2.6" "US00081T1088" "ACCO BRANDS CORP" "Chairman/President/CEO" 665743 2019 "3.6" "US00081T1088" "ACCO BRANDS CORP" "Chairman/President/CEO" 665743 2020 "4.6" "US00461U1051" "ACLARIS THERAPEUTICS INC" "President/CEO" 2351879 2016 "1.2" "US00461U1051" "ACLARIS THERAPEUTICS INC" "President/CEO" 2351879 2017 "2.2" "US00461U1051" "ACLARIS THERAPEUTICS INC" "President/CEO" 2351879 2018 "3.2" "US00461U1051" "ACLARIS THERAPEUTICS INC" "President/CEO" 2351879 2019 "4.2" "US00461U1051" "ACLARIS THERAPEUTICS INC" "President/CEO" 2351879 2020 "5.2" "US00484M6012" "ACORDA THERAPEUTICS INC" "President/CEO" 247122 2016 "10.8" "US00484M6012" "ACORDA THERAPEUTICS INC" "President/CEO" 247122 2017 "11.8" "US00484M6012" "ACORDA THERAPEUTICS INC" "President/CEO" 247122 2018 "12.8" "US00484M6012" "ACORDA THERAPEUTICS INC" "President/CEO" 247122 2019 "13.8" "US00484M6012" "ACORDA THERAPEUTICS INC" "President/CEO" 247122 2020 "14.8" "US00507V1098" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)" "President/CEO" 725 2016 "8.4" "US00507V1098" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)" "CEO" 725 2017 ".5" "US00507V1098" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)" "CEO" 725 2018 "1.5" "US00507V1098" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)" "CEO" 725 2019 "2.5" "US00507V1098" "ACTIVISION BLIZZARD INC (Activision Inc prior to 07/2008)" "CEO" 725 2020 "3.5" "US00508Y1029" "ACUITY BRANDS INC" "Chairman/President/CEO" 733 2016 "11.1" "US00508Y1029" "ACUITY BRANDS INC" "Chairman/President/CEO" 733 2017 "12.1" "US00508Y1029" "ACUITY BRANDS INC" "Chairman/President/CEO" 733 2018 "13.1" "US00508Y1029" "ACUITY BRANDS INC" "Chairman/President/CEO" 733 2019 "14.1" "US00508Y1029" "ACUITY BRANDS INC" "President/CEO" 733 2020 ".6" "US00738A1060" "ADTRAN INC" "Chairman/CEO" 829 2016 "9.7" "US00738A1060" "ADTRAN INC" "Chairman/CEO" 829 2017 "10.7" "US00738A1060" "ADTRAN INC" "Chairman/CEO" 829 2018 "11.7" "US00738A1060" "ADTRAN INC" "Chairman/CEO" 829 2019 "12.7" "US00738A1060" "ADTRAN INC" "Chairman/CEO" 829 2020 "13.7" "US00773T1016" "ADVANSIX INC" "President/CEO" 2536336 2016 ".2" "US00773T1016" "ADVANSIX INC" "President/CEO" 2536336 2017 "1.2" "US00773T1016" "ADVANSIX INC" "President/CEO" 2536336 2018 "2.2" "US00773T1016" "ADVANSIX INC" "President/CEO" 2536336 2019 "3.2" "US00773T1016" "ADVANSIX INC" "President/CEO" 2536336 2020 "4.2" "US00771V1089" "AERIE PHARMACEUTICALS INC" "Chairman/CEO" 2000812 2016 "3.2" "US00771V1089" "AERIE PHARMACEUTICALS INC" "Chairman/CEO" 2000812 2017 "4.2" "US00771V1089" "AERIE PHARMACEUTICALS INC" "Chairman/CEO" 2000812 2018 "5.2" "US00771V1089" "AERIE PHARMACEUTICALS INC" "Chairman/CEO" 2000812 2019 "6.2" "US00771V1089" "AERIE PHARMACEUTICALS INC" "Chairman/CEO" 2000812 2020 "7.2" "US00847X1046" "AGIOS PHARMACEUTICALS INC" "President/CEO" 1967527 2016 "3.4" "US00847X1046" "AGIOS PHARMACEUTICALS INC" "President/CEO" 1967527 2017 "4.4" "US00847X1046" "AGIOS PHARMACEUTICALS INC" "President/CEO" 1967527 2018 "5.4" "US00847X1046" "AGIOS PHARMACEUTICALS INC" "CEO" 1967527 2019 ".8" "US00847X1046" "AGIOS PHARMACEUTICALS INC" "CEO" 1967527 2020 "1.8" "US00972D1054" "AKEBIA THERAPEUTICS INC" "President/CEO" 2055831 2016 "2.8" "US00972D1054" "AKEBIA THERAPEUTICS INC" "President/CEO" 2055831 2017 "3.8" "US00972D1054" "AKEBIA THERAPEUTICS INC" "President/CEO" 2055831 2018 "4.8" "US00972D1054" "AKEBIA THERAPEUTICS INC" "President/CEO" 2055831 2019 "5.8" "US00972D1054" "AKEBIA THERAPEUTICS INC" "President/CEO" 2055831 2020 "6.8" "US98973P1012" "ALAUNOS THERAPEUTICS INC (Ziopharm Oncology Inc prior to 01/2022)" "CEO" 735327 2018 "0" "US98973P1012" "ALAUNOS THERAPEUTICS INC (Ziopharm Oncology Inc prior to 01/2022)" "CEO" 735327 2019 "1" "US98973P1012" "ALAUNOS THERAPEUTICS INC (Ziopharm Oncology Inc prior to 01/2022)" "CEO" 735327 2020 "2" "US01973R1014" "ALLISON TRANSMISSION HOLDINGS INC" "Chairman/CEO" 1806302 2016 ".9" "US01973R1014" "ALLISON TRANSMISSION HOLDINGS INC" "Chairman/CEO" 1806302 2017 "1.9" "US01973R1014" "ALLISON TRANSMISSION HOLDINGS INC" "President/CEO" 1806302 2018 ".5" "US01973R1014" "ALLISON TRANSMISSION HOLDINGS INC" "President/CEO" 1806302 2019 "1.5" "US01973R1014" "ALLISON TRANSMISSION HOLDINGS INC" "President/CEO" 1806302 2020 "2.5" "US01988P1084" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" "CEO" 1532 2016 "1.2" "US01988P1084" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" "CEO" 1532 2017 "2.2" "US01988P1084" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" "CEO" 1532 2018 "3.2" "US01988P1084" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" "CEO" 1532 2019 "4.2" "US01988P1084" "ALLSCRIPTS HEALTHCARE SOLUTIONS INC (Allscripts-Misys Healthcare Solutions Inc prior to 08/2010)" "CEO" 1532 2020 "5.2" "US02043Q1076" "ALNYLAM PHARMACEUTICALS INC" "CEO" 117536 2016 "9" "US02043Q1076" "ALNYLAM PHARMACEUTICALS INC" "CEO" 117536 2017 "10" "US02043Q1076" "ALNYLAM PHARMACEUTICALS INC" "CEO" 117536 2018 "11" "US02043Q1076" "ALNYLAM PHARMACEUTICALS INC" "CEO" 117536 2019 "12" "US02043Q1076" "ALNYLAM PHARMACEUTICALS INC" "CEO" 117536 2020 "13" "US02156B1035" "ALTERYX INC" "Chairman/CEO" 2638015 2017 ".8" "US02156B1035" "ALTERYX INC" "Chairman/CEO" 2638015 2018 "1.8" "US02156B1035" "ALTERYX INC" "Chairman/CEO" 2638015 2019 "2.8" "US02156B1035" "ALTERYX INC" "CEO" 2638015 2020 ".2" "US02208R1068" "ALTRA INDUSTRIAL MOTION CORP (Altra Holdings Inc prior to 11/2013)" "Chairman/President/CEO" 930959 2016 "2.7" "US02208R1068" "ALTRA INDUSTRIAL MOTION CORP (Altra Holdings Inc prior to 11/2013)" "Chairman/President/CEO" 930959 2017 "3.7" "US02208R1068" "ALTRA INDUSTRIAL MOTION CORP (Altra Holdings Inc prior to 11/2013)" "Chairman/President/CEO" 930959 2018 "4.7" end
Thanks in advance!
Comment