help with Synthetic control

[anthony carmichael]

hello everyone.
Ive compiled data on a large amount of countries to perform synthetic control.
yesterday i was running synthetic control on life expectancy with my control variables being GDP GNI population and unemployment. This was working. then I wanted to perform synthetic control on homicides with the same controls as this is what i was mainly interested in. Since there were gaps in my homicide data the code wouldn't run. So today i collected a bunch of homicide data with countries that had no gaps. yet when i run my synth command shown below
synth homicide GDP GNI Population Unemployement, trunit (32) trperiod(2016) xperiod(2005(1)2015) nested fig

i get

First Step: Data Setup
-------------------------------------------------------------------------------------------
St: operator invalid
r(198);

and the code doesnt run.
attached below are the two excel sheets. The first one will run synthetic control on life expectancy the new synthetic control sheet is the one that is giving me the operator invalid.
i can load both data sets in stata and am able to get them balanced by typing tsset Country Year
any help would be very much appreciated.

[anthony carmichael]

here are the excel sheets

[Jared Greathouse]

Hi, I'm one of the main contributors on here who knows about SCM. And I will help you... but before we do anything, I need you to post the results of

dataex, count(500)

post your dataset exactly as dataex gives it to you. Do this for BOTH excel sheets. If you can do this, I will help you!

[anthony carmichael]

Thanks so much!!! here is the data set that is giving me the error.

