Announcement

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

  • How to graph time series without transposing a column vector of time?

    I ran worldstat to collect GDPs across a time series and cross-section and wondering if its possible to graph the following graph manually without having to arrange the time down a single column vector. As they're arranged now it's a row of time, and column of countries.

    Essentially is it possible to create the same graph below with the following data input

    Code:
     * Example generated by -dataex-. To install: ssc install dataex
      clear
      input str52 country str3 countrycode str2 iso2code str46 region str3 regioncode str14(indicatorname indicatorcode) float(yr1960 yr1961 yr1962 yr1963 yr1964 yr1965 yr1966 yr1967 yr1968 yr1969)
      "Afghanistan"                                   "AFG" "AF" "South Asia"                                     "SAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Albania"                                       "ALB" "AL" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Algeria"                                       "DZA" "DZ" "Middle East & North Africa (all income levels)" "MEA" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  2466.038  2078.222 1628.3887 2133.3186  2200.814  2276.147 2107.8003 2242.4504 2414.0166  2543.563
      "American Samoa"                                "ASM" "AS" "East Asia & Pacific (all income levels)"        "EAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Andorra"                                       "AND" "AD" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Angola"                                        "AGO" "AO" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Antigua and Barbuda"                           "ATG" "AG" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Arab World"                                    "ARB" "1A" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Argentina"                                     "ARG" "AR" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  5605.192  5815.233   5675.06  5290.766  5738.598  6251.322  6120.712  6226.998  6434.954  6954.764
      "Armenia"                                       "ARM" "AM" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Aruba"                                         "ABW" "AW" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Australia"                                     "AUS" "AU" "East Asia & Pacific (all income levels)"        "EAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 19387.318 19477.773  19254.58 20062.637 21045.684  21872.08   21887.7 22975.295 23723.846  24868.99
      "Austria"                                       "AUT" "AT" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  13031.03 13677.464  13953.95 14438.356  15220.82 15648.526 16416.006  16783.89 17443.705  18474.54
      "Azerbaijan"                                    "AZE" "AZ" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Bahamas, The"                                  "BHS" "BS" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  17735.54 18675.943 19610.035  20609.97 21690.115 22864.465 23863.236  25083.75  26164.47 27538.635
      "Bahrain"                                       "BHR" "BH" "Middle East & North Africa (all income levels)" "MEA" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Bangladesh"                                    "BGD" "BD" "South Asia"                                     "SAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  370.5942  382.0048  391.4892    378.56  407.6331  401.5334  398.7082  378.4483 401.18045  394.3096
      "Barbados"                                      "BRB" "BB" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Belarus"                                       "BLR" "BY" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Belgium"                                       "BEL" "BE" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 13193.314   13804.2 14465.978 14983.043 15874.404  16291.02 16692.018 17241.447 17894.043  19026.43
      "Belize"                                        "BLZ" "BZ" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1072.4663 1093.5869 1115.5126 1138.3073 1161.5339 1183.7738 1203.6367 1225.2904 1277.3724 1306.5754
      "Benin"                                         "BEN" "BJ" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  520.4042 529.29736  503.5991  519.1307 544.42773  563.1464 572.45325  567.3836  577.3055 581.61035
      "Bermuda"                                       "BMU" "BM" "North America"                                  "NAC" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  27838.39 28436.717  29006.58  28640.88  31041.95 31740.635  35659.16  39616.14  39686.96  40290.57
      "Bhutan"                                        "BTN" "BT" "South Asia"                                     "SAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Bolivia"                                       "BOL" "BO" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1304.6987 1306.5906 1353.0332  1412.202  1451.186 1502.7914 1568.7994  1643.755 1414.6986 1428.9135
      "Bosnia and Herzegovina"                        "BIH" "BA" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Botswana"                                      "BWA" "BW" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  390.8297  405.7986   422.172  435.6899   453.079  466.2622  481.7859  495.3853  531.2139  592.6714
      "Brazil"                                        "BRA" "BR" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"   3425.43  3668.488   3747.86   3671.29  3690.915  3697.506  3745.996  3825.238   4151.01  4438.589
      "British Virgin Islands"                        "VGB" ""   ""                                               ""    "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Brunei Darussalam"                             "BRN" "BN" "East Asia & Pacific (all income levels)"        "EAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Bulgaria"                                      "BGR" "BG" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Burkina Faso"                                  "BFA" "BF" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 238.85457  245.1986 256.77716 250.11786 252.26183 257.91507 255.28152 273.30023  276.9742 277.77408
      "Burundi"                                       "BDI" "BI" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 214.13695  181.2177 193.95325 198.12222 206.28943  209.8035 214.27113  237.7556 231.17093  222.7248
      "Cabo Verde"                                    "CPV" "CV" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Cambodia"                                      "KHM" "KH" "East Asia & Pacific (all income levels)"        "EAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Cameroon"                                      "CMR" "CM" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  956.4561  947.8253  955.9104  970.0551  982.0522  979.1423 1000.5547  870.2732  903.1805  924.1844
      "Canada"                                        "CAN" "CA" "North America"                                  "NAC" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 17664.205 17861.936 18780.564 19389.156  20301.66  21260.63  22242.42  22482.65   23294.3 24188.426
      "Caribbean small states"                        "CSS" "S3" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .  4916.278  5020.046  5244.685  5460.586
      "Cayman Islands"                                "CYM" "KY" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Central African Republic"                      "CAF" "CF" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 601.85284  621.0424  587.4396  572.5818 573.37384  567.4624 559.56506 573.56036 569.44006  597.2747
      "Central Europe and the Baltics"                "CEB" ""   ""                                               ""    "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Chad"                                          "TCD" "TD" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  696.2769   692.453  715.3433  690.1191  659.7443  651.0954  627.4617  620.7448 606.51013  635.7068
      "Channel Islands"                               "CHI" "JG" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Chile"                                         "CHL" "CL" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  3806.806  3918.367  3986.723  4127.319 4140.7725  4089.777 4451.6445 4514.6006  4579.301  4663.498
      "China"                                         "CHN" "CN" "East Asia & Pacific (all income levels)"        "EAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  191.7912  140.9135 131.96338 142.02196  163.9913 187.27463 201.52324 185.07593 172.91376 196.74013
      "Colombia"                                      "COL" "CO" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  2213.223 2260.8987   2313.93 2310.7024 2390.5627 2390.2544  2443.787 2472.2476  2556.427  2648.892
      "Comoros"                                       "COM" "KM" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Congo, Dem. Rep."                              "COD" "CD" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1038.9325  903.1258 1067.0593 1094.0065  1039.403 1021.6085 1060.7811 1020.8159 1034.9183 1099.7336
      "Congo, Rep."                                   "COG" "CG" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  1429.998  1510.258  1547.835  1446.478 1461.7124 1474.6273  1454.059 1444.1283 1511.0997 1579.0146
      "Costa Rica"                                    "CRI" "CR" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  2856.531  2729.158 2847.1475  2879.023  2895.997  3075.456  3211.325  3287.617   3456.89  3545.303
      "Cote d'Ivoire"                                 "CIV" "CI" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1205.2606 1276.4766  1242.733 1367.3236 1545.8733 1441.0248 1548.5865 1560.9515 1692.1636 1782.1774
      "Croatia"                                       "HRV" "HR" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Cuba"                                          "CUB" "CU" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Curacao"                                       "CUW" "CW" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Cyprus"                                        "CYP" "CY" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Czech Republic"                                "CZE" "CZ" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Denmark"                                       "DNK" "DK" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"   21075.6     22264 23343.234  23307.61 25265.477 26211.336 26714.385  27411.47  28328.07  29953.01
      "Djibouti"                                      "DJI" "DJ" "Middle East & North Africa (all income levels)" "MEA" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Dominica"                                      "DMA" "DM" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Dominican Republic"                            "DOM" "DO" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1326.9053  1253.493  1419.272  1462.816 1512.1818 1282.1533 1410.2634 1413.4816  1375.214  1481.075
      "Early-demographic dividend"                    "EAR" ""   ""                                               ""    "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1123.4879 1145.2408  1166.439 1199.8275 1268.3003   1306.03 1325.8983 1364.2156 1426.3862  1479.486
      "East Asia & Pacific"                           "EAS" "Z4" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1283.9087 1354.8486 1419.8956  1494.786 1615.6713 1682.2196 1786.5072 1892.4014  2039.532 2217.2512
      "East Asia & Pacific (IDA & IBRD countries)"    "TEA" ""   ""                                               ""    "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 291.92044  259.3475  255.6228  263.5559  282.5948 302.89716  316.9051  305.8585 305.86615  329.5966
      "East Asia & Pacific (excluding high income)"   "EAP" "4E" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 288.76514 256.47244  252.7746 260.65067  279.5033 299.59677  313.4632  302.5313   302.529   325.993
      "Ecuador"                                       "ECU" "EC" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 2244.4463 2215.0918  2250.614 2271.3713 2378.8252 2419.5771 2341.9673 2379.5952 2355.2764 2394.6587
      "Egypt, Arab Rep."                              "EGY" "EG" "Middle East & North Africa (all income levels)" "MEA" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  631.1284  641.1322  666.7919  707.9253   745.458  763.3497  751.4195  736.6841  737.6144  768.5328
      "El Salvador"                                   "SLV" "SV" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         . 2370.2942  2468.592  2531.045   2542.31  2560.989
      "Equatorial Guinea"                             "GNQ" "GQ" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Eritrea"                                       "ERI" "ER" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Estonia"                                       "EST" "EE" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Eswatini"                                      "SWZ" "SZ" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Ethiopia"                                      "ETH" "ET" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Euro area"                                     "EMU" "XC" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  10808.76  11426.13  12043.85 12619.378  13190.77 13722.265 14326.545  14975.29 15702.147  16683.09
      "Europe & Central Asia"                         "ECS" "Z7" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Europe & Central Asia (IDA & IBRD countries)"  "TEC" ""   ""                                               ""    "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Europe & Central Asia (excluding high income)" "ECA" "7E" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "European Union"                                "EUU" "EU" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 10056.663  10529.07 10961.922 11424.256 11955.642 12378.373 12812.497 13287.062 13866.945 14575.892
      "Faroe Islands"                                 "FRO" "FO" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Fiji"                                          "FJI" "FJ" "East Asia & Pacific (all income levels)"        "EAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1774.2057 1774.5006 1775.6012 1825.1646 1853.6617 1751.3795 1705.6356 1887.4474  1992.037 2000.5863
      "Finland"                                       "FIN" "FI" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 12195.328  13030.46 13328.082 13668.944 14305.213 15013.663 15312.412 15560.018 15847.102 17377.441
      "Fragile and conflict affected situations"      "FCS" ""   ""                                               ""    "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "France"                                        "FRA" "FR" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 12991.268  13524.45 14224.482  14775.06 15532.635 16087.923 16764.232 17409.967  18023.81 19148.508
      "French Polynesia"                              "PYF" "PF" "East Asia & Pacific (all income levels)"        "EAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Gabon"                                         "GAB" "GA" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  4377.439  4974.194  5285.614   5537.48  5706.516  6080.803  6237.257  6361.829  6382.564  6752.462
      "Gambia, The"                                   "GMB" "GM" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .  422.3536  414.0768  443.9501 444.02695
      "Georgia"                                       "GEO" "GE" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         . 1785.3425  1898.051 1996.9946 2067.1519 2145.7522
      "Germany"                                       "DEU" "DE" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Ghana"                                         "GHA" "GH" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1053.2803 1055.4124  1064.831 1078.5676 1071.6051 1058.4851  990.2381  999.6059  983.3303 1020.5027
      "Gibraltar"                                     "GIB" ""   ""                                               ""    "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Greece"                                        "GRC" "GR" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  6779.887  7476.297  7545.857  8279.942  8931.284  9724.572 10241.815 10715.588 11355.574 12434.226
      "Greenland"                                     "GRL" "GL" "Europe & Central Asia (all income levels)"      "ECS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Grenada"                                       "GRD" "GD" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Guam"                                          "GUM" "GU" "East Asia & Pacific (all income levels)"        "EAS" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Guatemala"                                     "GTM" "GT" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD" 1461.7634  1480.508  1488.879 1584.3496  1610.433  1632.643 1673.3474  1692.379 1788.4027 1820.3748
      "Guinea"                                        "GIN" "GN" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Guinea-Bissau"                                 "GNB" "GW" "Sub-Saharan Africa (all income levels)"         "SSF" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Guyana"                                        "GUY" "GY" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  1679.525 1706.2043 1676.6554 1432.3008 1556.8296 1683.9144 1738.2974 1782.8302 1774.1298   1872.03
      "Haiti"                                         "HTI" "HT" "Latin America & Caribbean (all income levels)"  "LCN" "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"         .         .         .         .         .         .         .         .         .         .
      "Heavily indebted poor countries (HIPC)"        "HPC" "XE" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  621.7896  608.7823   636.112  641.2286  647.8499  658.6221  659.8832   657.868  660.2859  673.2508
      "High income"                                   "HIC" "XD" "Aggregates"                                     "NA"  "NY.GDP.PCAP.KD" "NY.GDP.PCAP.KD"  11569.44  11943.11 12470.157 12946.732 13621.938 14218.687 14905.385 15423.444  16216.28  16981.73
      end
    Click image for larger version

Name:	2018-10-14_20-06-05.png
Views:	1
Size:	473.9 KB
ID:	1465913


  • #2
    It is usually best to work with this kind of data in long format. This is easy in long format, but not so easy in wide.

    Comment

    Working...
    X