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
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
Comment