* Example generated by -dataex-. For more info, type help dataex
clear
input int Year double(homicide GDP) long(GNI Population) double Unemployment long Country1
2000   4.19  6.95  1100    3089027 19.03  1
2001   7.03  8.29  1280    3060173 18.57  1
2002   6.91  4.54  1370    3051010 17.89  1
2003   5.32  5.53  1650    3039616 16.99  1
2004   4.22  5.52  2100    3026939 16.31  1
2005   4.99  5.53  2620    3011487 15.97  1
2006    3.1   5.9  3050    2992547 15.63  1
2007   3.46  5.98  3460    2970017 15.97  1
2008    3.1   7.5  4040    2947314 13.06  1
2009   2.86  3.35  4280    2927519 13.67  1
2010   4.31  3.71  4360    2913021 14.09  1
2011   4.85  2.55  4410    2905195 13.48  1
2012   5.39  1.42  4360    2900401 13.38  1
2013   4.27     1  4540    2895092 15.87  1
2014   4.04  1.78  4540    2889104 18.05  1
2015   2.21  2.22  4390    2880703 17.19  1
2016   2.74  3.32  4320    2876101 15.42  1
2017   2.01   3.8  4290    2873457 13.62  1
2018   2.29  4.02  4860    2866376  12.3  1
2019   2.26  2.09  5230    2854191 11.47  1
2000   2.97   5.9   640    3168523 11.05  2
2001   2.89   9.6   690    3133133 10.91  2
2002   2.27  13.2   780    3105037 10.78  2
2003   2.52    14   940    3084102 10.59  2
2004   2.77  10.5  1160    3065745 10.34  2
2005   1.95  13.9  1500    3047246  10.2  2
2006   2.67  13.2  1970    3026486    10  2
2007   2.63  13.7  2690    3004393  9.81  2
2008   3.34   6.9  3510    2983421 14.39  2
2009   3.36 -14.1  3250    2964296 18.44  2
2010   1.95   2.2  3390    2946293 19.01  2
2011   2.47   4.7  3470    2928976 18.44  2
2012   2.25   7.2  3840    2914421  17.3  2
2013   2.17   3.3  4110    2901385 16.18  2
2014   2.47   3.6  4170    2889930  17.5  2
2015   2.56   3.2  4080    2878595 18.26  2
2016   2.96    .2  3850    2865835 17.62  2
2017   2.38   7.5  4070    2851923  17.7  2
2018   1.69   5.2  4410    2836557 18.97  2
2019   2.47   7.6  4880    2820602  18.3  2
2000   1.02  3.38 21280   19028802  4.69  3
2001    .86  1.27 20310   19274701  4.01  3
2002     .8  1.65 20200   19495210  4.85  3
2003    .61   .94 21370   19720737  4.78  3
2004    .72  2.74 25830   19932722  5.83  3
2005    .65  2.24 30730   20176844  5.63  3
2006    .74  3.45 34580   20450966  5.24  3
2007    .54  3.73 37370   20827622  4.86  3
2008     .7  1.46 42380   21249199  4.13  3
2009    .61 -3.77 44080   21691653   5.3  3
2010    .69  1.84 46740   22031750  4.82  3
2011    .89  2.92 50400   22340024  4.56  3
2012    .93   .68 60270   22733465  4.87  3
2013    .73   .03 66050   23128129  5.33  3
2014    .52   .66 65180   23475686  5.62  3
2015    .53  1.02 60490   23815995  5.72  3
2016    .62  1.99 54080   24190907  6.01  3
2017    .79  2.26 51490   24594202   5.5  3
2018    .97  2.43 53100   24966643  4.85  3
2019    .86  1.52 54900   25340217  4.49  3
2000  24.83  4.15 24170     325014   7.2  4
2001  14.21  2.63 24390     329626  6.87  4
2002   16.9  2.71 25040     334002  9.05  4
2003  15.97 -1.27 25680     338490 10.84  4
2004   13.8   .88 27200     343089  10.2  4
2005  16.01   3.4 28560     347804  10.2  4
2006  18.43  2.52 28870     352664  7.54  4
2007  23.12  1.45 29330     357666  7.88  4
2008  21.24 -2.32 29270     362795  8.18  4
2009  24.89 -4.18 27530     368057 14.25  4
2010  26.48  1.54 26900     373272 14.31  4
2011  35.32   .61 26540     377950 14.52  4
2012  30.53  3.09 27200     382061 14.02  4
2013  32.41 -2.86 26280     385650 16.18  4
2014  33.46  1.85 26840     389131  13.8  4
2015  39.02     1 27450     392697    12  4
2016  29.37  -.86 27610     395976  12.7  4
2017  31.96  3.05 29260     399020   9.8  4
2018   23.6  1.83 29810     401906    10  4
2019  24.39   1.9 31210     404557 10.06  4
2000   7.37  4.45 11060     264657  9.35  5
2001   9.18 -2.37 10910     265377  9.85  5
2002   9.14   .79 10930     266455 10.32  5
2003  12.03  2.18 11590     267499    11  5
2004   7.99  1.41 12600     268505  9.57  5
2005   10.5  3.96 13580     269477  9.08  5
2006  12.61  6.11 14610     270425  8.73  5
2007   8.97  2.08 15940     271444  7.41  5
2008   8.22   .64 16600     272635  8.12  5
2009   6.76 -5.02 16160     273791 10.02  5
2010  10.99 -2.37 15960     274711 10.69  5
2011   9.54  -.69 15450     275486 11.19  5
2012   7.76  -.43 16150     276197 11.59  5
2013   8.44 -1.45 16080     276865 11.55  5
2014   8.78  -.09 16050     277493 12.17  5
2015  10.87  2.47 16170     278083   9.8  5
2016    7.7  2.53 16350     278649  8.25  5
2017  10.48   .46 16490     279187  8.62  5
2018   9.77 -1.03 17020     279688  8.32  5
2019  16.72  -.13 17630     280180  8.41  5
2000  16.58 13.01  4400     240406 10.85  6
2001  25.09  5.04  4400     248100  9.07  6
2002  33.16  5.11  4490     255987 10.04  6
2003  24.87  9.33  4760     263998 10.24  6
2004  28.57  4.63  4940     272128 10.59  6
2005  28.54   2.2  4990     280375 10.91  6
2006  31.58  4.59  5110     288729  9.39  6
2007  32.44  3.28  5150     297173  8.51  6
2008  33.57 -1.52  5120     305671  8.18  6
2009  30.83  -.45  5230     314171  8.25  6
2010     40  1.26  5000     322106  8.24  6
2011  37.55  -.11  5090     329538  8.28  6
2012   42.9  3.86  5250     337059  8.31  6
2013  28.64  4.53  5510     344688  8.35  6
2014  34.81  4.09  5610     352335  8.24  6
2015  32.97  3.37  5770     359871  7.58  6
2016  37.46   .11  5650     367313     7  6
2017  37.79  -1.7  5520     374693   6.6  6
2018  37.33   1.1  5660     382066  6.64  6
2019  34.33   4.5  5890     389095  6.71  6
2000  25.96  4.39  3910  175873720  9.56  7
2001  27.06  1.39  3330  178211881  9.61  7
2002  27.69  3.05  3080  180476685  9.37  7
2003  28.09  1.14  2980  182629278  9.99  7
2004   26.3  5.76  3340  184722043  9.11  7
2005  25.57   3.2  3980  186797334  9.57  7
2006  26.13  3.96  4830  188820682  8.64  7
2007   25.1  6.07  6170  190779453  8.33  7
2008  26.11  5.09  7590  192672317  7.34  7
2009  26.54  -.13  8300  194517549  8.52  7
2010  26.72  7.53  9610  196353492  7.27  7
2011  26.45  3.97 11050  198185302  6.92  7
2012   28.3  1.92 12270  199977707  7.19  7
2013  28.28  3.01 12750  201721767  6.98  7
2014  29.46    .5 12080  203459650  6.66  7
2015  28.46 -3.55 10160  205188205  8.43  7
2016  29.69 -3.28  8890  206859578  11.6  7
2017  30.69  1.32  8670  208504960 12.82  7
2018  26.73  1.78  9140  210166592 12.33  7
2019  20.88  1.22  9220  211782878 11.93  7
2000   4.15  4.59  1660    8170172 16.22  8
2001   3.88  3.82  1770    8009142 19.92  8
2002   3.24  5.87  1970    7837161 18.11  8
2003   3.17  5.24  2370    7775327 13.73  8
2004   3.15  6.51  3060    7716860 12.04  8
2005   2.59  7.06  3800    7658972 10.08  8
2006   2.44   6.8  4300    7601022  8.95  8
2007   2.34  6.65  4820    7545338  6.88  8
2008   2.29  6.13  6070    7492561  5.61  8
2009   2.01 -3.35  6680    7444443  6.82  8
2010   1.99  1.54  7010    7395599 10.28  8
2011   1.74   2.1  7260    7348328 11.26  8
2012   1.92   .76  7490    7305888 12.27  8
2013    1.5  -.56  7590    7265115 12.94  8
2014   1.55   .97  7700    7223938 11.42  8
2015   1.75  3.43  7430    7177991  9.14  8
2016   1.11  3.04  7400    7127822  7.57  8
2017   1.45  2.76  7610    7075947  6.16  8
2018   1.31  2.69  8530    7025037  5.21  8
2019   1.19  4.04  9500    6975761  4.23  8
2000   1.79  5.18 22750   30685730  6.83  9
2001   1.79  1.79 23110   31020902  7.22  9
2002   1.87  3.02 23580   31360079  7.66  9
2003   1.74   1.8 25480   31644028  7.57  9
2004   1.97  3.09 29530   31940655  7.19  9
2005   2.06   3.2 34310   32243753  6.76  9
2006   1.87  2.63 37900   32571174  6.32  9
2007   1.81  2.07 41550   32889025  6.04  9
2008   1.84  1.01 44940   33247118  6.14  9
2009   1.81 -2.93 43230   33628895  8.34  9
2010   1.63  3.09 44490   34004889  8.06  9
2011   1.76  3.15 47190   34339328  7.51  9
2012   1.57  1.76 51080   34714222  7.29  9
2013   1.44  2.33 52800   35082954  7.07  9
2014   1.46  2.87 52200   35437435  6.91  9
2015   1.69   .66 47590   35702908  6.91  9
2016   1.68     1 43890   36109487     7  9
2017   1.82  3.04 42900   36545236  6.34  9
2018   1.78  2.78 45080   37065084  5.83  9
2019   1.84  1.88 46540   37601230  5.66  9
2000  66.97  2.93  2360   39215135 20.52 10
2001  69.16  1.68  2350   39837875 15.04 10
2002  69.45   2.5  2400   40454050 14.48 10
2003   56.7  3.92  2400   41057687 13.22 10
2004  48.03  5.33  2640   41648268 12.74 10
2005  42.47  4.83  3030   42220940 11.06 10
2006  40.46  6.72  3540   42772910 11.29 10
2007  39.32  6.74  4170   43306582 10.25 10
2008  36.47  3.28  4760   43815313 10.49 10
2009  35.35  1.14  5190   44313917 11.29 10
2010  34.18   4.5  5680   44816108 10.98 10
2011  35.32  6.95  6370   45308899 10.11 10
2012  35.68  3.91  7340   45782417  9.74 10
2013  33.16  5.13  8000   46237930  9.05 10
2014  28.41   4.5  8260   46677947  8.57 10
2015   26.9  2.96  7400   47119728   8.3 10
2016  25.74  2.09  6530   47625955  8.69 10
2017  25.02  1.36  6010   48351671  8.87 10
2018  25.34  2.56  6320   49276961  9.11 10
2019     24  3.19  6590   50187406  9.96 10
2000   6.28  3.87  3560    3979193  5.08 11
2001   6.37  3.49  3660    4053222  5.92 11
2002   6.29  3.42  3750    4122623  6.33 11
2003   7.21  4.32  4000    4188610  6.56 11
2004   6.63  4.43  4350    4252800  6.39 11
2005   7.82  3.98  4610    4315887  6.57 11
2006   8.08  7.33  5020    4378172  5.74 11
2007   8.38  8.22  5630    4440019  4.49 11
2008  11.47  4.74  6350    4501921  4.78 11
2009  11.61  -.87  6480    4563127  7.71 11
2010  11.51  5.36  7190    4622252  7.17 11
2011  10.23   4.4  8020    4679926 10.14 11
2012   8.68  4.88  9190    4736593  9.78 11
2013   8.67   2.5  9840    4791535  8.77 11
2014   9.95  3.54 10250    4844288  9.06 11
2015  11.49  3.65 10610    4895242     9 11
2016   11.8   4.2 11000    4945205   8.6 11
2017  12.18  4.16 11400    4993842  8.14 11
2018   11.7  2.62 11880    5040734  9.63 11
2019  11.15  2.42 12040    5084532 11.49 11
2000   2.28  2.86  5250    4468302 16.06 12
2001   1.84  3.08  5340    4299642 15.82 12
2002   1.66  5.76  5660    4302174 15.05 12
2003   1.57  5.56  6730    4303399 13.92 12
2004   1.89  4.15  8600    4304600 13.66 12
2005   1.55  4.26 10260    4310145  12.6 12
2006   1.69  4.89 11410    4311159 11.13 12
2007   1.42     5 12790    4310217  9.91 12
2008   1.63     2 14400    4309705  8.53 12
2009   1.13 -7.19 14280    4305181   9.2 12
2010   1.43 -1.22 14270    4295427 11.62 12
2011   1.14  -.09 14240    4280622 13.68 12
2012   1.19 -2.33 13640    4267558 15.93 12
2013   1.08   -.4 13790    4255689 17.25 12
2014    .85  -.43 13520    4238389 17.29 12
2015    .87  2.52 13310    4203604 16.18 12
2016   1.05  3.56 12740    4174349  13.1 12
2017    1.1  3.41 13030    4124531 11.21 12
2018    .58   2.8 14440    4087843  8.43 12
2019     .8  3.42 15580    4065253  6.62 12
2000    .85  5.97 14180     948237  4.97 13
2001    .73  3.95 14170     964830  3.98 13
2002    .21  3.72 14510     982194   3.3 13
2003   1.41  2.62 16710    1000350  4.14 13
2004   1.58  5.03 20260    1018684  4.33 13
2005   1.95  4.85 23990    1037062   5.3 13
2006   1.44  4.71 25600    1055438  4.54 13
2007   1.22   5.1 27340    1073873  3.92 13
2008    .83  3.65 31970    1092390  3.65 13
2009   1.73 -2.02 32780    1110974  5.36 13
2010    .72  2.28 32130    1129686  6.26 13
2011     .8   .42 32640    1145086  7.86 13
2012   1.94 -3.45 29760    1156556  11.8 13
2013   1.05 -6.59 27890    1166968 15.87 13
2014    .96 -1.78 26610    1176995 16.09 13
2015   1.29  3.42 26100    1187280 14.91 13
2016   1.11  6.57 24840    1197881 12.95 13
2017    .59  5.73 25050    1208523 11.05 13
2018   1.26  5.65 27410    1218831  8.37 13
2019   1.25  5.53 28560    1228836  7.07 13
2000  60.31  1.13  1880    5958482  6.96 14
2001  60.57   .88  1930    5988095  6.96 14
2002  47.55  1.57  1990    6011275  5.73 14
2003  55.99  1.57  2110    6026849  6.26 14
2004  64.69   .89  2270    6035655  6.05 14
2005  64.14  2.71  2420    6037817  7.22 14
2006   64.6  4.35  2590    6034436  6.57 14
2007  57.27  1.86  2710    6044131  6.41 14
2008  51.85  2.13  2900    6068099  5.88 14
2009  71.16 -2.09  2850    6091188  7.33 14
2010  64.47  2.11  2910    6114034  4.89 14
2011  70.38  3.81  3100    6137349   4.3 14
2012  41.58  2.82  3250    6161289  3.84 14
2013  40.11  2.24  3390    6185642  3.69 14
2014  62.29  1.71  3450    6209526  4.15 14
2015 105.23   2.4  3490    6231066     4 14
2016  83.01  2.54  3570    6250510  4.42 14
2017  62.02  2.25  3670    6266654  4.39 14
2018  52.11  2.41  3900    6276342  4.01 14
2019  37.16  2.44  4090    6280217  4.17 14
2000   2.85  5.77 26480    5176209 11.13 15
2001      3  2.61 25850    5188008 10.29 15
2002   2.53  1.71 25620    5200598 10.42 15
2003   1.97     2 28800    5213014 10.47 15
2004   2.82  3.99 35380    5228172 10.36 15
2005   2.26  2.78 40230    5246096  8.38 15
2006   2.26  4.03 42840    5266268  7.72 15
2007   2.44   5.3 46190    5288720  6.85 15
2008    2.5   .78 50160    5313399  6.37 15
2009   2.25 -8.08 48950    5338871  8.25 15
2010   2.22  3.19 49750    5363352  8.39 15
2011   2.04  2.55 50260    5388272  7.78 15
2012   1.63  -1.4 48970    5413971  7.69 15
2013   1.64   -.9 49510    5438972  8.19 15
2014   1.61  -.37 49420    5461512  8.66 15
2015    1.5   .54 47180    5479531  9.38 15
2016   1.35  2.81 45530    5495303  8.82 15
2017   1.22  3.19 44840    5508214  8.64 15
2018   1.56  1.14 48210    5515525  7.36 15
2019   1.59  1.23 49940    5521606  6.69 15
2000   1.78  5.44 24990   60921384 10.22 16
2001   1.76  4.33 23870   61367388  8.61 16
2002   1.87  4.64 23150   61816234   8.7 16
2003   1.64  1.23 26000   62256970  8.31 16
2004   1.63 11.06 31450   62716306  8.91 16
2005    1.6  5.84 35920   63188395  8.49 16
2006   1.43  5.86 37880   63628261  8.45 16
2007   1.61  6.01 40160   64021737  7.66 16
2008   1.64  5.04 43540   64379696  7.06 16
2009   1.31  2.88 44070   64710879  8.74 16
2010   1.27  6.95 43970   65030575  8.87 16
2011   1.35     0 44440   65345233  8.81 16
2012   1.23  4.87 43410   65662240   9.4 16
2013   1.22  3.48 43800   66002289  9.92 16
2014   1.23  2.16 43340   66312067 10.29 16
2015   1.57   .92 41130   66548272 10.35 16
2016   1.37   2.4 39100   66724104 10.05 16
2017   1.25  2.48 38320   66918020  9.41 16
2018    1.2  2.62 41170   67158348  9.02 16
2019   1.32  2.21 42460   67388001  8.41 16
2000   1.68  2.91 26180   82211508  7.92 17
2001   1.45  1.68 24770   82349925  7.77 17
2002   1.44   -.2 23680   82488495  8.48 17
2003   1.34   -.7 26140   82534176  9.78 17
2004   1.36  1.18 31670   82516260 10.73 17
2005   1.28   .73 35770   82469422 11.17 17
2006   1.21  3.82 38270   82376451 10.25 17
2007   1.09  2.98 40470   82266372  8.66 17
2008   1.03   .96 43650   82110097  7.52 17
2009    .99 -5.69 43660   81902307  7.74 17
2010    .98  4.18 44680   81776930  6.97 17
2011    .91  3.93 47320   80274983  5.82 17
2012    .81   .42 46560   80425823  5.38 17
2013    .84   .44 47220   80645605  5.23 17
2014    .88  2.21 47640   80982500  4.98 17
2015    .83  1.49 45780   81686611  4.62 17
2016   1.17  2.23 44280   82348669  4.12 17
2017    .98  2.68 43760   82657002  3.75 17
2018    .95   .98 47490   82905782  3.38 17
2019    .75  1.06 49220   83092962  3.14 17
2000  10.18 -1.36   870     759051 11.86 18
2001  10.74  2.28   870     759809 11.81 18
2002   19.2  1.13   870     760323 11.81 18
2003  28.05  -.63   920     760562 11.55 18
2004  17.57  1.56  1010     760424 11.27 18
2005  19.03 -1.95  1070     759709 11.02 18
2006   20.5  5.13  1450     758367  10.7 18
2007  15.41  7.19  2250     756521 10.96 18
2008  21.16  1.76  3820     754150 11.27 18
2009  15.65  3.61  4160     751258 11.53 18
2010  18.68  4.14  4520     747932  11.8 18
2011  17.29   5.2  4870     744230 12.06 18
2012   18.4  5.28  5360     743966 12.34 18
2013  20.41  3.65  5630     747420 12.63 18
2014  19.52  1.69  5660     751115 12.92 18
2015  19.42   .69  5560     755031 13.21 18
2016  18.41  3.81  5690     759087 13.46 18
2017  14.84  3.73  6000     763252 13.75 18
2018  14.25  4.44  6240     785514 14.02 18
2019  17.37  5.35  6500     798753 13.99 18
2000  48.31  7.29  1010    6656725  3.84 19
2001  51.66  2.72  1040    6837861     4 19
2002  52.29  3.75  1060    7019908  4.02 19
2003  57.32  4.55  1110    7201881   5.3 19
2004  49.97  6.23  1190    7383407  5.99 19
2005  43.06  6.05  1270    7564613  4.91 19
2006  40.84  6.57  1340    7745200  3.57 19
2007  45.95  6.19  1470    7924462  3.21 19
2008  55.82  4.23  1610    8101777  3.16 19
2009  64.78 -2.43  1650    8277302  3.29 19
2010  74.98  3.73  1710    8450933  4.12 19
2011  83.77  3.84  1850    8622504  4.47 19
2012     83  4.13  1930    8792367  3.75 19
2013  73.09  2.79  1970    8960657  5.65 19
2014  65.78  3.06  1970    9127846  7.08 19
2015  56.49  3.84  2020    9294505  6.15 19
2016  55.55  3.89  2080    9460798  6.73 19
2017  40.98  4.84  2200    9626842  5.53 19
2018  38.93  3.85  2280    9792850  5.65 19
2019  42.01  2.65  2330    9958829   5.7 19
2000   2.01  4.48  4620   10210971  6.56 20
2001   2.49  4.07  4790   10187576  5.67 20
2002      2  4.74  5290   10158608  5.61 20
2003   2.25  4.07  6630   10129552  5.79 20
2004   2.07  5.01  8650   10107146  5.83 20
2005   1.63  4.29 10380   10087065  7.19 20
2006   1.73  3.95 11240   10071370  7.49 20
2007   1.54   .28 11770   10055780  7.41 20
2008   1.81     1 13250   10038188  7.82 20
2009    1.4  -6.6 13410   10022650 10.03 20
2010   1.39  1.08 13260   10000023 11.17 20
2011   1.47  1.87 13250    9971727 11.03 20
2012   1.26 -1.25 13080    9920362    11 20
2013   1.57   1.8 13520    9893082 10.18 20
2014   1.49  4.23 13560    9866468  7.73 20
2015   2.26  3.71 13230    9843028  6.81 20
2016   2.07   2.2 13100    9814023  5.11 20
2017   1.64  4.27 13180    9787966  4.16 20
2018    .89  5.36 14980    9775564  3.71 20
2019    .66  4.86 16570    9771141  3.42 20
2000   4.56  3.84   440 1059633675  5.56 21
2001   4.32  4.82   450 1078970907  5.58 21
2002   4.18   3.8   460 1098313039  5.53 21
2003   3.99  7.86   510 1117415123  5.64 21
2004   4.12  7.92   600 1136264583  5.63 21
2005   3.93  7.92   700 1154638713  5.61 21
2006   3.86  8.06   780 1172373788   5.6 21
2007   3.83  7.66   910 1189691809  5.57 21
2008   3.83  3.09   990 1206734806  5.41 21
2009   3.76  7.86  1110 1223640160  5.54 21
2010   3.76   8.5  1210 1240613620  5.55 21
2011   3.81  5.24  1360 1257621191  5.43 21
2012   3.75  5.46  1470 1274487215  5.41 21
2013   3.58  6.39  1500 1291132063  5.42 21
2014   3.66  7.41  1550 1307246509  5.44 21
2015   3.39     8  1590 1322866505  5.44 21
2016    3.2  8.26  1660 1338636340  5.42 21
2017   3.06   6.8  1800 1354195680  5.36 21
2018   3.03  6.45  1980 1369003306  5.33 21
2019   2.96  3.74  2080 1383112050  5.27 21
2000   2.59  8.67 19960    6116958  11.1 22
2001   3.19   .33 19920    6237982 11.81 22
2002   3.37  -.11 19130    6356693 12.89 22
2003   2.72  1.39 19300    6475913 13.51 22
2004   2.49  4.79 20680    6595986 13.03 22
2005   2.59  4.13 22190    6714124 11.34 22
2006   2.29  5.58 23030    6832077 10.71 22
2007   1.97  6.03 24710    6952003  9.38 22
2008   1.71  3.25 26900    7074522   7.7 22
2009      2   .88 27940    7199703  9.53 22
2010   2.04  5.67 30280    7328445  8.48 22
2011   1.96  5.56 32320    7459749  7.14 22
2012   1.68  2.59 33020    7592106  6.86 22
2013   1.64  4.42 35080    7726676  6.21 22
2014   1.38  3.92 36670    7863846  5.89 22
2015   1.38  2.49 36640    8007778  5.25 22
2016   1.28  4.52 36970    8159009   4.8 22
2017   1.49  4.28 38320    8309257  4.22 22
2018   1.38  4.07 41690    8456483     4 22
2019   1.47  4.16 44070    8607919   3.8 22
2000    .53  2.77 36810  126803861  4.75 23
2001    .55   .39 37380  127065731  5.02 23
2002    .52   .04 35360  127301750  5.39 23
2003    .54  1.54 35660  127502352  5.25 23
2004    .55  2.19 39000  127671288  4.73 23
2005     .5   1.8 41280  127798373  4.45 23
2006    .48  1.37 40590  127902167  4.19 23
2007    .45  1.48 39310  128006426  3.89 23
2008    .51 -1.22 39380  128077633     4 23
2009    .39 -5.69 39230  128117042  5.07 23
2010    .36   4.1 43910  128105431   5.1 23
2011    .34   .02 47470  128007257  4.55 23
2012    .33  1.38 50060  127853688  4.36 23
2013    .29  2.01 48850  127678924     4 23
2014    .31    .3 44440  127476735   3.6 23
2015    .28  1.56 39380  127250933   3.4 23
2016    .28   .75 38460  126993857   3.1 23
2017    .24  1.68 38930  126662472   2.8 23
2018    .26   .58 41770  126255866   2.4 23
2019    .25  -.24 42010  125791677   2.4 23
2000   8.74  5.44   280    4898400  7.54 24
2001   7.78  5.32   280    4945100  7.84 24
2002   8.23  -.02   290    4990700 12.55 24
2003   8.38  7.03   340    5043300  9.92 24
2004   8.32  7.03   400    5104700  8.53 24
2005   9.67  -.18   450    5162600  8.11 24
2006    8.7   3.1   500    5218400  8.27 24
2007   8.02  8.54   610    5268400   8.1 24
2008   7.94   8.4   760    5318700  8.22 24
2009   7.85  2.89   860    5383300  8.41 24
2010  16.76  -.47   850    5447900  8.64 24
2011   8.46  5.96   880    5514600  8.53 24
2012   6.76  -.09  1040    5607200  8.43 24
2013   5.25 10.92  1190    5719600  8.33 24
2014   5.48  4.02  1250    5835500  8.05 24
2015   5.12  3.88  1180    5956900  7.56 24
2016      3  4.34  1110    6079500  7.21 24
2017   3.26  4.74  1110    6198200  6.89 24
2018   2.92  3.76  1220    6322800  6.89 24
2019    2.2   4.6  1240    6456200  6.92 24
2000   8.74  5.44   280    4898400  7.54 25
2001   7.78  5.32   280    4945100  7.84 25
2002   8.23  -.02   290    4990700 12.55 25
2003   8.38  7.03   340    5043300  9.92 25
2004   8.32  7.03   400    5104700  8.53 25
2005   9.67  -.18   450    5162600  8.11 25
2006    8.7   3.1   500    5218400  8.27 25
2007   8.02  8.54   610    5268400   8.1 25
2008   7.94   8.4   760    5318700  8.22 25
2009   7.85  2.89   860    5383300  8.41 25
2010  16.76  -.47   850    5447900  8.64 25
2011   8.46  5.96   880    5514600  8.53 25
2012   6.76  -.09  1040    5607200  8.43 25
2013   5.25 10.92  1190    5719600  8.33 25
2014   5.48  4.02  1250    5835500  8.05 25
2015   5.12  3.88  1180    5956900  7.56 25
2016      3  4.34  1110    6079500  7.21 25
2017   3.26  4.74  1110    6198200  6.89 25
2018   2.92  3.76  1220    6322800  6.89 25
2019    2.2   4.6  1240    6456200  6.92 25
end
label values Country1 Country1
label def Country1 1 "Albania", modify
label def Country1 2 "Armenia", modify
label def Country1 3 "Austria", modify
label def Country1 4 "Bahamas", modify
label def Country1 5 "Barbados", modify
label def Country1 6 "Belize", modify
label def Country1 7 "Brazil", modify
label def Country1 8 "Bulgaria", modify
label def Country1 9 "Canada", modify
label def Country1 10 "Columbia", modify
label def Country1 11 "Costa Rica", modify
label def Country1 12 "Croatia", modify
label def Country1 13 "Cyprus", modify
label def Country1 14 "El Salvador", modify
label def Country1 15 "Finland", modify
label def Country1 16 "France", modify
label def Country1 17 "Germany", modify
label def Country1 18 "Guyana", modify
label def Country1 19 "Hondouras", modify
label def Country1 20 "Hungary", modify
label def Country1 21 "India", modify
label def Country1 22 "Israel", modify
label def Country1 23 "Japan", modify
label def Country1 24 "Kyrgyz Republic", modify
label def Country1 25 "Kyrgyzstan", modify

