1) When running the following command "xtpmg lntrade ldist lrgdp lrgdppc i.landl lareap i.contig i.island i.comlang_off i.col45 i.curcol i.colony i.pta_bb" stata returns the following output "factor variables not allowed"
2) When running the following command "xtpmg lntrade ldist lrgdp lrgdppc" stata returns the following output "too many values"
Is the problem in my cross section identifier? Note, each dyadic pair occurs twice every year i.e there are two observations of each pair in each year. If that is the problem then how do I solve this? I am including a sample of my dataset to make matters clearer. The dataset spans across 31 years and has 415,328 observations. Although running fixed effects and random effects had no issues, the pg estimate is not working. This is my first time using a pmg estimation so any help or input is much appreciated.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str45(icountry jcountry) float(npairid upairid) int year float(lntrade bureau corrup demo ethnic extern gov) byte(contig comcol col45 colony pta_bb) float(ldist lrgdp lrgdppc landl island lareap oecd1 oecd2 oecd0) "albania" "algeria" 1 1 1984 14.558823 9 6 8 8.32 20 32.8386 0 0 0 0 0 7.346155 46.08445 14.289328 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1985 13.877846 9 4 8 12 15 17.7489 0 0 0 0 0 7.346155 46.18159 14.334934 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1986 13.808212 9 4 8 12 13.26 15 0 0 0 0 0 7.346155 46.37711 14.481287 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1987 13.74879 9 4 8 9.375 12.4689 15.85 0 0 0 0 0 7.346155 46.41592 14.471378 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1988 12.789896 5.76 4 7.84 6 9 16.25 0 0 0 0 0 7.346155 46.27982 14.288767 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1989 12.29649 3 4 5 6 8 21.25 0 0 0 0 0 7.346155 46.31335 14.268803 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1990 11.722992 3 4.16 2.84 5.66 5 27.32 0 0 0 0 0 7.346155 46.3171 14.228973 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1991 15.62929 5.25 4 2.83 5.5 1.66 42.2136 0 0 0 0 0 7.346155 45.39926 13.292543 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1993 9.82476 9 6 9.24 2.67 0 48.4375 0 0 0 0 0 7.346155 45.56293 13.42245 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1997 10.99463 7.74 13.125 6.72 0 3.4736 5.88 0 0 0 0 0 7.346155 46.10817 13.917645 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 1999 11.714277 6 14.68 4.25 2.32 15.75 5.16 0 0 0 0 0 7.346155 46.56483 14.356722 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2001 10.845022 6 16.16 5.3582 3.87 5.1264 9.7282 0 0 0 0 0 7.346155 46.85801 14.63681 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2002 11.73914 5 18 8.16 4 2 10.26 0 0 0 0 0 7.346155 46.97813 14.748018 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2003 10.797527 4 18 8 4 1 11.0936 0 0 0 0 0 7.346155 47.3961 15.1587 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2004 9.917021 4 18 4.24 5.48 1 15.015 0 0 0 0 0 7.346155 47.90315 15.658278 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2005 11.32232 4 18.765 2.505 3.87 1.5 10.1218 0 0 0 0 0 7.346155 48.20861 15.9562 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2006 13.77471 4 22.5 1.5 3.75 2 8.47 0 0 0 0 . 7.346155 48.42078 16.160692 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2007 14.274847 4 22.5 2.19 3.75 1.96 10.4232 0 0 0 0 . 7.346155 48.72198 16.454134 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2008 14.42155 4 20.25 1.8486 3.75 1.5 12.75 0 0 0 0 . 7.346155 49.14398 16.868063 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2009 14.384567 4 20.25 2.37 3.75 1.7064 9.09 0 0 0 0 . 7.346155 48.85664 16.572227 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2010 14.611735 4 16.646399 2.5 3.75 2.25 10.2207 0 0 0 0 . 7.346155 49.00802 16.714731 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2011 14.585716 4 16 2.5 3.75 2.31 33.5257 0 0 0 0 . 7.346155 49.29671 16.99432 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2012 14.905403 4 16 2.5 3.75 2.805 38.4948 0 0 0 0 . 7.346155 49.27949 16.968061 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2013 15.75923 4 16 2.5 3.75 3.025 28.98 0 0 0 0 . 7.346155 49.35354 17.03348 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2014 15.809905 4 15.32 2.5 3.75 2.5 18.95 0 0 0 0 . 7.346155 49.39198 17.036558 0 0 24.949665 0 0 1 "albania" "algeria" 1 1 2015 15.326895 4 14 2.5 3.75 2.5 21.8089 0 0 0 0 . 7.346155 48.99703 16.624535 0 0 24.949665 0 0 1 "albania" "angola" 2 2 2003 8.382976 6 16 6 3 1.79 6.3675 0 0 0 0 0 8.64977 45.83106 14.354536 0 0 24.302334 0 0 1 "albania" "angola" 2 2 2005 6.76273 6 16.68 6.68 4.5 1 9.16 0 0 0 0 0 8.64977 46.91248 15.379225 0 0 24.302334 0 0 1 "albania" "angola" 2 2 2006 4.844187 6 20 4 4.5 1 8.295 0 0 0 0 . 8.64977 47.39102 15.831716 0 0 24.302334 0 0 1 "albania" "argentina" 4 3 1986 13.602937 6 4 4 0 13.26 31.25 0 0 0 0 0 9.364139 46.93193 14.767374 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 1987 9.952325 6 4 4 0 14.01 34.15 0 0 0 0 0 9.364139 46.92556 14.726276 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 1988 11.338584 6 4 4 0 13.5 38.75 0 0 0 0 0 9.364139 47.0387 14.805977 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 1989 14.586047 6 4 4 0 9.32 37.1 0 0 0 0 0 9.364139 46.63367 14.359762 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 1990 10.084145 6 4 4 0 3.325 50.6786 0 0 0 0 0 9.364139 47.1405 14.834566 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 1991 13.301944 6 4 5.66 0 0 55.0836 0 0 0 0 0 9.364139 46.82238 14.508765 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 1992 11.344814 6 5.5 6 0 0 43.6914 0 0 0 0 0 9.364139 46.53603 14.215097 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 1995 10.12993 6 6.51 3 0 0 28.89 0 0 0 0 0 9.364139 48.07698 15.736065 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 1996 10.6801 6 9.75 2.92 0 0 15.8911 0 0 0 0 0 9.364139 48.34764 16.000639 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2000 10.62762 3 12 1 0 5.8864 4.4589 0 0 0 0 0 9.364139 48.59269 16.225512 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2001 13.136889 3 12.32 1.46 0 3.8982 9.626599 0 0 0 0 0 9.364139 48.64065 16.271595 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2002 13.619822 2.5 15.84 3.06 0 3.16 20.01 0 0 0 0 0 9.364139 47.7564 15.38204 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2003 14.028334 2 14.32 3 0 2 14.6311 0 0 0 0 0 9.364139 48.23477 15.857175 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2004 14.416083 2 14 3 0 2.42 15.5694 0 0 0 0 0 9.364139 48.66778 16.287622 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2005 13.795407 2 14.595 2.505 0 2.12 15.8468 0 0 0 0 0 9.364139 48.97872 16.597021 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2006 12.603096 2 17.5 1.5 0 2 6.405 0 0 0 0 . 9.364139 49.23618 16.853983 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2007 14.320372 2 17.5 2.19 0 2.04 8.7668 0 0 0 0 . 9.364139 49.61524 17.233488 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2008 15.520298 2 15.75 1.755 0 2.5 20.5275 0 0 0 0 . 9.364139 50.00867 17.627872 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2009 15.513622 2 15.75 1.5 0 2.7 24.7248 0 0 0 0 . 9.364139 49.87132 17.491547 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2010 14.82473 2 14.28 1.5 0 3.75 29.8143 0 0 0 0 . 9.364139 50.06242 17.68355 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2011 15.14128 2 14 1.5 0 3.75 29.0598 0 0 0 0 . 9.364139 50.32692 17.948923 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2012 15.100785 2 15.32 1.67 0 3.75 29.3743 0 0 0 0 . 9.364139 50.36192 17.984985 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2013 15.599252 2 16 2 0 3.125 33.4236 0 0 0 0 . 9.364139 50.41883 18.043264 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2014 15.82362 2 15.32 2 0 2.5 25.2793 0 0 0 0 . 9.364139 50.30061 17.846334 0 0 25.09956 0 0 1 "albania" "argentina" 4 3 2015 15.524565 2 14 2 0 2.5 22.7429 0 0 0 0 . 9.364139 50.24848 17.785645 0 0 25.09956 0 0 1 "albania" "armenia" 7 4 2000 10.521022 9 16 2 1 10.2336 8.6775 0 0 0 0 0 7.642335 43.39917 13.516632 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2002 6.672033 7.5 18 4.08 .5 9.16 15 0 0 0 0 0 7.642335 43.80486 13.944066 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2003 5.624018 6 18 7 .5 4.5 10.4993 0 0 0 0 0 7.642335 44.21074 14.359395 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2005 6.833032 6 18.765 5.3607 .75 4.46 18.869598 0 0 0 0 0 7.642335 45.16129 15.330507 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2007 5.692047 6 22.5 3.9566 .75 4.04 13.9784 0 0 0 0 . 7.642335 46.03676 16.231794 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2008 12.289122 6 20.25 4.3875 .75 5.08 11.5175 0 0 0 0 . 7.642335 46.45865 16.667519 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2009 12.026546 6 20.25 3.5 .75 5.0868 11.4332 0 0 0 0 . 7.642335 46.09244 16.314192 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2010 8.463793 6 18.36 3.5 .75 5.43 19.0284 0 0 0 0 . 7.642335 46.15107 16.38402 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2011 10.574498 6 18 3.5 .75 7.38 29.3743 0 0 0 0 . 7.642335 46.31977 16.562126 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2012 10.365687 6 18 3.5 .75 7.5 29.6259 0 0 0 0 . 7.642335 46.25814 16.50865 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2013 10.751253 6 18 3.5 .75 6.25 20.3343 0 0 0 0 . 7.642335 46.35045 16.60851 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2014 10.89637 6 17.0818 3.5 .75 4.92 22.74 0 0 0 0 . 7.642335 46.48008 16.685873 1 0 20.568586 0 0 1 "albania" "armenia" 7 4 2015 10.85874 6 14 3.5 .75 5 32.0829 0 0 0 0 . 7.642335 46.23415 16.437666 1 0 20.568586 0 0 1 "albania" "australia" 11 5 1986 10.732458 0 2 0 4 8.84 27.9 0 0 0 0 0 9.629609 47.42717 15.916284 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1987 9.163925 0 2 0 3.75 9.34 28.75 0 0 0 0 0 9.629609 47.45742 15.911354 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1989 8.774309 0 2 0 3 8 25.4 0 0 0 0 0 9.629609 47.99663 16.371525 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1990 8.401831 0 2 0 2.83 5 37.0186 0 0 0 0 0 9.629609 47.92886 16.270966 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1991 7.895484 0 2 0 2 1.66 56.4564 0 0 0 0 0 9.629609 47.36263 15.698016 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1992 9.224203 0 2.75 0 .9514 1.67 44.3961 0 0 0 0 0 9.629609 46.88806 15.21738 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1993 9.867241 0 2 0 0 0 34.375 0 0 0 0 0 9.629609 47.39507 15.72071 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1995 10.230763 0 2.17 0 1 0 28.3764 0 0 0 0 0 9.629609 48.2403 16.55559 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1996 10.372408 0 3.25 0 .42 0 7.34 0 0 0 0 0 9.629609 48.54452 16.852888 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1997 12.27114 0 3.75 0 0 0 4.5864 0 0 0 0 0 9.629609 48.31008 16.613512 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1998 11.228368 0 3 0 0 .46 6.57 0 0 0 0 0 9.629609 48.43978 16.739086 0 1 26.121346 1 0 0 "albania" "australia" 11 5 1999 12.289185 0 3.67 0 1.3514 7.875 3.6636 0 0 0 0 0 9.629609 48.64316 16.937374 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2000 12.75427 0 4 0 2 4.16 2.8836 0 0 0 0 0 9.629609 48.7795 17.068161 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2001 13.691544 0 4.32 0 2 2.7768 7.7216 0 0 0 0 0 9.629609 48.79151 17.07479 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2002 13.783031 0 6 0 2.29 2.34 6 0 0 0 0 0 9.629609 48.91628 17.191504 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2003 15.492966 0 6 0 2.5 2.04 5.66 0 0 0 0 0 9.629609 49.32375 17.592474 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2004 13.07964 0 5.68 0 3.425 1.5 11.7348 0 0 0 0 0 9.629609 49.87484 18.138275 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2005 13.27037 0 4.17 0 3.75 1.62 8.9768 0 0 0 0 0 9.629609 50.11348 18.370993 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2006 13.12757 0 6.85 0 3.06 2.37 5.985 0 0 0 0 . 9.629609 50.27472 18.525766 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2007 13.856492 0 7.5 0 3 2.5 11.2716 0 0 0 0 . 9.629609 50.56615 18.820137 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2008 13.721595 0 6.75 0 3 2.5 6.545 0 0 0 0 . 9.629609 50.96364 19.207266 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2009 13.48691 0 6.75 0 3 2.2464 6.06 0 0 0 0 . 9.629609 50.7663 18.999062 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2010 13.47358 0 4.5696 0 3 3 16.6734 0 0 0 0 . 9.629609 50.96523 19.19206 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2011 14.610376 0 4 0 3 1.995 43.2123 0 0 0 0 . 9.629609 51.23872 19.461275 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2012 13.936567 0 5.32 0 3 1.5 42.7091 0 0 0 0 . 9.629609 51.29566 19.511 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2013 14.009276 0 6 0 3 1.25 25.5507 0 0 0 0 . 9.629609 51.35824 19.565895 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2014 14.084807 0 5.745 0 3 1 21.1482 0 0 0 0 . 9.629609 51.31079 19.46178 0 1 26.121346 1 0 0 "albania" "australia" 11 5 2015 13.852036 0 5.25 0 3 1 25.3114 0 0 0 0 . 9.629609 51.07979 19.218904 0 1 26.121346 1 0 0 "albania" "austria" 16 6 1984 15.69251 1.5 2 .84 0 0 19.1439 0 0 0 0 0 6.743869 46.31794 15.597626 1 0 21.6032 1 0 0 "albania" "austria" 16 6 1985 15.739594 1.5 2 4 0 0 26.2236 0 0 0 0 0 6.743869 46.3595 15.618155 1 0 21.6032 1 0 0 "albania" "austria" 16 6 1986 15.571526 1.5 2 4 2.68 0 24.15 0 0 0 0 0 6.743869 46.81606 16.054743 1 0 21.6032 1 0 0 "albania" "austria" 16 6 1987 15.826953 1.5 2 2.16 3.1125 0 15.85 0 0 0 0 0 6.743869 47.0343 16.252384 1 0 21.6032 1 0 0 "albania" "austria" 16 6 1988 16.015457 .63 2 .84 0 0 20 0 0 0 0 0 6.743869 47.09126 16.289059 1 0 21.6032 1 0 0 end
0 Response to Problems in running a pooled mean group estimation on a gravity dataset
Post a Comment