Announcement

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

  • Commands for a panel regression model in quantiles

    Dear stata users,

    I have panel data for 32 countries for a period of 1990-2012 and I want to run a regression model in quantiles but I can't seem to find how to make a nice table with different quantiles.

    Do I have to do it seperately?

    Also, I am not sure how to choose the amount for noisy draws(#), burn (#) and rate(#)

    Code:
    ssc install qregpd
    ssc install moremata
    ssc install amcmc
    
    qregpd GHG ESPI, id(countryid) fix(Year) optimize(mcmc) noisy draws(1000) burn(100) arate(.5) 
    
    qregpd GHG ESPI EI UPmillion IP GDP EC POPmillion, id(countryid) fix(Year) optimize(mcmc) noisy draws(1000) burn(100) arate(.5)
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input str15 Country int Year double(ESPI GHG EI UPmillion IP GDP EC POPmillion) long ncountry float(countryid _ID)
    "Australia " 1990              .5 423672.225  44.9167  14.57 28.78445951123294  1.5   8527.22808539065  17.06 1 1 1
    "Australia " 1991              .5 423733.064     68.4  14.76 27.65531641271286   -1  8522.159222402222  17.28 1 1 1
    "Australia " 1992              .5 427426.084     76.5  14.92 26.86911360940594  2.6  8550.328665332952  17.47 1 1 1
    "Australia " 1993             .75 428337.072  86.0143  15.04 26.82286625035455  3.9   8701.76034414445  17.63 1 1 1
    "Australia " 1994              .5 428818.221   76.625  15.18 26.77993562185771  4.8   8812.48949873985   17.8 1 1 1
    "Australia " 1995              .5 437276.554     85.8  15.34 26.42979239529454    3  8994.355909694556     18 1 1 1
    "Australia " 1996 .45833331346512 443928.268    70.05  15.52 25.97628614017963    4  9108.295560045874  18.22 1 1 1
    "Australia " 1997 .45833331346512 456015.976  89.7727  15.67 25.21532313301226  4.6  9291.083868877247  18.42 1 1 1
    "Australia " 1998 .77083337306976 469751.524 110.0167  15.81 25.37913396123239  4.6  9783.442894554006   18.6 1 1 1
    "Australia " 1999 1.0208333730698 476391.987 128.0667  15.96 24.63264425275879  4.3 10036.457782944099  18.81 1 1 1
    "Australia " 2000 .97916662693024 487777.763 136.8583  16.13 24.59038689963459  3.1 10193.912180859395  19.02 1 1 1
    "Australia " 2001 1.0874999761581  495604.31 148.9286  16.32 23.67051961748905  2.7 10636.377685056406  19.27 1 1 1
    "Australia " 2002 1.2124999761581 499190.485 164.0302  16.55 23.63710478983667  4.2 10813.122729169423  19.49 1 1 1
    "Australia " 2003 1.2124999761581 500599.962 165.6262  16.78 24.05864101381914    3 10434.874393075786  19.72 1 1 1
    "Australia " 2004 1.1708333492279 517726.514 205.7655     17 23.95299949617499  4.1 10554.815823206176  19.93 1 1 1
    "Australia " 2005 1.5458333492279 524211.489 193.3786  17.25 24.64046187008498    3 10458.450193186498  20.17 1 1 1
    "Australia " 2006 2.0083332061768 528038.422 193.7667  17.53  25.6440072273035  2.6  10490.48454191005  20.45 1 1 1
    "Australia " 2007 2.0083332061768 534417.835 211.8373  17.66 25.69783659393408  4.4 10972.891739806795  20.82 1 1 1
    "Australia " 2008 2.2583332061768 537262.312 210.3056  18.04 25.62734551921512  2.6 10749.110554750296  21.24 1 1 1
    "Australia " 2009          2.6875 540381.618  224.875  18.45 27.06526464773401  1.9 10791.593097820825  21.69 1 1 1
    "Australia " 2010 2.5041666030884 535549.224 240.3083  18.76 25.20059745574729  2.4 10726.928183190168  22.03 1 1 1
    "Australia " 2011 3.3375000953674 537205.495 222.2082  19.05 26.53195081733665  2.8 10627.293865037926  22.34 1 1 1
    "Australia " 2012 3.7208333015442 539511.055 194.6298  19.41 26.39118178108606  3.8 10407.740307075934  22.73 1 1 1
    "Austria"    1990 1.1666666269302  78420.485    20.25   4.83 29.56086330327697  4.3  6111.476520119565   7.67 2 2 2
    "Austria"    1991 1.4166666269302  82082.332  32.0833   4.86 29.50525740592507  3.4 6347.2200963237265   7.75 2 2 2
    "Austria"    1992 1.4166666269302  75469.271    38.05   4.89 29.01589795022758  2.1  6227.498048964705   7.84 2 2 2
    "Austria"    1993 1.4791666269302  75709.189     32.4   4.91   28.303768907107   .5 6137.2694634319605    7.9 2 2 2
    "Austria"    1994 1.4791666269302  75958.303  38.1286   4.91 28.41340015562168  2.4  6205.804903606524   7.93 2 2 2
    "Austria"    1995          1.9375  79237.977  46.6214   4.89   28.851531988081  2.7  6344.393087408367   7.94 2 2 2
    "Austria"    1996          1.9375  82452.589  56.6571   4.88 28.75200886508271  2.4  6607.222977410402   7.95 2 2 2
    "Austria"    1997 1.8541667461395  82116.229  51.4738   4.86 28.67638393809025  2.1  6620.447861651314   7.96 2 2 2
    "Austria"    1998          1.9375   81432.85   48.225   4.84 28.51066285279893  3.6  6706.708676887404   7.97 2 2 2
    "Austria"    1999 1.8541667461395  79898.365  62.0694   4.83 28.42859215804046  3.6  6972.189816128575   7.99 2 2 2
    "Austria"    2000 2.0208332538605  80129.431  91.2246   4.82 28.28480203409559  3.4  7076.269483394382   8.01 2 2 2
    "Austria"    2001 2.2041666507721  84064.719   63.375   4.82 28.20874614352254  1.3 7333.2319526284355   8.04 2 2 2
    "Austria"    2002 2.2041666507721  85815.059  66.1345   4.82 27.38807848202851  1.7  7427.656445091207   8.08 2 2 2
    "Austria"    2003 2.4791665077209  91306.715  68.3706   4.82 27.49837985847299   .9  7695.080037082172   8.11 2 2 2
    "Austria"    2004 2.3958332538605  90985.234  83.7024   4.82 27.37376781661234  2.7  7808.157792139615   8.16 2 2 2
    "Austria"    2005 2.8583333492279  92147.286 101.1528   4.83 27.07424259676364  2.2  7977.681597417739   8.22 2 2 2
    "Austria"    2006 2.8166666030884  89728.782    125.9   4.83 27.25937083040775  3.5  8244.401951904792   8.26 2 2 2
    "Austria"    2007 2.4416666030884  86983.941 144.1036   4.83 27.57263882124377  3.7  8207.474738975541   8.29 2 2 2
    "Austria"    2008 2.9083333015442  86440.211 164.5017   4.82 26.96021414076454  1.5  8233.014832909852   8.32 2 2 2
    "Austria"    2009 3.3291666507721  79779.073 179.2839   4.81 25.79284582960618 -3.8  7944.796096231681   8.34 2 2 2
    "Austria"    2010 3.3291666507721  84336.718 231.4095    4.8 25.53499424663964  1.8  8382.711154453378   8.36 2 2 2
    "Austria"    2011 3.0791666507721  82127.026 235.4703   4.79 25.44743204320426  2.9   8425.16775320399   8.38 2 2 2
    "Austria"    2012 2.9458332061768   79432.38 217.1607   4.81  25.6339685320435   .7  8548.882199281114   8.42 2 2 2
    "Belgium"    1990 .66666668653488 145719.487      9.5    9.6             27.67  3.1   6380.31321975416   9.96 3 3 3
    "Belgium"    1991 .66666668653488 148439.217   7.3333   9.65             26.32  1.8  6655.414381108635     10 3 3 3
    "Belgium"    1992 .70833331346512 148039.147  10.1024   9.69             27.31  1.5  6850.663772535982  10.04 3 3 3
    "Belgium"    1993 .77083331346512 146897.392  20.4333   9.74              27.9   -1  6881.072143071405  10.08 3 3 3
    "Belgium"    1994 .77083331346512 151497.123  20.2524   9.78             26.87  3.2  7176.240506868448  10.11 3 3 3
    "Belgium"    1995 .77083331346512  153616.79  20.1714   9.81 26.04581424881384  2.4  7379.737079047839  10.13 3 3 3
    "Belgium"    1996 .77083331346512 157323.925  25.2833   9.83 25.81088642293447  1.3  7527.688544938645  10.15 3 3 3
    "Belgium"    1997 .77083331346512 148852.497  26.2667   9.86 26.10986539581395  3.8  7701.612130932906  10.18 3 3 3
    "Belgium"    1998 .77083331346512 154021.163  41.7214   9.89 25.57068537269188    2  7913.058580371592   10.2 3 3 3
    "Belgium"    1999 .77083331346512 147789.334  39.9091   9.92 24.72584434000419  3.5  7944.129807315738  10.22 3 3 3
    "Belgium"    2000 .85416668653488 148882.926  46.0561   9.95 24.94383258365434  3.7   8247.67711254725  10.25 3 3 3
    "Belgium"    2001 1.1041666269302 147324.612  61.2865   9.99  24.3121509872514  1.1   8267.18721595245  10.28 3 3 3
    "Belgium"    2002 1.2124999761581  147412.69   57.525  10.04 23.78733633930685  1.7  8311.892679466378  10.33 3 3 3
    "Belgium"    2003 1.1708333492279 147713.446  44.4135  10.09 23.22665488858116    1  8411.900657017408  10.37 3 3 3
    "Belgium"    2004 1.9833333492279 148554.793  66.9492  10.14 22.95999894885683  3.6  8576.223496534016  10.42 3 3 3
    "Belgium"    2005 2.4458332061768 145561.698     42.8   10.2  22.5737781481988  2.3   8509.99707308703  10.47 3 3 3
    "Belgium"    2006 2.4041666984558 142720.483  68.6702  10.27   22.139925542401  2.6  8683.671285001325  10.54 3 3 3
    "Belgium"    2007 2.2041666507721 139071.662  92.8651  10.36 22.28195247700286  3.7  8614.679503468007  10.62 3 3 3
    "Belgium"    2008 2.3375000953674 138980.223 110.0679  10.44 21.59544849635999   .4  8521.496739534265   10.7 3 3 3
    "Belgium"    2009 2.5750000476837 126325.022  124.729  10.53 20.60002978588795   -2  7903.955478876335  10.79 3 3 3
    "Belgium"    2010 2.5999999046326 133633.523 138.9119  10.63 20.89458035617658  2.9   8393.94962326946  10.89 3 3 3
    "Belgium"    2011 2.5333333015442 123134.282 110.8376  10.78 20.77789640495808  1.7   8028.79873139472  10.99 3 3 3
    "Belgium"    2012 2.4666666984558 120385.712 126.6294  10.85 20.07524055822403   .7   7988.52464388906  11.06 3 3 3
    "Brazil"     1990             .38  552640.82      3.5 110.14 33.27188339373328 -4.2 1460.7603291807945 148.93 4 4 4
    "Brazil"     1991             .38  574601.49   4.0595 113.26 31.76724560524832    1 1486.2246095987268 151.46 4 4 4
    "Brazil"     1992             .38  583848.35   6.1667 116.37 34.13226664222514  -.5 1494.0614762737737 153.97 4 4 4
    "Brazil"     1993             .38   596099.4      5.7 119.48 37.29912071752452  4.7 1537.5926385697906 156.45 4 4 4
    "Brazil"     1994             .38   613905.5        5  122.6 35.42091971797434  5.3 1566.7612313224267 158.91 4 4 4
    "Brazil"     1995 .41666665673256   638769.9     1.75 125.74 23.38146038673418  4.4  1634.398107753302 161.34 4 4 4
    "Brazil"     1996 .41666665673256  643708.82        2 128.89  22.3401145607793  2.2  1687.085238241386 163.76 4 4 4
    "Brazil"     1997 .41666665673256   668029.6        5 132.17 22.59414761182627  3.4  1762.410629386642 166.18 4 4 4
    "Brazil"     1998 .41666665673256  685872.35   6.8333 135.45 22.11879037946663   .3  1808.343154514132  168.6 4 4 4
    "Brazil"     1999 .41666665673256  702927.57    11.75  138.7  21.7467112496793   .5 1832.3783062536797 171.02 4 4 4
    "Brazil"     2000 .41666665673256  725162.14  11.3333 141.91 23.00661862936784  4.4 1897.3531483339018 173.76 4 4 4
    "Brazil"     2001 .54166668653488  744084.15  11.5833  144.5 22.63952791285491  1.4 1747.9396310022732  176.2 4 4 4
    "Brazil"     2002            .625   760963.1   9.8333    147 22.49532782107798  3.1  1806.669684308834 178.49 4 4 4
    "Brazil"     2003 .58333331346512  778785.71  24.5571 149.45 23.08381781832358  1.1  1882.264028335105  180.7 4 4 4
    "Brazil"     2004 .41666665673256  815887.21     25.5 151.84 24.30662329057763  5.8 1956.1593806705034 182.86 4 4 4
    "Brazil"     2005 .41666665673256  830176.87  28.4405 154.17 24.17257827800989  3.2 2015.7998694096725 184.99 4 4 4
    "Brazil"     2006 .41666665673256  837355.38  62.9881 156.44 23.54402166930009    4  2072.362680257292 187.06 4 4 4
    "Brazil"     2007 .41666665673256  843618.61  69.0833 158.66 23.12538040880208  6.1 2167.6065608535237 189.03 4 4 4
    "Brazil"     2008 .41666665673256  872592.78  65.2107 160.82 23.08529375354842  5.1  2229.845299151183 191.01 4 4 4
    "Brazil"     2009 .41666665673256  858585.47   52.875 162.94 21.87859262907793  -.1 2197.1255812775626 192.98 4 4 4
    "Brazil"     2010 .41666665673256   921055.1  76.4667 165.05 23.26797735474402  7.5  2374.116628367598 194.89 4 4 4
    "Brazil"     2011            .375  954163.29  72.9333 167.15 23.10205096355848    4  2430.803309818086  196.6 4 4 4
    "Brazil"     2012            .375  985944.61  67.7495 169.24 22.13364736767772  1.9  2501.474103025094 198.31 4 4 4
    "Canada "    1990            .375 601523.693  53.6667   21.2             27.98   .2 16167.374558604273  27.69 5 5 5
    "Canada "    1991            .375 595776.726  72.0333  21.48              27.9 -2.1 16181.588748180111  28.03 5 5 5
    "Canada "    1992 .70833331346512 613598.519     62.9  21.81             28.67   .9 16164.419040336024  28.37 5 5 5
    "Canada "    1993              .5 616798.394  78.3167  22.13             26.87  2.7 16320.127298240976  28.68 5 5 5
    "Canada "    1994              .5  638000.47  81.4333  22.45             27.54  4.5  16388.28050241472     29 5 5 5
    "Canada "    1995              .5 656298.717 101.3667  22.76             26.98  2.7 16532.382036352014   29.3 5 5 5
    "Canada "    1996 .45833331346512 678714.489 100.8833  23.08             26.65  1.6 16607.206336677427  29.61 5 5 5
    "Canada "    1997 .64583331346512 691195.367 123.6381  23.42 27.71643905854592  4.3  16653.67705447759   29.9 5 5 5
    end
    Thanks in advance!

  • #2
    You are not asking your question very well, OP.

    To get useful advice, show what you are doing now, and explain how the result that you obtain are not satisfactory to what you want to obtain.

    Comment

    Working...
    X