Hi dear,
I have this dataset in a long format, I want to obtain it in a wide format.
I run this command:
But I obtain the following error:
values of variable year_ not unique within CompanyName
Can you help me?
I have this dataset in a long format, I want to obtain it in a wide format.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str110 CompanyName str1510 isin int year_ float TotalDirectorsontheBoard double TotalassetsthUSD "1ST SOURCE CORP" "US3369011032" 2008 12 4464320 "1ST SOURCE CORP" "US3369011032" 2009 12 4542100 "1ST SOURCE CORP" "US3369011032" 2010 12 4446140 "1ST SOURCE CORP" "US3369011032" 2011 13 4375420 "1ST SOURCE CORP" "US3369011032" 2012 12 4551990 "1ST SOURCE CORP" "US3369011032" 2013 13 4723440 "1ST SOURCE CORP" "US3369011032" 2014 13 4830330 "1ST SOURCE CORP" "US3369011032" 2015 11 5188070 "1ST SOURCE CORP" "US3369011032" 2016 11 5487310 "1ST SOURCE CORP" "US3369011032" 2017 11 5888980 "1ST SOURCE CORP" "US3369011032" 2018 11 6293750 "ABN AMRO BANK NV (ABN Amro Group NV prior to 07/2019)" "NL0011540547" 2015 13 443506959 "ABN AMRO BANK NV (ABN Amro Group NV prior to 07/2019)" "NL0011540547" 2016 14 415823303 "ABN AMRO BANK NV (ABN Amro Group NV prior to 07/2019)" "NL0011540547" 2017 11 471529813 "ABN AMRO BANK NV (ABN Amro Group NV prior to 07/2019)" "NL0011540547" 2018 11 436582995 "ACNB CORP" "US0008681092" 2010 12 968667 "ACNB CORP" "US0008681092" 2011 12 1004820 "ACNB CORP" "US0008681092" 2012 14 1050000 "ACNB CORP" "US0008681092" 2013 13 1046050 "ACNB CORP" "US0008681092" 2014 13 1089810 "ACNB CORP" "US0008681092" 2015 13 1147930 "ACNB CORP" "US0008681092" 2016 13 1206320 "ACNB CORP" "US0008681092" 2017 15 1595430 "ACNB CORP" "US0008681092" 2018 15 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2008 16 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2009 12 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2010 10 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2011 10 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2012 12 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2013 11 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2014 10 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2015 10 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2016 12 0 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2017 12 108011318 "AIB GROUP PLC (Allied Irish Banks PLC prior to 12/2017)" "IE00BF0L3536" 2018 11 104808773 "AKTIA BANK PLC" "FI4000058870" 2013 7 15078811 "AKTIA BANK PLC" "FI4000058870" 2014 7 12998996 "AKTIA BANK PLC" "FI4000058870" 2015 7 10758035 "AKTIA BANK PLC" "FI4000058870" 2016 9 9999165 "AKTIA BANK PLC" "FI4000058870" 2017 8 11453311 "AKTIA BANK PLC" "FI4000058870" 2018 7 10610521 "ALIOR BANK SA" "PLALIOR00045" 2013 12 8482693 "ALIOR BANK SA" "PLALIOR00045" 2014 12 8601610 "ALIOR BANK SA" "PLALIOR00045" 2015 15 10254290 "ALIOR BANK SA" "PLALIOR00045" 2016 15 14634147 "ALIOR BANK SA" "PLALIOR00045" 2017 15 19968398 "ALIOR BANK SA" "PLALIOR00045" 2018 16 19528123 "ALLEGIANCE BANCSHARES INC" "US01748H1077" 2015 15 2084820 "ALLEGIANCE BANCSHARES INC" "US01748H1077" 2016 15 2455240 "ALLEGIANCE BANCSHARES INC" "US01748H1077" 2017 16 2861920 "ALLEGIANCE BANCSHARES INC" "US01748H1077" 2018 18 4655650 "ALPHA BANK A E" "GRS015003007" 2008 16 90836150 "ALPHA BANK A E" "GRS015003007" 2009 16 100260093 "ALPHA BANK A E" "GRS015003007" 2010 15 89302564 "ALPHA BANK A E" "GRS015003007" 2011 14 76531649 "ALPHA BANK A E" "GRS015003007" 2012 15 76859557 "ALPHA BANK A E" "GRS015003007" 2013 15 101635898 "ALPHA BANK A E" "GRS015003007" 2014 15 88550987 "ALPHA BANK A E" "GRS015003007" 2015 15 75444230 "ALPHA BANK A E" "GRS015003007" 2016 13 68381827 "ALPHA BANK A E" "GRS015003007" 2017 12 72926752 "ALPHA BANK A E" "GRS015003007" 2018 13 69852752 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2008 13 789184 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2009 13 808973 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2010 12 833664 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2011 14 1304710 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2012 15 1283690 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2013 15 1307510 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2014 13 1346490 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2015 14 1547600 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2016 14 1678640 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2017 14 1816080 "AMERICAN NATIONAL BANKSHARES INC" "US0277451086" 2018 14 1862870 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2008 8 2407090 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2009 7 2423970 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2010 8 2975210 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2011 8 3007570 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2012 7 3019050 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2013 9 3672320 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2014 10 4043310 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2015 8 5597180 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2016 9 6892030 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2017 9 7856200 "AMERIS BANCORP (ABC Bancorp prior to 12/2005)" "US03076K1088" 2018 9 11443500 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2008 17 966929 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2009 17 970026 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2010 16 948974 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2011 16 976356 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2012 16 1000990 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2013 15 1056040 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2014 13 1089260 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2015 13 1148920 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2016 13 1153780 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2017 12 1167660 "AMERISERV FINANCIAL INC (USBancorp Inc prior to 05/2001)" "US03074A1025" 2018 11 0 "AMES NATIONAL CORP" "US0310011004" 2008 12 858146 "AMES NATIONAL CORP" "US0310011004" 2009 12 915570 "AMES NATIONAL CORP" "US0310011004" 2010 11 962975 "AMES NATIONAL CORP" "US0310011004" 2011 11 1035560 "AMES NATIONAL CORP" "US0310011004" 2012 11 1217690 end
reshape wide varlist, i(companyname isin) j(year_)
values of variable year_ not unique within CompanyName
Can you help me?
Comment