------
log: K:\Germany to Colombia.log
opened on: 26 Jul 2006, 07:34:09
. *Dropping Germany
. drop if ccode==462680
(10 observations deleted)
.
.
. *Descriptive stats after dropping
. tabstat rimp immig gdp gdpau gdpdefnew gdpdfau pop popau xrate1 remote dist op
> en english gdpdfrationew white whitemg, stat(n mean sd median min max) col(sta
> t)
variable | N mean sd p50 min max
------+------
rimp | 1000 459028 1537051 7348 0 1.39e+07
immig | 1000 32334.04 116811.3 2790 0 1137050
gdp | 1000 2.54e+11 9.44e+11 1.63e+10 1.92e+08 8.99e+12
gdpau | 1000 3.83e+11 4.44e+10 3.80e+11 3.19e+11 4.52e+11
gdpdefnew | 1000 105.5381 16.85538 102.6185 60.87417 207.3465
gdpdfau | 1000 100.7173 4.633489 100.8223 94.42464 109.9797
pop | 1000 4.88e+07 1.54e+08 1.02e+07 41000 1.26e+09
popau | 1000 1.82e+07 612793.8 1.82e+07 1.73e+07 1.92e+07
xrate1 | 1000 1043.102 10901.71 16.2185 .0068 270182.6
remote | 1000 6776.165 4128.184 6797 1293 39620
dist | 1000 13343.22 3522.529 14215 2409 17972
open | 1000 .7101519 .3894421 .63885 .0671 3.2192
english | 1000 .38 .4856293 0 0 1
gdpdfratio~w | 1000 1.050904 .1806973 1.011523 .5844526 2.009028
white | 1000 .12 .3251241 0 0 1
whitemg | 1000 19373.58 116113.8 0 0 1137050
------
. sort white
. *IIIB. Descriptives Original Unites(sub sample for "white" and "non-white" cou
> ntries)--RHS Variables:
. by white: tabstat rimp immig gdp gdpau gdpdefnew gdpdfau pop popau xrate1 remo
> te dist phone open english gdpdfrationew white whitemg, stat(n mean sd median
> min max) col(stat)
------
-> white = 0
variable | N mean sd p50 min max
------+------
rimp | 880 400345.4 1589043 3126 0 1.39e+07
immig | 880 14727.79 27016.52 1505 0 158613
gdp | 880 2.35e+11 9.96e+11 1.05e+10 1.92e+08 8.99e+12
gdpau | 880 3.83e+11 4.44e+10 3.80e+11 3.19e+11 4.52e+11
gdpdefnew | 880 104.8121 17.21914 101.7094 60.87417 207.3465
gdpdfau | 880 100.7173 4.633806 100.8223 94.42464 109.9797
pop | 880 5.29e+07 1.64e+08 1.05e+07 41000 1.26e+09
popau | 880 1.82e+07 612835.6 1.82e+07 1.73e+07 1.92e+07
xrate1 | 880 1169.546 11615.77 21.6609 .0068 270182.6
remote | 880 7159.151 4093.339 6938.5 1293 39620
dist | 880 13201.9 3402.569 14045.5 2410 17972
phone | 880 157.5574 241.028 49.13 .54 1449.75
open | 880 .7155966 .4091255 .63385 .0671 3.2192
english | 880 .3863636 .4871925 0 0 1
gdpdfratio~w | 880 1.043893 .185446 1 .5844526 2.009028
white | 880 0 0 0 0 0
whitemg | 880 0 0 0 0 0
------
------
-> white = 1
variable | N mean sd p50 min max
------+------
rimp | 120 889367.1 984682.8 503533 40432 3843839
immig | 120 161446.5 300090.8 17525 2612 1137050
gdp | 120 3.96e+11 3.62e+11 2.40e+11 5.15e+10 1.31e+12
gdpau | 120 3.83e+11 4.46e+10 3.80e+11 3.19e+11 4.52e+11
gdpdefnew | 120 110.862 12.74583 111.5503 85.45601 141.4872
gdpdfau | 120 100.7173 4.65059 100.8223 94.42464 109.9797
pop | 120 1.86e+07 1.99e+07 8363820 3477200 5.87e+07
popau | 120 1.82e+07 615055.4 1.82e+07 1.73e+07 1.92e+07
xrate1 | 120 115.8531 304.1177 4.6693 .3774 1261.556
remote | 120 3967.6 3203.476 2831 1530 12501
dist | 120 14379.58 4173.487 15889 2409 17493
phone | 120 741.7883 272.3272 656.67 343.99 1487.08
open | 120 .6702242 .1871017 .6487 .3517 1.2967
english | 120 .3333333 .4733811 0 0 1
gdpdfratio~w | 120 1.102313 .1305911 1.090668 .8254872 1.441221
white | 120 1 0 1 1 1
whitemg | 120 161446.5 300090.8 17525 2612 1137050
------
.
.
. **Regression of Imports
. tsset ccode year
panel variable: ccode, 117100 to 725980
time variable: year, 1991 to 2000
.
. **I. Aggregate Imports
. xtgls lrimp limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 lremo
> te ldist lopen english white lwhitemg, igls panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 8282.47
Log likelihood = -554.8209 Prob > chi2 = 0.0000
------
lrimp | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3327465 .0312919 10.63 0.000 .2714154 .3940775
lgdp | 1.182934 .033066 35.77 0.000 1.118126 1.247742
lgdpau | -.1317221 .6157448 -0.21 0.831 -1.33856 1.075116
lgdpdfrati~w | -.7776466 .2513733 -3.09 0.002 -1.270329 -.2849639
lpopau | -1.920608 2.124052 -0.90 0.366 -6.083674 2.242457
lpop | .037519 .0457144 0.82 0.412 -.0520796 .1271176
lxrate1 | -.127036 .0169144 -7.51 0.000 -.1601876 -.0938844
lremote | -.4352979 .0839448 -5.19 0.000 -.5998266 -.2707692
ldist | -2.067544 .168646 -12.26 0.000 -2.398084 -1.737004
lopen | .2759141 .0558992 4.94 0.000 .1663536 .3854745
english | .8860449 .1258316 7.04 0.000 .6394195 1.13267
white | 4.602963 .5719066 8.05 0.000 3.482047 5.72388
lwhitemg | -.4284514 .0513391 -8.35 0.000 -.5290741 -.3278286
_cons | 37.13863 19.60168 1.89 0.058 -1.279961 75.55723
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .000979
lgdp | -.000307 .001093
lgdpau | -.000784 .001296 .379142
lgdpdfrati~w | -.000845 .000211 -.011562 .063189
lpopau | .001304 -.007885 -1.28084 .056946 4.5116
lpop | -.000264 -.000694 -.000036 .000192 -.000182 .00209
lxrate1 | .000115 .000144 .000386 .000244 -.002685 -.000178 .000286
lremote | .000263 .000196 -.000541 -.001602 -.003954 .000477 -.000065
ldist | .001345 .001099 .000575 -.000965 -.017595 .001129 .001444
lopen | -.000196 .000628 .002256 .000977 -.015926 .000404 .000136
english | -.001139 .002695 .002657 .002182 -.010224 -.00118 .000525
white | .004831 -.001944 .003392 -.011069 -.027726 .004282 .000555
lwhitemg | -.000616 .000189 -.000348 .001033 .003013 -.000222 -.000092
_cons | -.011417 .07023 11.2871 -.687451 -40.9295 -.025351 .018797
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .007047
ldist | .007007 .028441
lopen | .00156 .001196 .003125
english | -.002966 .003113 -.000718 .015834
white | -.001551 -.000688 -.00073 .001341 .327077
lwhitemg | .000436 -.000131 7.8e-06 .000069 -.028756 .002636
_cons | -.057758 -.110586 .161147 .046979 .328566 -.039586 384.226
.
. **II. Conservative Estimates
. *2.1. Aggregate reference priced Imports (conservative)
. xtgls lrrefp_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 l
> remote ldist lopen english white lwhitemg, igls panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 64459.46
Log likelihood = -951.8021 Prob > chi2 = 0.0000
------
lrrefp_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0521488 .0139987 3.73 0.000 .0247119 .0795858
lgdp | 1.596204 .0502208 31.78 0.000 1.497773 1.694635
lgdpau | .8660307 .3588132 2.41 0.016 .1627696 1.569292
lgdpdfrati~w | -.4286567 .1488839 -2.88 0.004 -.7204638 -.1368496
lpopau | -6.315588 1.211743 -5.21 0.000 -8.690561 -3.940616
lpop | -.3266555 .0823949 -3.96 0.000 -.4881467 -.1651644
lxrate1 | -.1215082 .0202955 -5.99 0.000 -.1612867 -.0817297
lremote | -.9757285 .0948629 -10.29 0.000 -1.161656 -.7898006
ldist | -3.25011 .1468656 -22.13 0.000 -3.537961 -2.962259
lopen | -.053507 .0267551 -2.00 0.046 -.105946 -.0010681
english | .9959083 .0858257 11.60 0.000 .8276931 1.164123
white | 4.780651 .7569694 6.32 0.000 3.297018 6.264284
lwhitemg | -.4710984 .0720879 -6.54 0.000 -.6123881 -.3298086
_cons | 95.20386 11.38695 8.36 0.000 72.88586 117.5219
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .000196
lgdp | -.000255 .002522
lgdpau | -.001248 .001779 .128747
lgdpdfrati~w | -.000601 .000562 -.011907 .022166
lpopau | .004931 -.007493 -.425671 .024288 1.46832
lpop | .000144 -.003897 -.00144 .000384 .004444 .006789
lxrate1 | -.000029 .000297 -.000028 .000408 -.003173 -.000334 .000412
lremote | .000419 .000244 -.006537 -.003224 .022917 -.000982 .000072
ldist | .000563 -.000831 -.00626 -.001864 .016832 .001113 .000497
lopen | .000044 -.000097 -.000979 .00091 .003608 .000256 -.000074
english | -.000432 .000325 .003195 .002596 -.020285 .000149 .001102
white | .001063 -.010656 -.011273 -.005886 .046281 .015109 -.000745
lwhitemg | -.000088 .000476 .000517 .000401 -.003168 -.000532 .000113
_cons | -.054829 .087135 3.80036 -.082203 -13.4911 -.055828 .044793
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .008999
ldist | .005017 .021569
lopen | .000631 .000218 .000716
english | -.002613 .001698 -.000405 .007366
white | .011159 -.037357 .00164 -.0033 .573003
lwhitemg | -.000391 .004659 -.000118 .000529 -.053013 .005197
_cons | -.325135 -.369753 -.04424 .244531 -.198505 -.005744 129.663
.
.
. *2.2. Aggregate Differentiated Imports (conservative)
. xtgls lrdiff_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 l
> remote ldist lopen english white lwhitemg, igls panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 7351.16
Log likelihood = -926.9327 Prob > chi2 = 0.0000
------
lrdiff_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .1131967 .0241466 4.69 0.000 .0658704 .1605231
lgdp | 1.717011 .0706798 24.29 0.000 1.578481 1.855541
lgdpau | .0847305 .5679206 0.15 0.881 -1.028373 1.197834
lgdpdfrati~w | -.3819091 .2247513 -1.70 0.089 -.8224135 .0585953
lpopau | -2.416423 1.975257 -1.22 0.221 -6.287856 1.45501
lpop | -.6266944 .0793735 -7.90 0.000 -.7822636 -.4711251
lxrate1 | -.1575128 .0277518 -5.68 0.000 -.2119054 -.1031201
lremote | -.3748912 .1294192 -2.90 0.004 -.6285481 -.1212344
ldist | -4.03898 .3477406 -11.61 0.000 -4.720539 -3.357421
lopen | .071149 .0437224 1.63 0.104 -.0145453 .1568432
english | 1.016623 .1424178 7.14 0.000 .7374897 1.295757
white | 9.479986 2.013262 4.71 0.000 5.534065 13.42591
lwhitemg | -.7992159 .2029283 -3.94 0.000 -1.196948 -.4014838
_cons | 54.88929 18.65839 2.94 0.003 18.31952 91.45905
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .000583
lgdp | -.000904 .004996
lgdpau | -.001964 .004907 .322534
lgdpdfrati~w | -.000888 .002054 -.018652 .050513
lpopau | .005291 -.023438 -1.09067 .063353 3.90164
lpop | .000631 -.004056 -.002828 -.001142 .011277 .0063
lxrate1 | .000031 .0005 .000285 .000955 -.005964 -.00074 .00077
lremote | -.000062 -.00093 -.006936 -.001605 .021385 -.001315 .000174
ldist | .002653 .007547 -.009318 -.002689 -.022344 -.001285 .001513
lopen | .000106 -.000624 .000154 .001734 -.000472 .00108 -.000209
english | -.001038 .003215 .006184 .003402 -.036315 .001458 .001964
white | .001334 -.029669 .006695 .002507 -.002935 .022072 .005305
lwhitemg | -.000119 .001539 -.002123 -.000687 .007482 -.001373 -.00056
_cons | -.0523 .149733 9.74456 -.600064 -35.8304 -.097291 .071623
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .016749
ldist | .006527 .120924
lopen | .000518 -.000747 .001912
english | -.005748 .004781 -.001468 .020283
white | .012392 -.148262 .002406 .018829 4.05322
lwhitemg | .000994 .011762 -.000116 -.00266 -.400522 .04118
_cons | -.340937 -.75951 .003191 .339215 1.44916 -.198332 348.135
.
. *2.3. Aggregate Homogenous Imports (conservative)
. xtgls lrhomo_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 l
> remote ldist lopen english white lwhitemg, panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 2243.72
Log likelihood = -1088.823 Prob > chi2 = 0.0000
------
lrhomo_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0842909 .0394979 2.13 0.033 .0068763 .1617054
lgdp | .9547099 .0809461 11.79 0.000 .7960585 1.113361
lgdpau | -.3637736 .9261303 -0.39 0.694 -2.178956 1.451408
lgdpdfrati~w | -.381555 .373736 -1.02 0.307 -1.114064 .3509541
lpopau | -.0752647 3.172454 -0.02 0.981 -6.29316 6.14263
lpop | -.0138151 .1020023 -0.14 0.892 -.2137359 .1861057
lxrate1 | -.1350057 .0331895 -4.07 0.000 -.200056 -.0699554
lremote | .5427779 .2467771 2.20 0.028 .0591037 1.026452
ldist | -1.801694 .3348227 -5.38 0.000 -2.457935 -1.145454
lopen | .3637819 .085975 4.23 0.000 .1952739 .5322898
english | 1.918455 .2499954 7.67 0.000 1.428473 2.408437
white | 2.288151 2.206121 1.04 0.300 -2.035766 6.612069
lwhitemg | .0467504 .1899784 0.25 0.806 -.3256004 .4191012
_cons | 4.765585 30.00959 0.16 0.874 -54.05212 63.58329
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .00156
lgdp | -.001488 .006552
lgdpau | -.001335 .000468 .857717
lgdpdfrati~w | -.000126 .001192 -.013076 .139679
lpopau | .001075 -.005364 -2.87378 .042791 10.0645
lpop | .000343 -.005985 .000927 -.000732 -.00431 .010404
lxrate1 | .000094 .000925 .000489 .002137 -.0075 -.00129 .001102
lremote | .001594 .000871 -.02897 -.016121 .090737 .000601 -.00093
ldist | .004077 -.006717 -.020751 -.007215 .065775 .010279 -.000556
lopen | .000256 -.00133 .006086 .003178 -.0324 .003581 -.000245
english | -.003493 .001044 .008493 .006139 -.013204 -.00136 .00168
white | .003168 -.020295 .0978 .003641 -.381303 .019298 .002438
lwhitemg | -.000436 .000386 -.010222 -.001923 .041939 .00005 -.000494
_cons | -.013945 .084769 25.618 -.318747 -92.894 -.082043 .118015
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .060899
ldist | .024561 .112106
lopen | .00208 -.001037 .007392
english | -.017629 .012359 -.002459 .062498
white | .048612 -.048182 .008642 .025054 4.86697
lwhitemg | -.00119 .008971 -.000544 -.001408 -.409116 .036092
_cons | -1.52644 -1.86164 .344859 .019803 3.91398 -.508025 900.575
.
. **III. Liberal Estimates
. *3.1. Aggregate reference priced Imports (liberal)
. xtgls lrrefp_lm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 l
> remote ldist lopen english white lwhitemg, igls panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 71325.96
Log likelihood = -884.7546 Prob > chi2 = 0.0000
------
lrrefp_lm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0246344 .0136442 1.81 0.071 -.0021078 .0513767
lgdp | 1.557314 .0513642 30.32 0.000 1.456642 1.657986
lgdpau | .6590435 .3730738 1.77 0.077 -.0721676 1.390255
lgdpdfrati~w | -.2326431 .1312271 -1.77 0.076 -.4898434 .0245572
lpopau | -6.53019 1.260384 -5.18 0.000 -9.000497 -4.059884
lpop | -.1725354 .0857822 -2.01 0.044 -.3406655 -.0044053