[anthony carmichael]

here is the one that allows me to run synthetic control on life expectancy i have made this onto into two posts because it exceeds the character count

* Example generated by -dataex-. For more info, type help dataex
clear
input str20 Country int Year double(lifeexpectancytotal Lifeexpectancyatbirthmale Lifeexpectancyatbirthfemale homocide GDP) long(GNI Population) double Unemployement long Country1
"Afghanistan" 2000    55.298 53.762 56.858         .        .     .   19542982 10.806  1
"Afghanistan" 2001    55.798 54.272 57.344         .        .     .   19688632 10.809  1
"Afghanistan" 2002    56.454 55.227 57.672         .        .     .   21000256 11.257  1
"Afghanistan" 2003    57.344 56.032  58.65         .   8.8323     .   22645130 11.141  1
"Afghanistan" 2004    57.944 56.658 59.216         .   1.4141     .   23553551 10.988  1
"Afghanistan" 2005    58.361 57.013 59.697         .  11.2297     .   24411191 11.217  1
"Afghanistan" 2006    58.684 57.133 60.243         .   5.3574     .   25442944 11.099  1
"Afghanistan" 2007    59.111 57.342 60.909         .  13.8263     .   25903301 11.301  1
"Afghanistan" 2008    59.852 58.172 61.529         .    3.925     .   26427199 11.093  1
"Afghanistan" 2009    60.364  58.82 61.892    3.9268  21.3905   460   27385307 11.311  1
"Afghanistan" 2010    60.851 59.278 62.408    3.3681  14.3624   520   28189672 11.352  1
"Afghanistan" 2011    61.419 59.825 62.993    4.0873    .4264   550   29249157 11.054  1
"Afghanistan" 2012    61.923 60.317 63.514    6.2513  12.7523   650   30466479 11.341  1
"Afghanistan" 2013    62.417 60.791 64.027         .   5.6007   680   31541209 11.193  1
"Afghanistan" 2014    62.545 60.812 64.274         .   2.7245   650   32716210 11.142  1
"Afghanistan" 2015    62.659  60.76 64.576    9.7839   1.4513   610   33753499 11.127  1
"Afghanistan" 2016    63.136 61.193 65.096    6.5512   2.2603   570   34636207 11.158  1
"Afghanistan" 2017    63.016 60.105 66.099    6.6784    2.647   540   35643418  11.18  1
"Afghanistan" 2018    63.081 59.923 66.458    6.6556   1.1892   520   36686784 11.152  1
"Afghanistan" 2019    63.565 60.619 66.677         .   3.9116   530   37769499 11.217  1
"Armenia"     2000    70.624  66.89 74.152    2.9646      5.9   640    3168523 11.048  2
"Armenia"     2001    70.932 67.073 74.587    2.8846      9.6   690    3133133 10.912  2
"Armenia"     2002    71.018 67.124 74.707    2.2742     13.2   780    3105037 10.776  2
"Armenia"     2003    71.436 67.306 75.375      2.52       14   940    3084102 10.594  2
"Armenia"     2004    71.421 67.494 75.116     2.766     10.5  1160    3065745 10.344  2
"Armenia"     2005    71.792 67.596 75.781    1.9455     13.9  1500    3047246 10.203  2
"Armenia"     2006    71.987 67.743 76.011    2.6705     13.2  1970    3026486  9.997  2
"Armenia"     2007    72.327  68.08 76.322    2.6256     13.7  2690    3004393   9.81  2
"Armenia"     2008    72.398 67.995 76.572    3.3361      6.9  3510    2983421 14.393  2
"Armenia"     2009    72.813 68.242 77.149    3.3586    -14.1  3250    2964296  18.44  2
"Armenia"     2010     73.16 68.597 77.437    1.9463      2.2  3390    2946293  19.01  2
"Armenia"     2011    73.305 68.613 77.713    2.4682      4.7  3470    2928976  18.44  2
"Armenia"     2012    73.454 69.037 77.483    2.2536      7.2  3840    2914421   17.3  2
"Armenia"     2013    73.676 69.062 77.913    2.1742      3.3  4110    2901385  16.18  2
"Armenia"     2014    74.058 69.236 78.498    2.4722      3.6  4170    2889930   17.5  2
"Armenia"     2015    74.436 69.595 78.833    2.5636      3.2  4080    2878595  18.26  2
"Armenia"     2016    74.664 69.673 79.203    2.9631       .2  3850    2865835  17.62  2
"Armenia"     2017    74.906  69.92 79.381    2.3771      7.5  4070    2851923   17.7  2
"Armenia"     2018    75.064 69.992 79.601    1.6939      5.2  4410    2836557  18.97  2
"Armenia"     2019    75.439 70.403 79.856    2.4681      7.6  4880    2820602   18.3  2
"Azerbaijan"  2000    64.891 61.032 68.794    2.7823     11.1   630    8190337  11.78  3
"Azerbaijan"  2001     65.51 61.697 69.356    2.6594      9.9   680    8282023  10.91  3
"Azerbaijan"  2002    66.239 62.589 69.884    2.5613   9.4389   740    8372127  10.04  3
"Azerbaijan"  2003    66.756 63.161 70.336      2.19  10.2083   840    8462322   9.17  3
"Azerbaijan"  2004    67.346 63.881 70.771      2.38   9.2538   960    8556164   7.99  3
"Azerbaijan"  2005    67.562 64.154 70.947      2.25  27.9615  1290    8656237   7.26  3
"Azerbaijan"  2006    68.165 64.762 71.557       2.2     34.5  1920    8763353   6.62  3
"Azerbaijan"  2007    68.603 65.189 72.025    2.1664       25  2730    8878411   6.33  3
"Azerbaijan"  2008    68.811 65.623 71.989    2.1764   10.759  3890    8999696   5.86  3
"Azerbaijan"  2009    69.356 65.976 72.777         .   9.2964  4820    9119628   5.74  3
"Azerbaijan"  2010    69.529 66.255 72.821    2.2807   5.0489  5410    9237202   5.63  3
"Azerbaijan"  2011    69.984  66.64 73.344    2.3069       .1  5570    9359014   5.42  3
"Azerbaijan"  2012     70.36 66.905 73.833    2.1803   2.1652  6480    9485576   5.19  3
"Azerbaijan"  2013    70.881 67.482 74.277    2.3547   5.8098  7450    9614478   4.97  3
"Azerbaijan"  2014    71.116 67.813 74.384    2.4827   2.7505  7740    9741880   4.91  3
"Azerbaijan"  2015    71.451 68.081 74.788    2.1927    1.094  6610    9863480   4.96  3
"Azerbaijan"  2016    72.004 68.411 75.587    1.7358     -3.1  4790    9976248      5  3
"Azerbaijan"  2017    72.248 68.953 75.467    1.8486       .2  4110   10071567      5  3
"Azerbaijan"  2018     72.76 69.693 75.708      1.98      1.5  4080   10152522    4.9  3
"Azerbaijan"  2019    73.102  70.23 75.832     1.672      2.5  4510   10232753   4.85  3
"Bahrain"     2000    75.496 74.099  77.48         .   5.3001 10220     711442  1.084  4
"Bahrain"     2001    75.908 74.634 77.669    1.2902   2.4909 10980     730257  1.108  4
"Bahrain"     2002    76.088 74.772 77.908    1.0882   3.3486 11850     748324  1.105  4
"Bahrain"     2003    76.337 75.126  77.97       .39   6.2964 12950     778256  1.087  4
"Bahrain"     2004     76.56 75.308 78.253       .84    6.981 14510     833451  1.086  4
"Bahrain"     2005    76.931 75.617 78.723       .45    6.769 16310     901921  1.091  4
"Bahrain"     2006    77.156 75.842 78.941       .73    6.467 17660     970981  1.097  4
"Bahrain"     2007    77.634 76.281 79.469     .3861    8.294 19570    1040532  1.088  4
"Bahrain"     2008    78.084 76.838 79.719     .5383    6.245 20940    1110343  1.107  4
"Bahrain"     2009    78.461 77.323 79.901     1.097   2.5399 18920    1179453  1.139  4
"Bahrain"     2010    78.748 77.737 79.966     .1612   4.3343 19390    1213645   1.13  4
"Bahrain"     2011     78.89 77.882 80.109     .7041   1.9835 19150    1212077  1.181  4
"Bahrain"     2012    79.081  78.03 80.369     .5385   3.7281 23360    1224939    1.2  4
"Bahrain"     2013    79.246 78.126 80.646     .5323   5.4168 24790    1261673  1.184  4
"Bahrain"     2014    79.328   78.2 80.813     .5988   4.3504 24530    1311134   1.19  4
"Bahrain"     2015    79.405 78.342  80.84     .5832   2.4854 22740    1362142  1.202  4
"Bahrain"     2016    79.557 78.462 81.033     .7014   3.5581 21820    1409661  1.191  4
"Bahrain"     2017    79.689 78.612 81.116     .3347   4.2909 21790    1456834  1.183  4
"Bahrain"     2018    79.857 78.816 81.195     .3823   2.1111 23210    1487340  1.201  4
"Bahrain"     2019    80.019  78.98 81.319     .1219    2.167 24420    1494188  1.196  4
"Bangladesh"  2000    65.779 65.472 66.109    2.6187   5.2933   430  129200000   3.27  5
"Bangladesh"  2001    66.135 65.665  66.66    2.8273   5.0773   430  131700000  3.617  5
"Bangladesh"  2002    66.612  65.74 67.627    2.6442   3.8331   430  134100000  3.898  5
"Bangladesh"  2003    66.824 65.648 68.218    2.5751   4.7396   460  136500000   4.32  5
"Bangladesh"  2004    67.187 66.038 68.534    2.8485   5.2395   500  138800000  4.261  5
"Bangladesh"  2005    67.299 66.005 68.817    2.5835   6.5359   540  140900000   4.25  5
"Bangladesh"  2006    67.241 65.911 68.793    2.9563   6.6719   570  142600000   3.59  5
"Bangladesh"  2007    66.714 65.417 68.213    2.7078   7.0586   600  144100000  4.127  5
"Bangladesh"  2008    67.051 65.597 68.731    2.8405   6.0138   660  145400000  4.567  5
"Bangladesh"  2009    67.403 66.111 68.863    2.8912   5.0451   720  146700000      5  5
"Bangladesh"  2010    68.638 67.165 70.312    2.7023   5.5718   800  148400000   3.38  5
"Bangladesh"  2011    68.809 67.339 70.467    2.6569   6.4644   890  150200000  3.771  5
"Bangladesh"  2012    69.554 67.605 71.831    2.7244   6.5215   970  152100000  4.119  5
"Bangladesh"  2013    69.565 67.108  72.54    2.8757   6.0136  1030  154000000   4.43  5
"Bangladesh"  2014    69.986 67.876  72.42    2.9214   6.0611  1100  156000000  4.384  5
"Bangladesh"  2015    70.491 68.498 72.739    2.5823   6.5526  1210  157800000  4.366  5
"Bangladesh"  2016     71.09 69.085 73.325    2.2731   7.1135  1410  159800000   4.35  5
"Bangladesh"  2017    71.788 69.822  73.95    2.2225   6.5902  1650  161800000   4.37  5
"Bangladesh"  2018    72.567 70.889 74.346    2.3733   7.3194  2020  163700000  4.413  5
"Bangladesh"  2019    72.806 70.713  75.09         .   7.8819  2210  165500000  4.438  5
"Bhutan"      2000     62.01 60.712 63.577    3.0456   3.3551   700     587207  1.593  6
"Bhutan"      2001    63.444 62.134 65.019    3.1476    8.349   750     603234    1.9  6
"Bhutan"      2002    64.078 62.727 65.703    3.0843  10.9923   810     619048  1.889  6
"Bhutan"      2003    64.696 63.335 66.335     .7964   7.8233   900     634627    1.8  6
"Bhutan"      2004    65.268 63.898 66.917    2.3481   6.0087  1020     649991   2.49  6
"Bhutan"      2005    65.805 64.427 67.463    1.6956   7.2872  1170     663323    3.1  6
"Bhutan"      2006    66.362 64.915 68.099     1.369   6.9997  1290     673260   3.13  6
"Bhutan"      2007    66.954 65.515 68.675    2.1057  18.3609  1590     681614    3.7  6
"Bhutan"      2008    67.499 66.073 69.199    2.6801   4.7995  1720     689737  3.655  6
"Bhutan"      2009    67.897 66.495 69.561    2.3587   6.7483  1810     697678   3.96  6
"Bhutan"      2010     68.43 67.027 70.092    2.3341  11.9459  1980     705516   3.32  6
"Bhutan"      2011    68.881 67.407 70.628    4.6156   7.9826  2180     713331   3.23  6
"Bhutan"      2012    69.326 67.836 71.091    4.7037   5.1184  2330     721145   2.05  6
"Bhutan"      2013    69.707 68.233 71.451    3.3792     2.12  2350     728889   2.87  6
"Bhutan"      2014    70.049 68.567 71.798         .   5.7765  2400     736357   2.63  6
"Bhutan"      2015    70.343 68.875 72.072    1.6486   6.6422  2470     743274   2.45  6
"Bhutan"      2016    70.602 69.141 72.317    1.2217    8.127  2600     749761  2.493  6
"Bhutan"      2017    70.847 69.371 72.576    1.7436   4.6518  2760     756121  2.453  6
"Bhutan"      2018    71.129 69.602 72.914     1.193   3.0551  2940     762096  2.444  6
"Bhutan"      2019    71.391 69.813 73.236    1.0484   5.7552  3130     767459  2.502  6
"Brunei"      2000     74.08 72.086 76.524 1.2006027   2.8494 14650     333926  5.678  7
"Brunei"      2001    74.276 72.289   76.7         .    2.744 16040     340748  5.785  7
"Brunei"      2002    74.426  72.43  76.85         .   3.8721 17100     347463  5.941  7
"Brunei"      2003    74.561 72.578 76.956 .84914873    2.904 17770     354045  6.012  7
"Brunei"      2004     74.65 72.663 77.038 .55643039    .5043 19930     360461  6.021  7
"Brunei"      2005    74.731 72.756 77.089 .54777712    .3875 22990     366717  6.125  7
"Brunei"      2006    74.783  72.81 77.124 .81023708   4.3977 27390     372808   6.41  7
"Brunei"      2007    74.818 72.844 77.143 .80007041    .1546 30620     378748  6.333  7
"Brunei"      2008     74.84 72.862 77.149 .26356156  -1.9397 33690     384568  6.349  7
"Brunei"      2009    74.846 72.851 77.152 .78144943  -1.7645 31920     390311  6.465  7
"Brunei"      2010    74.849 72.843 77.142 .25731151    2.599 32680     396053  6.774  7
"Brunei"      2011    74.858 72.845 77.126  .2540089   3.7453 34830     401506  6.941  7
"Brunei"      2012    74.827 72.803 77.096 1.0025138    .9128 41580     406634  6.916  7
"Brunei"      2013    74.799 72.774 77.056 .49454272   -2.126 44520     411702   6.88  7
"Brunei"      2014    74.779 72.741 77.041         .  -2.5084 42380     416656   6.97  7
"Brunei"      2015     74.75 72.714 77.001         .   -.3924 38250     421437  7.785  7
"Brunei"      2016    74.733 72.697 76.978         .  -2.4779 32690     425994  8.383  7
"Brunei"      2017    74.722 72.685 76.963         .   1.3286 29400     430276   9.32  7
"Brunei"      2018    74.712 72.668 76.956         .    .0522 29030     434274    8.7  7
"Brunei"      2019    74.748 72.706 76.986         .   3.8691 31880     438048   6.92  7
"Cambodia"    2000    58.625 56.559  60.53    4.6976   9.9936   300   12118841   .968  8
"Cambodia"    2001    59.966 57.863  61.91    3.2808   8.1484   310   12338192  1.033  8
"Cambodia"    2002    61.226 58.973 63.316    3.3629   6.5789   320   12561779  1.097  8
"Cambodia"    2003    62.523 60.238 64.643    3.9592   8.5059   360   12787710  1.114  8
"Cambodia"    2004    63.552  61.48  65.46    3.9108  10.3405   410   13016371   1.13  8
"Cambodia"    2005    64.293 62.213 66.209    3.3752  13.2501   470   13246583  1.131  8
"Cambodia"    2006    65.059 62.945  67.01    2.9679  10.7711   520   13477779  1.209  8
"Cambodia"    2007    65.731 63.603 67.698    2.8728  10.2126   590   13714791   1.26  8
"Cambodia"    2008     66.47 64.299 68.479    2.3985   6.6916   670   13943888    .82  8
"Cambodia"    2009    67.444 65.155 69.575    2.3486    .0867   690   14155740    .58  8
"Cambodia"    2010    67.712 65.436 69.834    2.3127   5.9631   750   14363532    .77  8
"Cambodia"    2011    68.416 65.957 70.726     1.843   7.0696   810   14573885    .58  8
"Cambodia"    2012    68.915 66.652 71.026         .   7.3133   880   14786640    .51  8
"Cambodia"    2013    69.304 66.802 71.665         .   7.3567   960   14999683    .44  8
"Cambodia"    2014    69.736 67.446 71.881         .   7.1426  1020   15210817    .69  8
"Cambodia"    2015    69.873 67.586  72.02         .   6.9658  1070   15417523    .39  8
"Cambodia"    2016    70.224 67.658 72.666         .   6.9333  1160   15624584    .72  8
"Cambodia"    2017    70.515 68.213 72.689         .   6.9969  1260   15830689    .14  8
"Cambodia"    2018    70.561 68.226 72.778         .   7.4692  1420   16025238   .143  8
"Cambodia"    2019    70.692   68.4 72.873         .   7.0541  1560   16207746   .147  8
"China"       2000    71.881 69.723 74.189      2.08   8.4901   940 1264000000   3.26  9
"China"       2001    72.606 70.162 75.258         2   8.3357  1010 1273000000    3.8  9
"China"       2002    72.985 70.538  75.64    2.0099   9.1336  1110 1281000000   4.24  9
"China"       2003    73.371  70.91 76.044    1.8546   10.038  1280 1289000000   4.58  9
"China"       2004    73.748 71.275 76.433    1.8677  10.1136  1510 1297000000   4.49  9
"China"       2005    74.111 71.619 76.819    1.5607  11.3946  1760 1305000000   4.52  9
"China"       2006    74.504 72.043 77.167    1.3429   12.721  2060 1313000000   4.43  9
"China"       2007    74.762 72.248 77.492    1.1976  14.2309  2510 1322000000   4.35  9
"China"       2008    74.872 72.389 77.562    1.0942   9.6507  3100 1330000000   4.59  9
"China"       2009    75.343 72.831 78.066    1.0775   9.3987  3680 1339000000   4.72  9
"China"       2010    75.599  73.08 78.326     .9797  10.6359  4340 1348000000   4.53  9
"China"       2011    75.903 73.368 78.644     .8729   9.5508  5040 1357000000   4.55  9
"China"       2012    76.192 73.613 78.983     .8153   7.8637  5910 1367000000   4.57  9
"China"       2013    76.452 73.884 79.223     .7644   7.7662  6740 1376000000   4.59  9
"China"       2014    76.717 74.134 79.499     .7205   7.4258  7470 1385000000   4.61  9
"China"       2015    76.977 74.379 79.772     .6539   7.0413  7890 1394000000   4.63  9
"China"       2016    77.218 74.582 80.053     .6106   6.8488  8210 1402000000   4.53  9
"China"       2017    77.248 74.433 80.321     .5623   6.9472  8670 1410000000   4.44  9
"China"       2018    77.744 75.046 80.637     .5271   6.7498  9540 1417000000   4.28  9
"China"       2019    77.968 75.298 80.816         .   5.9505 10310 1422000000   4.52  9
"Cyprus"      2000    76.568 74.601 78.552     .8481   5.9653 14180     948237   4.97 10
"Cyprus"      2001    76.989 74.977  79.02      .729   3.9526 14170     964830   3.98 10
"Cyprus"      2002    77.487  75.37 79.635     .2047    3.723 14510     982194    3.3 10
"Cyprus"      2003    77.788 75.621 79.992      1.41   2.6233 16710    1000350   4.14 10
"Cyprus"      2004    77.944 75.815 80.105    1.5835   5.0263 20260    1018684   4.33 10
"Cyprus"      2005    78.101 75.953 80.287    1.9462    4.853 23990    1037062    5.3 10
"Cyprus"      2006    78.371 76.255 80.522    1.4347   4.7138 25600    1055438   4.54 10
"Cyprus"      2007     78.81 76.656 81.006    1.2221   5.0981 27340    1073873   3.92 10
"Cyprus"      2008    78.981 76.813 81.198     .8321   3.6468 31970    1092390   3.65 10
"Cyprus"      2009    79.401 77.109 81.766    1.7303  -2.0153 32780    1110974   5.36 10
"Cyprus"      2010    79.665 77.362 82.048      .719   2.2835 32130    1129686   6.26 10
"Cyprus"      2011    79.999 77.736 82.336     .8001    .4167 32640    1145086   7.86 10
"Cyprus"      2012    80.109 78.091  82.15    1.9382  -3.4474 29760    1156556   11.8 10
"Cyprus"      2013    80.402 78.409 82.405    1.0491  -6.5875 27890    1166968  15.87 10
"Cyprus"      2014    80.771 78.817 82.723     .9546  -1.7761 26610    1176995  16.09 10
"Cyprus"      2015    80.966 79.051 82.873     1.292   3.4189 26100    1187280  14.91 10
"Cyprus"      2016    81.056 78.945 83.185    1.1109   6.5736 24840    1197881  12.95 10
"Cyprus"      2017    81.328 79.246 83.415     .5934   5.7335 25050    1208523  11.05 10
"Cyprus"      2018    81.382  79.67 83.058    1.2613   5.6479 27410    1218831   8.37 10
"Cyprus"      2019    81.397 79.508  83.27    1.2515   5.5294 28560    1228836   7.07 10
"Georgia"     2000    69.575 65.348 73.583    5.4789   1.8383   790    4265172  10.82 11
"Georgia"     2001    69.606 65.225 73.807    6.1206   4.8055   780    4144481  11.16 11
"Georgia"     2002    70.024 65.537 74.339    6.8568   5.4738   840    4061128  12.59 11
"Georgia"     2003    70.333 65.853 74.631      7.12  11.0587   990    4017825  11.51 11
"Georgia"     2004    70.567 66.166 74.791    7.0519   5.7945  1210    3988860  12.62 11
"Georgia"     2005     71.13 66.529 75.596    9.5721   9.5896  1520    3961182  13.81 11
"Georgia"     2006    71.394 66.731 75.952    7.7093   9.4198  1910    3933867  13.57 11
"Georgia"     2007    71.568 67.193 75.784    7.9196   12.579  2380    3906470  13.28 11
"Georgia"     2008    71.332 66.705 75.873    6.3486   2.4186  2820    3879698  17.87 11
"Georgia"     2009     71.95 67.391 76.427    5.0977  -3.6505  2950    3855200  20.71 11
"Georgia"     2010    72.128 67.603 76.572     4.562   6.2495  3210    3836831   20.2 11
"Georgia"     2011     72.39 67.856 76.854         .      7.4  3520    3821662  19.63 11
"Georgia"     2012    72.412 67.651 77.205         .    6.369  4150    3804356  19.65 11
"Georgia"     2013    72.628 67.866 77.436         .   3.6213  4530    3786023  19.42 11
"Georgia"     2014    73.099 68.309 77.934      2.68   4.4319  4740    3774235  17.44 11
"Georgia"     2015    73.297 68.477 78.131         .   3.0222  4410    3771132  16.51 11
"Georgia"     2016    73.569 68.696  78.43     .9712   2.9064  4080    3771110   16.6 11
"Georgia"     2017     73.57 68.836 78.224      2.27   4.8426  4040    3771900  13.94 11
"Georgia"     2018    73.341 68.495 78.153    2.2234   4.8429  4460    3772325  12.67 11
"Georgia"     2019     73.47 68.493 78.429    1.9266   4.9824  4690    3770811  11.57 11
"India"       2000    62.669 61.754 63.639    4.5588    3.841   440 1060000000  5.561 12
"India"       2001    63.091 62.114 64.131    4.3181    4.824   450 1079000000  5.576 12
"India"       2002    63.616 62.573 64.729    4.1832    3.804   460 1098000000   5.53 12
"India"       2003    64.094 62.981 65.287    3.9883   7.8604   510 1117000000  5.643 12
"India"       2004    64.524 63.313 65.831    4.1155   7.9229   600 1136000000  5.629 12
"India"       2005    64.996 63.719 66.379    3.9295   7.9234   700 1155000000  5.613 12
"India"       2006    65.412 64.053 66.891    3.8577   8.0607   780 1172000000  5.601 12
"India"       2007    65.788 64.365 67.342    3.8338   7.6608   910 1190000000  5.572 12
"India"       2008    66.149 64.654 67.786    3.8311   3.0867   990 1207000000  5.414 12
"India"       2009    66.513 64.962 68.215    3.7631   7.8619  1110 1224000000  5.544 12
"India"       2010    66.909 65.327 68.645    3.7641   8.4976  1210 1241000000  5.546 12
"India"       2011    67.359 65.765 69.106    3.8103   5.2413  1360 1258000000  5.426 12
"India"       2012    67.887 66.324 69.592    3.7509   5.4564  1470 1274000000  5.414 12
"India"       2013     68.46 66.961 70.083    3.5819   6.3861  1500 1291000000  5.424 12
"India"       2014    69.074 67.651 70.602    3.6551   7.4102  1550 1307000000  5.436 12
"India"       2015    69.636 68.285 71.077    3.3869   7.9963  1590 1323000000  5.435 12
"India"       2016    70.117  68.81 71.503    3.1951   8.2563  1660 1339000000  5.423 12
"India"       2017    70.467 69.159 71.856     3.064   6.7954  1800 1354000000  5.358 12
"India"       2018     70.71 69.367 72.142      3.03   6.4539  1980 1369000000   5.33 12
"India"       2019     70.91 69.525 72.395    2.9624   3.7379  2080 1383000000   5.27 12
"Indonesia"   2000    66.433   64.9 67.975     1.042   4.9201   570  214100000   6.08 13
"Indonesia"   2001    66.758 65.032 68.509         .   3.6435   710  217100000   6.08 13
"Indonesia"   2002    67.134 65.574 68.696         .   4.4995   780  220100000    6.6 13
"Indonesia"   2003    67.413 65.611 69.242     .7421   4.7804   890  223100000   6.66 13
"Indonesia"   2004     65.75 64.374 67.113     .6355   5.0309  1070  225900000    7.3 13
"Indonesia"   2005    67.649 66.009 69.294         .   5.6926  1210  228800000   7.94 13
"Indonesia"   2006    67.914 66.048 69.812         .    5.501  1360  231800000   7.55 13
"Indonesia"   2007    68.189 66.459 69.929         .    6.345  1580  234900000   8.06 13
"Indonesia"   2008    68.226 66.519 69.939       .58   6.0137  1920  237900000   7.21 13
"Indonesia"   2009    68.494 66.599 70.417       .55   4.6289  2130  241000000   6.11 13
"Indonesia"   2010    68.679  66.93 70.434       .44   6.2239  2510  244000000   5.61 13
"Indonesia"   2011    68.823 67.079 70.571        .6   6.1698  2990  247100000   5.15 13
"Indonesia"   2012    68.973 67.177  70.78       .59   6.0301  3550  250200000   4.47 13
"Indonesia"   2013    69.264 67.228 71.346       .55   5.5573  3710  253300000   4.34 13
"Indonesia"   2014    69.533 67.624 71.466        .5   5.0067  3600  256200000   4.05 13
"Indonesia"   2015    69.699 67.791 71.629       .58   4.8763  3420  259100000   4.51 13
"Indonesia"   2016    69.798  67.87 71.751       .49   5.0331  3400  261900000    4.3 13
"Indonesia"   2017    69.936 68.001 71.898       .43   5.0698  3530  264500000   3.88 13
"Indonesia"   2018    70.338 68.311 72.403         .   5.1743  3850  267100000    4.4 13
"Indonesia"   2019    70.518 68.481 72.597         .   5.0193  4070  269600000   3.62 13

