Code:
+-----------------------------------------------------------------------------------------------------------------------------------------------+ | year country indicator exchange region value eu_28 | |-----------------------------------------------------------------------------------------------------------------------------------------------| 1. | 2015 Greece Total Equity Market - Number of new listings through IPO (Total) Athens Stock Exchange Western Europe 0 1 | 2. | 2015 Greece Total Equity Market - Number of new listings (Domestic Total) Athens Stock Exchange Western Europe 0 1 | 3. | 2015 Greece Total Equity Market - Number of listed companies (Total) Athens Stock Exchange Western Europe 240 1 | 4. | 2016 Greece Total Equity Market - Number of new listings through IPO (Domestic) Athens Stock Exchange Western Europe 1 1 | 5. | 2016 Greece Total Equity Market - Number of new listings (Foreign Total) Athens Stock Exchange Western Europe 1 1 | +-----------------------------------------------------------------------------------------------------------------------------------------------+
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long year str33 country str67 indicator str38 exchange str14 region double value float eu_28 2015 "Greece" "Total Equity Market - Number of new listings through IPO (Total)" "Athens Stock Exchange" "Western Europe" 0 1 2015 "Greece" "Total Equity Market - Number of new listings (Domestic Total)" "Athens Stock Exchange" "Western Europe" 0 1 2015 "Greece" "Total Equity Market - Number of listed companies (Total)" "Athens Stock Exchange" "Western Europe" 240 1 2016 "Greece" "Total Equity Market - Number of new listings through IPO (Domestic)" "Athens Stock Exchange" "Western Europe" 1 1 2016 "Greece" "Total Equity Market - Number of new listings (Foreign Total)" "Athens Stock Exchange" "Western Europe" 1 1 2016 "Greece" "Total Equity Market - Number of listed companies (Total)" "Athens Stock Exchange" "Western Europe" 218 1 2016 "Greece" "Total Equity Market - Number of new listings (Total)" "Athens Stock Exchange" "Western Europe" 2 1 2016 "Greece" "Total Equity Market - Number of new listings (Domestic Total)" "Athens Stock Exchange" "Western Europe" 1 1 2015 "Greece" "Total Equity Market - Number of new listings through IPO (Foreign)" "Athens Stock Exchange" "Western Europe" 0 1 2016 "Greece" "Total Equity Market - Market Capitalisation" "Athens Stock Exchange" "Western Europe" 37206.16 1 2015 "Greece" "Total Equity Market - Number of listed companies (Foreign)" "Athens Stock Exchange" "Western Europe" 4 1 2015 "Greece" "Total Equity Market - Number of delistings (Total)" "Athens Stock Exchange" "Western Europe" 4 1 2015 "Greece" "Total Equity Market - Number of listed companies (Domestic)" "Athens Stock Exchange" "Western Europe" 236 1 2016 "Greece" "Total Equity Market - Number of new listings through IPO (Total)" "Athens Stock Exchange" "Western Europe" 2 1 2015 "Greece" "Total Equity Market - Number of new listings through IPO (Domestic)" "Athens Stock Exchange" "Western Europe" 0 1 2015 "Greece" "Total Equity Market - Market Capitalisation" "Athens Stock Exchange" "Western Europe" 42079.58 1 2015 "Greece" "Total Equity Market - Number of delistings (Foreign)" "Athens Stock Exchange" "Western Europe" 0 1 2015 "Greece" "Total Equity Market - Number of new listings (Total)" "Athens Stock Exchange" "Western Europe" 0 1 2016 "Greece" "Total Equity Market - Number of new listings through IPO (Foreign)" "Athens Stock Exchange" "Western Europe" 1 1 2015 "Greece" "Total Equity Market - Number of new listings (Foreign Total)" "Athens Stock Exchange" "Western Europe" 0 1 2016 "Greece" "Total Equity Market - Number of listed companies (Foreign)" "Athens Stock Exchange" "Western Europe" 5 1 2015 "Greece" "Total Equity Market - Number of delistings (Domestic)" "Athens Stock Exchange" "Western Europe" 4 1 2016 "Greece" "Total Equity Market - Number of listed companies (Domestic)" "Athens Stock Exchange" "Western Europe" 213 1 2015 "Russia" "Total Equity Market - Number of delistings (Foreign)" "Moscow Exchange" "Eastern Europe" 1 0 2015 "Russia" "Total Equity Market - Number of delistings (Total)" "Moscow Exchange" "Eastern Europe" 16 0 2015 "Russia" "Total Equity Market - Number of new listings through IPO (Domestic)" "Moscow Exchange" "Eastern Europe" 4 0 2016 "Russia" "Total Equity Market - Number of listed companies (Foreign)" "Moscow Exchange" "Eastern Europe" 3 0 2015 "Russia" "Total Equity Market - Number of listed companies (Domestic)" "Moscow Exchange" "Eastern Europe" 251 0 2015 "Russia" "Total Equity Market - Number of delistings (Domestic)" "Moscow Exchange" "Eastern Europe" 15 0 2016 "Russia" "Total Equity Market - Number of new listings (Foreign Total)" "Moscow Exchange" "Eastern Europe" 0 0 2016 "Russia" "Total Equity Market - Number of new listings (Total)" "Moscow Exchange" "Eastern Europe" 4 0 2015 "Russia" "Total Equity Market - Market Capitalisation" "Moscow Exchange" "Eastern Europe" 393237.76 0 2016 "Russia" "Total Equity Market - Number of listed companies (Domestic)" "Moscow Exchange" "Eastern Europe" 242 0 2016 "Russia" "Total Equity Market - Number of new listings through IPO (Domestic)" "Moscow Exchange" "Eastern Europe" 3 0 2015 "Russia" "Total Equity Market - Number of new listings through IPO (Total)" "Moscow Exchange" "Eastern Europe" 4 0 2015 "Russia" "Total Equity Market - Number of listed companies (Foreign)" "Moscow Exchange" "Eastern Europe" 3 0 2016 "Russia" "Total Equity Market - Market Capitalisation" "Moscow Exchange" "Eastern Europe" 622051.53 0 2016 "Russia" "Total Equity Market - Number of new listings through IPO (Foreign)" "Moscow Exchange" "Eastern Europe" 0 0 2015 "Russia" "Total Equity Market - Number of new listings (Domestic Total)" "Moscow Exchange" "Eastern Europe" 4 0 2016 "Russia" "Total Equity Market - Number of new listings (Domestic Total)" "Moscow Exchange" "Eastern Europe" 4 0 2015 "Russia" "Total Equity Market - Number of listed companies (Total)" "Moscow Exchange" "Eastern Europe" 254 0 2016 "Russia" "Total Equity Market - Number of new listings through IPO (Total)" "Moscow Exchange" "Eastern Europe" 3 0 2016 "Russia" "Total Equity Market - Number of listed companies (Total)" "Moscow Exchange" "Eastern Europe" 245 0 2015 "Russia" "Total Equity Market - Number of new listings (Total)" "Moscow Exchange" "Eastern Europe" 4 0 end
0 Response to Reshape wide -- categories as variables
Post a Comment