[anthony carmichael]

"Iran"        2000    69.691 67.337 72.297         .   5.8455  1770   65544383 11.574 14
"Iran"        2001    69.955 67.591 72.559         .   2.3922  1800   66674851 12.281 14
"Iran"        2002    70.445 68.173 72.923         .   8.0788  1890   67327117   12.8 14
"Iran"        2003    69.823  67.61  72.23      2.65   8.6393  2210   67954699  11.51 14
"Iran"        2004     71.37 69.047 73.886      2.92   4.3367  2510   69061674   10.3 14
"Iran"        2005    71.838 69.513 74.356         .   3.1898  2940   70182594  11.81 14
"Iran"        2006    72.276 69.847 74.918         .   4.9998  3450   71275760  11.52 14
"Iran"        2007    72.772 70.381 75.364         .   8.1558  4220   72319418  10.77 14
"Iran"        2008    72.624 70.492 74.918         .    .2509  4890   73318394  10.63 14
"Iran"        2009    72.698 70.543 75.011    3.0374   1.0074  5450   74322685  12.11 14
"Iran"        2010    73.069 70.631 75.728         .   5.7979  6110   75373855  13.68 14
"Iran"        2011    73.679 71.191 76.383         .   2.6457  6860   76342971  12.49 14
"Iran"        2012    74.186 71.641 76.958         .  -3.7472  7490   77324451  12.27 14
"Iran"        2013    74.449 71.905 77.211    2.6634   -1.522  7340   78458928   10.6 14
"Iran"        2014    74.782 72.383 77.361    2.4992   4.9848  6740   79961672  10.68 14
"Iran"        2015    75.124  72.67 77.765         .  -1.4249  5480   81790841  11.17 14
"Iran"        2016      75.6  73.06 78.336         .   8.8151  5470   83306231  12.62 14
"Iran"        2017    75.971  73.27 78.904         .   2.7585  5490   84505076  12.23 14
"Iran"        2018    76.195 73.519 79.091    2.1944  -2.2539  4880   85617562  12.19 14
"Iran"        2019    76.103 73.379 79.055         .  -2.6582  4010   86564202  10.74 14
"Iraq"        2000    66.817 63.734 69.849         .  16.9217  1520   24628858  8.727 15
"Iraq"        2001    67.034 64.041 69.965         .   1.7615  1650   25425663  8.807 15
"Iraq"        2002    67.084 64.005 70.114         .  -8.1985  1340   26255343  8.852 15
"Iraq"        2003    65.643 61.525 69.925         . -36.6582   800   27068823  8.819 15
"Iraq"        2004    65.031 60.435 69.917         .  53.3818  1300   27858948  8.608 15
"Iraq"        2005    64.844 60.137 69.873         .   1.6719  1340   28698684  8.706 15
"Iraq"        2006    63.587 58.189 69.549         .   5.6463  1730   28905607  8.652 15
"Iraq"        2007    63.553 58.215 69.422         .   1.8856  2330   28660887   8.65 15
"Iraq"        2008    64.942 60.716 69.351   16.1912   8.2281  3440   29218381  8.484 15
"Iraq"        2009    66.446 63.266 69.589    8.8151   3.3793  3980   30289040  8.393 15
"Iraq"        2010    67.062 63.929 70.145    9.0478   6.4026  4350   31264875  8.251 15
"Iraq"        2011    67.659 64.876 70.348    8.5727   7.5465  4710   32378061  8.122 15
"Iraq"        2012    68.023 65.418 70.518    8.4572  13.9364  5940   33864447   7.96 15
"Iraq"        2013    68.253 65.694 70.702   10.0703   7.6286  6590   35481800  9.264 15
"Iraq"        2014    68.914 66.522 71.175     10.08     .197  6320   36746488  10.59 15
"Iraq"        2015     69.44 67.515 71.213         .   4.7229  5460   37757813 10.725 15
"Iraq"        2016    68.988 65.614  72.38         .  13.7874  5050   38697943  10.82 15
"Iraq"        2017    70.413 67.513 73.235         .  -1.8198  4400   39621162  13.02 15
"Iraq"        2018    71.514 69.559 73.293         .   2.6339  4780   40590700 12.966 15
"Iraq"        2019    71.576 69.559 73.428         .   5.5138  5470   41563520 12.863 15
"Israel"      2000 78.953659   77.1   80.9      2.59   8.6717 19960    6116958   11.1 16
"Israel"      2001 79.407317   77.7   81.2    3.1845    .3341 19920    6237982  11.81 16
"Israel"      2002  79.45122   77.5   81.5    3.3715   -.1142 19130    6356693  12.89 16
"Israel"      2003  79.64878   77.6   81.8    2.7236   1.3939 19300    6475913  13.51 16
"Israel"      2004 80.146341     78   82.4    2.4857   4.7845 20680    6595986  13.03 16
"Israel"      2005  80.15122   78.2   82.2    2.5883   4.1341 22190    6714124  11.34 16
"Israel"      2006 80.553659   78.7   82.5    2.2902   5.5827 23030    6832077  10.71 16
"Israel"      2007 80.504878   78.7   82.4    1.9716   6.0332 24710    6952003   9.38 16
"Israel"      2008  80.95122     79     83    1.7092   3.2512 26900    7074522    7.7 16
"Israel"      2009 81.404878   79.6   83.3    2.0028    .8831 27940    7199703   9.53 16
"Israel"      2010 81.602439   79.7   83.6    2.0418   5.6685 30280    7328445   8.48 16
"Israel"      2011 81.656098   79.9   83.5    1.9634   5.5611 32320    7459749   7.14 16
"Israel"      2012 81.704878   79.9   83.6    1.6809   2.5877 33020    7592106   6.86 16
"Israel"      2013 82.056098   80.3   83.9    1.6419   4.4155 35080    7726676   6.21 16
"Israel"      2014 82.153659   80.3   84.1    1.3751   3.9191 36670    7863846   5.89 16
"Israel"      2015  82.05122   80.1   84.1    1.3787   2.4858 36640    8007778   5.25 16
"Israel"      2016 82.407317   80.7   84.2    1.2825   4.5217 36970    8159009    4.8 16
"Israel"      2017  82.55122   80.6   84.6     1.492   4.2766 38320    8309257   4.22 16
"Israel"      2018 82.802439   80.9   84.8     1.384   4.0703 41690    8456483      4 16
"Israel"      2019 82.804878     81   84.7    1.4672   4.1561 44070    8607919    3.8 16
"Japan"       2000 81.076098  77.72   84.6     .5317   2.7646 36810  126800000   4.75 17
"Japan"       2001 81.417073   78.1   84.9     .5458    .3861 37380  127100000   5.02 17
"Japan"       2002 81.563415   78.1   85.2     .5176     .042 35360  127300000   5.39 17
"Japan"       2003     81.76  78.36  85.33     .5443   1.5351 35660  127500000   5.25 17
"Japan"       2004 82.030244  78.64  85.59     .5452   2.1861 39000  127700000   4.73 17
"Japan"       2005 81.925122  78.53  85.49     .5011   1.8039 41280  127800000   4.45 17
"Japan"       2006 82.321951     79  85.81      .482   1.3724 40590  127900000   4.19 17
"Japan"       2007 82.507073  79.19  85.99     .4467    1.484 39310  128000000   3.89 17
"Japan"       2008 82.587561  79.29  86.05     .5088  -1.2243 39380  128100000      4 17
"Japan"       2009 82.931463  79.59  86.44     .3936  -5.6932 39230  128100000   5.07 17
"Japan"       2010 82.842683  79.55   86.3     .3617   4.0979 43910  128100000    5.1 17
"Japan"       2011  82.59122  79.44   85.9      .344    .0238 47470  128000000   4.55 17
"Japan"       2012 83.096098  79.94  86.41     .3341   1.3748 50060  127900000   4.36 17
"Japan"       2013 83.331951  80.21  86.61     .2884   2.0051 48850  127700000      4 17
"Japan"       2014 83.587805   80.5  86.83     .3082    .2962 44440  127500000    3.6 17
"Japan"       2015 83.793902  80.75  86.99     .2836   1.5606 39380  127300000    3.4 17
"Japan"       2016 83.984878  80.98  87.14     .2833    .7538 38460  127000000    3.1 17
"Japan"       2017 84.099756  81.09  87.26       .24   1.6753 38930  126700000    2.8 17
"Japan"       2018 84.210976  81.25  87.32     .2626    .5841 41770  126300000    2.4 17
"Japan"       2019 84.356341  81.41  87.45     .2515   -.2404 42010  125800000    2.4 17
"Jordan"      2000    71.918 70.313 73.696         .   4.2457  1690    5056174   13.7 18
"Jordan"      2001    72.147 70.528 73.939         .     5.27  1760    5163310   14.7 18
"Jordan"      2002    72.359 70.724 74.166         .   5.7838  1790    5275532   15.3 18
"Jordan"      2003    72.573 70.928 74.393         .   4.1617  1920    5396117   14.5 18
"Jordan"      2004    72.772 71.117 74.604         .   8.5672  2180    5532423  14.58 18
"Jordan"      2005    72.932 71.264 74.781      1.16   8.1466  2370    5678534   14.8 18
"Jordan"      2006    73.145  71.48 74.993      1.67    8.093  2480    6075548     14 18
"Jordan"      2007    73.373 71.654  75.29    1.7905   8.1762  2640    6473457   13.1 18
"Jordan"      2008    73.591 71.818 75.578    1.8303   7.2204  3070    6632873   12.7 18
"Jordan"      2009    73.801 71.972  75.86    1.4797   5.0237  3440    6780493   12.9 18
"Jordan"      2010        74 72.117 76.128    1.5975   2.3148  3690    6931258   12.5 18
"Jordan"      2011    74.189  72.26 76.378      1.84   2.7372  3910    7109980   12.9 18
"Jordan"      2012    74.366 72.399 76.605    1.9901   2.4294  4180    7211863   12.2 18
"Jordan"      2013    74.562 72.565 76.839    1.6903   2.6099  4240    7694814   12.6 18
"Jordan"      2014    74.789 72.796 77.061    1.9061   3.3841  4040    8658026   11.9 18
"Jordan"      2015    75.011  73.03 77.268    1.6295   2.4965  3860    9494246  13.08 18
"Jordan"      2016    75.215 73.222 77.485    1.3711   1.9942  3830    9964656  15.28 18
"Jordan"      2017    75.502  73.46 77.831    1.3591   2.4736  3920   10215381  18.14 18
"Jordan"      2018    75.774 73.677 78.172         .   1.9191  4090   10459865  18.27 18
"Jordan"      2019    76.044 73.894 78.506    1.1384   1.9274  4200   10698683  16.81 18
"Kazakhstan"  2000     65.45   60.2   71.2   15.5803      9.8  1270   15236253  12.75 19
"Kazakhstan"  2001     65.76   60.5   71.3   14.4867     13.5  1360   15281285  10.43 19
"Kazakhstan"  2002     65.95   60.7   71.6   13.1342      9.8  1530   15338963   9.33 19
"Kazakhstan"  2003     65.74   60.5   71.5   13.1854      9.3  1810   15416712   8.78 19
"Kazakhstan"  2004     66.06   60.6     72   13.7115      9.6  2300   15521923    8.4 19
"Kazakhstan"  2005     65.86   60.3   71.8         .      9.7  2930   15656248   8.13 19
"Kazakhstan"  2006     66.15   60.6     72         .     10.7  3860   15822748   7.79 19
"Kazakhstan"  2007     66.34   60.7   72.3         .      8.9  4980   16006136   7.26 19
"Kazakhstan"  2008     67.11   61.9   72.4   11.3919      3.3  6110   16196517   6.63 19
"Kazakhstan"  2009     68.39  63.55  73.25   11.0391      1.2  6790   16402369   6.55 19
"Kazakhstan"  2010     68.45  63.55  73.41    8.5342      7.3  7440   16627837   5.77 19
"Kazakhstan"  2011     68.69  63.85  73.57    8.6109      7.4  8280   16864917   5.39 19
"Kazakhstan"  2012     69.52  64.74  74.29    7.5575      4.8  9940   17102864   5.29 19
"Kazakhstan"  2013     70.62  65.91  75.23    6.5781        6 11840   17345732    5.2 19
"Kazakhstan"  2014     71.44   66.9  75.82    5.2246      4.2 12080   17592298   5.06 19
"Kazakhstan"  2015     71.97  67.49  76.26    4.8543      1.2 11380   17835909   4.93 19
"Kazakhstan"  2016     72.41  67.99  76.61         .      1.1  8770   18078553   4.96 19
"Kazakhstan"  2017     72.95  68.72  76.92    5.0608      4.1  8040   18314814    4.9 19
"Kazakhstan"  2018     73.15  68.84  77.19         .      4.1  8070   18538099   4.85 19
"Kazakhstan"  2019     73.18  68.82   77.3         .      4.5  8820   18754258    4.8 19
"Kuwait"      2000    76.722 75.213 78.881         .   4.6946 19000    1934901     .8 20
"Kuwait"      2001    76.891 75.448  78.94    1.8543    .2133 19710    1991674     .8 20
"Kuwait"      2002    76.982 75.574 78.973    1.0763   3.0143 19760    2047364    1.1 20
"Kuwait"      2003    76.985 75.497  79.11    1.3416   17.326 23240    2101506    1.3 20
"Kuwait"      2004    76.792 75.205 79.087    1.9541  10.2403 29130    2153481    1.7 20
"Kuwait"      2005    76.903 75.306 79.187     1.806   10.609 35760    2235403  1.495 20
"Kuwait"      2006    76.887 75.215 79.282    1.8958   7.5148 42480    2363409    1.3 20
"Kuwait"      2007    77.017 75.396 79.302    2.3562   5.9916 47530    2506769    1.5 20
"Kuwait"      2008    77.145 75.553  79.36    1.4307   2.4798 51810    2650930   1.75 20
"Kuwait"      2009    77.442  75.87 79.589    1.7369  -7.0761 45410    2795550   1.64 20
"Kuwait"      2010    77.982 76.399 80.105    2.0054  -2.3703 43190    2943356   1.82 20
"Kuwait"      2011    78.464 76.836 80.617    1.8623   9.6284 44120    3143825  2.038 20
"Kuwait"      2012    78.812  77.15 81.072    1.8215   6.6258 49020    3394663   2.32 20
"Kuwait"      2013    79.164 77.463 81.542         .   1.1493 51310    3646518  2.623 20
"Kuwait"      2014    79.445 77.806 81.772         .    .5009 50050    3761584    2.9 20
"Kuwait"      2015    79.562 77.916 82.004         .     .593 41040    3908743    2.2 20
"Kuwait"      2016    79.701 78.175 82.203         .   2.9259 34540    4048085   2.16 20
"Kuwait"      2017    79.781  78.24 82.303         .  -4.7121 30880    4124904  2.197 20
"Kuwait"      2018    79.722 78.232 82.281         .    2.434 32300    4317185  2.165 20
"Kuwait"      2019    79.685 78.249 82.266         .    -.552 34290    4441100  2.167 20
"Kyrgyzstan"  2000 68.558537   64.9   72.4    8.7386   5.4433   280    4898400   7.54 21
"Kyrgyzstan"  2001 68.707317     65   72.6    7.7778   5.3216   280    4945100   7.84 21
"Kyrgyzstan"  2002 68.156098   64.4   72.1     8.234   -.0173   290    4990700  12.55 21
"Kyrgyzstan"  2003 68.256098   64.5   72.2    8.3773   7.0303   340    5043300   9.92 21
"Kyrgyzstan"  2004 68.153659   64.3   72.2    8.3152   7.0268   400    5104700   8.53 21
"Kyrgyzstan"  2005 67.956098   64.2   71.9    9.6742   -.1755   450    5162600   8.11 21
"Kyrgyzstan"  2006 67.695122   63.5   72.1    8.7035   3.1029   500    5218400   8.27 21
"Kyrgyzstan"  2007 67.895122   63.7   72.3    8.0241   8.5429   610    5268400    8.1 21
"Kyrgyzstan"  2008  68.45122   64.5   72.6    7.9353   8.4016   760    5318700   8.22 21
"Kyrgyzstan"  2009 69.102439   65.2   73.2    7.8542   2.8863   860    5383300   8.41 21
"Kyrgyzstan"  2010      69.3   65.3   73.5   16.7641   -.4716   850    5447900   8.64 21
"Kyrgyzstan"  2011 69.602439   65.7   73.7    8.4633   5.9563   880    5514600   8.53 21
"Kyrgyzstan"  2012 70.002439   66.1   74.1    6.7597   -.0882  1040    5607200   8.43 21
"Kyrgyzstan"  2013 70.202439   66.3   74.3    5.2519  10.9155  1190    5719600   8.33 21
"Kyrgyzstan"  2014 70.402439   66.5   74.5    5.4752    4.024  1250    5835500   8.05 21
"Kyrgyzstan"  2015  70.65122   66.7   74.8    5.1182   3.8758  1180    5956900   7.56 21
"Kyrgyzstan"  2016  70.95122     67   75.1    2.9962   4.3359  1110    6079500   7.21 21
"Kyrgyzstan"  2017      71.2   67.2   75.4    3.2635   4.7399  1110    6198200   6.89 21
"Kyrgyzstan"  2018      71.4   67.4   75.6    2.9188   3.7579  1220    6322800  6.886 21
"Kyrgyzstan"  2019      71.6   67.6   75.8    2.1977   4.6006  1240    6456200  6.918 21
"Lebanon"     2000    73.931 72.251 75.462         .   1.3419  4090    4320642  8.315 22
"Lebanon"     2001    74.365 72.558 76.019         .   3.8397  4060    4389200  8.186 22
"Lebanon"     2002    75.064 72.957 77.022         .   3.4231  3950    4446666  8.088 22
"Lebanon"     2003    75.593 73.657 77.352         .   3.2271  3690    4504807  7.988 22
"Lebanon"     2004    75.976 73.919 77.852         .   6.6794  4720    4574797   7.85 22
"Lebanon"     2005    76.273 74.223 78.128         .   2.6858  4940    4643044   8.28 22
"Lebanon"     2006     76.08 73.145 78.915         .   1.5495  4900    4719864  8.683 22
"Lebanon"     2007     77.08 74.719 79.242         .   9.3106  5360    4809608   8.98 22
"Lebanon"     2008    77.584 75.489 79.439    3.8407   9.0691  5910    4887613  7.672 22
"Lebanon"     2009    77.889 75.826 79.701    3.0127  10.2322  6680    4951135   6.35 22
"Lebanon"     2010    78.156 76.136 79.916    3.2909   7.9751  7410    4995800  6.843 22
"Lebanon"     2011    78.404 76.407 80.134    3.2295    .8673  7800    5045056  7.386 22
"Lebanon"     2012    78.628 76.666  80.32    3.5033   2.5648  8080    5178337  7.848 22
"Lebanon"     2013    78.765 76.782 80.479    3.9912   3.8279  7970    5678851  8.314 22
"Lebanon"     2014    78.973 76.971 80.704    3.8332   2.4841  7520    6274342  8.809 22
"Lebanon"     2015    79.229 77.234 80.951    3.5361    .4623  7440    6398940  9.317 22
"Lebanon"     2016    79.505 77.492 81.264       3.5   1.5545  7750    6258619  9.783 22
"Lebanon"     2017    79.654 77.599 81.475    3.6074     .782  8320    6109252 10.274 22
"Lebanon"     2018    79.729 77.784 81.455    2.5075  -1.7022  8760    5950839 10.796 22
"Lebanon"     2019    79.236 77.251 81.043    2.6547  -7.1572  8630    5781907  11.35 22
"Macau"       2000    80.959 78.262  83.49    2.3377   5.7467 14580     431896   6.87 23
"Macau"       2001    81.179 78.275 83.955    1.8268   2.8886 15720     439122   6.39 23
"Macau"       2002    81.293 78.342 84.138     .4456   8.9108 16260     449665   6.27 23
"Macau"       2003    81.501 78.594 84.299    1.7385  11.6405 17750     462533      6 23
"Macau"       2004    81.691 78.782 84.498     .8482  26.6308 22040     475529    4.9 23
"Macau"       2005    82.033 79.209 84.739     .8284   8.0754 23670     488619   4.16 23
"Macau"       2006    82.257 79.267 85.163    2.0251  13.3904 25770     501863   3.82 23
"Macau"       2007    82.543 79.513 85.496    1.1893  14.4764 33430     515330   3.27 23
"Macau"       2008    82.893 79.873  85.83     .7763   3.3916 32900     529038      3 23
"Macau"       2009    83.276 80.353 86.098     .9498   1.2743 34990     543021   3.58 23
"Macau"       2010    83.109 80.019 86.164     .3716  25.1228 43710     557297   2.84 23
"Macau"       2011    83.229 80.147 86.292     .7262  21.6165 52570     571003   2.56 23
"Macau"       2012    83.326 80.297 86.341     .7092   9.2422 58830     582766   1.97 23
"Macau"       2013    83.727 80.613 86.831     .1732  10.7529 67630     593374   1.82 23
"Macau"       2014    83.883 80.956 86.773     .1694  -2.0484 70480     604167    1.7 23
"Macau"       2015    83.984 81.144 86.784     .1661 -21.5144 60760     615239   1.81 23
"Macau"       2016    84.231 81.409 87.018     .1632   -.6791 62300     626688   1.94 23
"Macau"       2017    84.563 81.962 87.094     .3212   9.9833 68200     638609   1.99 23
"Macau"       2018    84.928 82.349 87.439     .3166   6.4647 74190     650991   1.83 23
"Macau"       2019    84.978 82.344 87.573     .3123  -2.5119 73170     663653   1.75 23
"Malayasia"   2000    72.775  70.57  75.11    2.3756   8.8589  3490   22945150      3 24
"Malayasia"   2001    73.344 71.158  75.66    2.1806    .5177  3570   23542517   3.53 24
"Malayasia"   2002    73.563 71.403 75.857    2.3339    5.391  3800   24142445   3.48 24
"Malayasia"   2003    73.796 71.563 76.194    2.2876   5.7885  4160   24739411   3.61 24
"Malayasia"   2004    73.898 71.695 76.276     1.973   6.7834  4710   25333247   3.54 24
"Malayasia"   2005    74.096 71.935 76.437    2.3511   5.3321  5230   25923536   3.53 24
"Malayasia"   2006    74.164 72.078 76.432    2.2441   5.5848  5770   26509413   3.31 24
"Malayasia"   2007    74.211 72.144 76.474    2.4401   6.2988  6540   27092604   3.23 24
"Malayasia"   2008     74.25 72.148 76.576     2.192   4.8318  7400   27664296   3.32 24
"Malayasia"   2009    74.227 71.953  76.79    2.0227  -1.5135  7470   28217204   3.66 24
"Malayasia"   2010    74.442 72.091 77.124    1.9143   7.4248  8110   28717731   3.39 24
"Malayasia"   2011    74.746 72.341 77.485    1.8499   5.2939  8890   29184133   3.05 24
"Malayasia"   2012    74.944 72.595 77.598     2.071   5.4735  9980   29660212    3.1 24
"Malayasia"   2013    75.035 72.735 77.618    2.1277   4.6937 10600   30134807   3.16 24
"Malayasia"   2014    75.146 72.883 77.677         .   6.0067 10870   30606459   2.88 24
"Malayasia"   2015    75.094  72.75 77.728         .   5.0915 10400   31068833    3.1 24
"Malayasia"   2016    75.289 72.927 77.938         .   4.4498  9880   31526418   3.44 24
"Malayasia"   2017    75.476 73.099 78.139         .   5.8127  9680   31975806   3.41 24
"Malayasia"   2018    75.644 73.293 78.267         .   4.8431 10370   32399271    3.3 24
"Malayasia"   2019     75.76 73.465 78.306         .   4.4132 10960   32804020   3.26 24
"Maldives"    2000    70.876  70.16 71.763         .   3.8458  2050     282507   1.97 25
"Maldives"    2001    72.181 71.388 73.175    2.4449  -3.9436  2230     287324  2.997 25
"Maldives"    2002    73.291 72.554 74.209    2.7194   7.2684  2640     292284  4.188 25
"Maldives"    2003     74.06 73.183 75.184      1.32    13.75  3460     297226  5.394 25
"Maldives"    2004    73.538 72.635 74.746         .   6.0338  3890     302135  6.416 25
"Maldives"    2005    74.751 73.588 76.307         . -13.1291  3600     307018  7.201 25
"Maldives"    2006     75.13 73.985 76.652         .  26.1115  4730     314401  9.156 25
"Maldives"    2007    75.686 74.614 77.091     .8951   7.7139  4610     325126  9.868 25
"Maldives"    2008    76.543 75.551 77.829    1.4558   9.4853  5520     336883 11.056 25
"Maldives"    2009    77.069 76.099 78.324    1.6978  -7.2288  5530     349037   11.7 25
"Maldives"    2010    77.657 76.769 78.795    1.6406   7.2651  6030     361575 11.288 25
"Maldives"    2011    78.124 77.291 79.188     .7885   8.5667  6700     374440 10.472 25
"Maldives"    2012    78.682 77.947 79.611    2.5174   2.5174  6790     387539  9.472 25
"Maldives"    2013    79.057 78.245 80.103     .7219   7.2811  7060     400728  8.727 25
"Maldives"    2014    79.424 78.662 80.406         .   7.3296  7640     416738  7.867 25
"Maldives"    2015    79.695 78.941 80.675     .8793   2.8845  7990     435582  6.929 25
"Maldives"    2016    79.872 79.146 80.814    3.7854   6.3383  8450     454252   6.12 25
"Maldives"    2017    79.943 79.102 81.058    6.8493   7.2099  9040     472442   5.87 25
"Maldives"    2018    80.013  79.21 81.074         .   8.1231  9700     489758  5.619 25
"Maldives"    2019    80.116 79.323 81.162      .565   7.0975 10160     504508   5.34 25
end
label values Country1 Country1
label def Country1 1 "Afghanistan", modify
label def Country1 2 "Armenia", modify
label def Country1 3 "Azerbaijan", modify
label def Country1 4 "Bahrain", modify
label def Country1 5 "Bangladesh", modify
label def Country1 6 "Bhutan", modify
label def Country1 7 "Brunei", modify
label def Country1 8 "Cambodia", modify
label def Country1 9 "China", modify
label def Country1 10 "Cyprus", modify
label def Country1 11 "Georgia", modify
label def Country1 12 "India", modify
label def Country1 13 "Indonesia", modify
label def Country1 14 "Iran", modify
label def Country1 15 "Iraq", modify
label def Country1 16 "Israel", modify
label def Country1 17 "Japan", modify
label def Country1 18 "Jordan", modify
label def Country1 19 "Kazakhstan", modify
label def Country1 20 "Kuwait", modify
label def Country1 21 "Kyrgyzstan", modify
label def Country1 22 "Lebanon", modify
label def Country1 23 "Macau", modify
label def Country1 24 "Malayasia", modify
label def Country1 25 "Maldives", modify

[Jared Greathouse]

Okay, sometime before bed, I'll take a look at this. My immediate diagnosis is that you have a unit named "St. Thomas/St. Something", and because of the way synth parameterizes the unit names, it needs to not have "St." in its name.

either way, I'll give this a look!!!

[anthony carmichael]

its always something simple like this. i changed the name to exclude st and the code ran thanks a lot!!!