Compare coefficients across models for panel

[Olga Kanj]

I want to test the difference between the coeffiecients on " huaf "and " lauf " which are ratios of high uncertainty avoiding individuals in a group and low uncertainty avoiding individuals in the group, respectively.

xtreg risk huaf i.year ,re vce (cluster msacode)

xtreg risk lauf i.year ,re vce (cluster msacode)

How can this be done after xtreg and also if I want to use xtivreg when I will need to include instrumental variables?

Thank you,

[Clyde Schechter]

If I understand your data layout correctly and what you want, you can do this:

rename lauf luaf
reshape long @uaf, i(msacode year) j(hl) string
encode hl, gen(high_low)

xtreg risk i.hl##c.uaf i.year, re vce(cluster msacode)

The coefficient of 2.hl#uaf will be the difference between the huaf and lauf, and you will also see its standard error, t-statistic, etc., there.

Not tested, as you did not provide example data. I assume that msacode and year jointly uniquely identify observations in your data. (The code will not work if this is not the case--post back with more info in that case.)

Note the need for parallelism in the names for this code to work, hence the need to rename lauf as luaf to match huaf.

[Olga Kanj]

Thank you Clyde for the prompt reply.
I am getting the below error:

. xtreg assetrisk i.hl##c.uaf i.year, re vce(cluster msacode)

hl: string variables may not be used as factor variables

[Olga Kanj]

Here is an example of my data:
msacode year lua hua risk
PCB054 2014 .8571429 .1428571 0
PCB054 2015 .8571429 .1428571 0
PCB054 2016 .875 0 0
PCB054 2017 .875 0 .0042785
PCB071 2014 .8333333 .0833333 0
PCB071 2015 .8571429 .1428571 0
PCB071 2016 .875 .125 0
PCB071 2017 .875 .125 0
PCB076 2014 .8333333 .1666667 .2373842
PCB076 2015 .75 .125 0
PCB076 2016 .7777778 .1111111 0
PCB076 2017 .8571429 .1428571 .0068552
PCB084 2014 1 0 0
PCB084 2015 1 0 0
PCB084 2016 1 0 0
PCB084 2017 1 0 0
PCB090 2014 .6666667 0 .3170051
PCB090 2015 .6666667 0 .7237514
PCB090 2016 .6666667 0 .5049002
PCB090 2017 .6666667 0 .7823928
PCB091 2014 .2727273 .1818182 0
PCB091 2015 .2727273 .1818182 0
PCB091 2016 .2307692 .1538462 0
PCB098 2016 .7142857 0 0
PCB098 2017 .7142857 0 0
PCB234 2014 .75 .125 0
PCB234 2015 .8571429 0 0
PCB234 2016 .8571429 0 0
PCB246 2017 0 .625 0
PCC003 2016 .875 .125 .2046858
PCC003 2017 .875 .125 .2514844
PCC005 2014 .8888889 0 .3631293
PCC005 2015 .8888889 0 .384199
PCC005 2016 .8888889 0 .4087915
PCC005 2017 .875 0 .3472614
PCC006 2014 .8 .2 0
PCC006 2015 .8181818 .1818182 0
PCC006 2016 .9090909 .0909091 0
PCC008 2014 .5 .1666667 0
PCC008 2015 .375 .375 0
PCC008 2016 .5 .375 .0175896
PCC008 2017 .5555556 .3333333 0
PCC009 2014 .5714286 .2857143 0
PCC009 2015 .5714286 .2857143 0
PCC009 2016 .5714286 .2857143 0
PCC009 2017 .5714286 .2857143 0
PCC010 2014 .5 .1666667 0
PCC010 2015 .375 .375 0
PCC010 2016 .5 .375 .0466512
PCC010 2017 .5555556 .3333333 .0172443
PCC012 2014 .6666667 .1111111 .0481907
PCC012 2015 .8333333 .0833333 0
PCC012 2016 .8333333 .0833333 0
PCC012 2017 .8461539 .0769231 .0015522
PCC013 2014 .8181818 .0909091 .2215892
PCC013 2015 .8333333 .0833333 .2268549
PCC013 2016 .8333333 .0833333 0
PCC013 2017 .8333333 .0833333 .0015513
PCC014 2014 .8 .2 0
PCC014 2015 .8181818 .1818182 0
PCC014 2016 .9090909 .0909091 0
PCC014 2017 .9090909 .0909091 0
PCC016 2014 .7142857 .2857143 .1700266
PCC016 2015 .7142857 .2857143 .1547529
PCC016 2016 .5 .5 .1741953
PCC016 2017 .3846154 .5384616 .1920518
PCC018 2014 .875 0 1.02e-06
PCC018 2015 .875 0 0
PCC018 2016 .8571429 .1428571 .0012444
PCC018 2017 .75 .25 0
PCC023 2014 1 0 .3221585
PCC023 2015 1 0 .3018787
PCC023 2016 1 0 .2921582
PCC023 2017 1 0 .2845592
PCC024 2014 1 0 .4370919
PCC024 2015 1 0 .4045265
PCC024 2016 1 0 .3396709
PCC024 2017 1 0 .514199
PCC025 2014 .6818182 .1818182 .1756665
PCC025 2015 .6521739 .2173913 .1828359
PCC025 2016 .6086956 .2608696 .1696825
PCC025 2017 .6086956 .2173913 .1685626
PCC026 2014 .8571429 0 .1696613
PCC026 2015 .8571429 .1428571 .2038559
PCC026 2016 .7142857 .1428571 .0123327
PCC027 2014 .75 .25 .0968391
PCC027 2015 .75 .25 .1021402
PCC027 2016 .625 .25 .1325192
PCC027 2017 .625 .25 .1915268
PCC028 2014 .75 .125 .0032746
PCC028 2015 .75 .125 .0115096
PCC028 2016 .7777778 .1111111 .0121532
PCC028 2017 .8571429 .1428571 .0122213
PCC029 2014 .6666667 .3333333 .1282406
PCC029 2015 .7 .3 .1735694
PCC029 2016 .7272727 .2727273 .184269
PCC029 2017 .7272727 .2727273 .1805108
PCC030 2014 1 0 0
PCC030 2015 1 0 0
PCC030 2016 1 0 0
PCC030 2017 .8888889 0 0
PCC032 2014 1 0 .5382482
PCC032 2015 1 0 .4733086
PCC032 2016 1 0 .4716294
PCC032 2017 1 0 .5315339
PCC033 2014 .6666667 .3333333 .1312764
PCC033 2015 .7 .3 .1735496
PCC033 2016 .7 .3 .197352
PCC033 2017 .7272727 .2727273 .2084941
PCC034 2017 .75 0 0
PCC037 2014 1 0 .0033938
PCC037 2015 1 0 .0121047
PCC037 2016 1 0 .1288926
PCC037 2017 .8888889 0 .1286633
PCC038 2014 .7777778 .2222222 .0104014
PCC038 2015 .7777778 .2222222 .0055325
PCC038 2016 1 0 .0003622
PCC038 2017 .8888889 0 1
PCC040 2014 .6363636 .2727273 .3163952
PCC040 2015 .6 .3 .3086772
PCC040 2016 .6666667 .25 .2235864
PCC040 2017 .7272727 .1818182 .1834377
PCC041 2014 .625 .25 .3579331
PCC041 2015 .8571429 0 .3608384
PCC041 2016 .8571429 0 .3834491
PCC041 2017 .8333333 0 .3743853
PCC042 2014 .5714286 0 .0034732
PCC042 2015 .4285714 .1428571 .003328
PCC042 2016 .4285714 .1428571 .0022345
PCC042 2017 .4285714 .1428571 0
PCC043 2014 .6666667 .1111111 .194647
PCC043 2015 .8 0 .2351617
PCC043 2016 .8 0 .1797756
PCC043 2017 .8 0 .1323609
PCC044 2014 .8181818 .0909091 .2240008
PCC044 2015 .8333333 .0833333 .2284757
PCC044 2016 .8333333 .0833333 0
PCC044 2017 .8333333 .0833333 .0015525
PCC045 2014 .8181818 .0909091 .1608215
PCC045 2015 .8333333 .0833333 .1685626
PCC045 2016 .8333333 .0833333 .1167023
PCC045 2017 .8333333 .0833333 .0701528
PCC047 2014 .75 0 0
PCC047 2015 .7142857 0 0
PCC049 2015 .8333333 .0833333 .2353852
PCC049 2016 .8333333 .0833333 0
PCC049 2017 .8333333 .0833333 .0015504
PCC050 2014 .9 .1 .0797937
PCC050 2015 1 0 .0889249
PCC050 2016 1 0 0
PCC050 2017 .75 .125 .0343232
PCC055 2014 .75 .125 .0938176
PCC055 2015 .75 .125 .0823696
PCC055 2016 .7777778 .1111111 .0951886
PCC055 2017 .8571429 .1428571 .1062673
PCC056 2014 1 0 .4710349
PCC056 2015 1 0 .4633729
PCC057 2014 .6666667 .3333333 .1312764
PCC057 2015 .7 .3 .1735496
PCC057 2016 .7 .3 .197352
PCC057 2017 .7272727 .2727273 .2084941
PCC059 2014 .5714286 0 .0036319
PCC059 2015 .4285714 .1428571 .0033213
PCC059 2016 .4285714 .1428571 .0035772
PCC059 2017 .4285714 .1428571 0
PCC061 2014 .7777778 0 .1665712
PCC061 2015 .8333333 .0833333 .2104648
PCC061 2016 .8333333 .0833333 .3378279
PCC061 2017 .8333333 .0833333 .3999127
PCC063 2014 .75 .25 .0065091
PCC063 2015 .8571429 .1428571 .0031428
PCC063 2016 .875 .125 .0050818
PCC063 2017 .875 .125 .0043027
PCC064 2014 .8571429 .1428571 0
PCC064 2015 .8571429 .1428571 0
PCC064 2016 .7142857 .2857143 0
PCC064 2017 .7142857 .2857143 0
PCC065 2016 .875 .125 .2223392
PCC065 2017 .875 .125 .2862569
PCC066 2014 .75 .25 .1568463
PCC066 2015 .6923077 .3076923 .1180254
PCC066 2016 .5 .5 .1370964
PCC066 2017 .3846154 .5384616 .1493812
PCC067 2014 .6666667 .3333333 .1312736
PCC067 2015 .7 .3 .1735533
PCC067 2016 .7 .3 .1973484
PCC067 2017 .7272727 .2727273 .2084938
PCC068 2014 1 0 .289031
PCC071 2014 .5 .1666667 0
PCC071 2015 .375 .375 0
PCC071 2016 .5 .375 .0453812
PCC072 2014 .7777778 .2222222 0
PCC072 2015 .8 .2 0
PCC072 2016 .9090909 .0909091 0
PCC072 2017 .9090909 .0909091 0
PCC073 2014 .8 .2 .0000517
PCC073 2015 .8181818 .1818182 0
PCC073 2016 .9090909 .0909091 0
PCC073 2017 .9090909 .0909091 0
PCC074 2014 .875 0 0
PCC074 2015 .875 0 0
PCC074 2016 .875 0 0
PCC074 2017 .875 0 .0046434
PCC075 2014 .7142857 .1428571 .0420834
PCC075 2015 .5555556 .2222222 .0381574
PCC075 2016 .5555556 .2222222 0
PCC075 2017 .5555556 .2222222 .0053573
PCC076 2014 .5 .1666667 0
PCC076 2015 .375 .375 0
PCC076 2016 .5 .375 .0427302
PCC076 2017 .5555556 .3333333 .0413687
PCC077 2014 .7142857 0 .1644101
PCC077 2015 .5714286 .1428571 .1757416
PCC077 2016 .4285714 .2857143 .012334
PCC079 2014 1 0 0
PCC079 2015 1 0 0
PCC079 2016 1 0 0
PCC079 2017 .8888889 0 .7992976
PCC080 2014 .8181818 .0909091 .2259387
PCC080 2015 .8333333 .0833333 .2356994
PCC080 2016 .8333333 .0833333 0
PCC080 2017 .8333333 .0833333 .0015521
PCC081 2014 .8 .2 0
PCC081 2015 .8181818 .1818182 0
PCC081 2016 .9090909 .0909091 0
PCC082 2014 .7777778 .2222222 .0051645
PCC082 2015 .7777778 .2222222 0
PCC082 2016 .875 .125 0
PCC082 2017 .75 .25 0
PCC083 2014 .6666667 .3333333 .1312736
PCC083 2015 .7 .3 .1735533
PCC083 2016 .7 .3 .1973484
PCC083 2017 .7272727 .2727273 .2084938
PCC084 2014 .9 0 .1645051
PCC084 2015 .8181818 .0909091 .1685626
PCC084 2016 .7777778 .1111111 .1685626
PCC084 2017 .7272727 .1818182 .1685626
PCC085 2014 .8 .2 0
PCC085 2015 .8181818 .1818182 0
PCC085 2016 .9090909 .0909091 0
PCC085 2017 .9090909 .0909091 0
PCC087 2014 1 0 .5424242
PCC087 2015 1 0 .3621058
PCC087 2016 1 0 .3587233
PCC087 2017 1 0 .5125383
PCC088 2014 .75 .0625 .3571465
PCC088 2015 .75 .0625 .3511313
PCC088 2016 .75 .0625 .3589138
PCC088 2017 .75 .0625 .3376154
PCC111 2016 .875 .125 .2313805
PCC111 2017 .875 .125 .301259
PCC112 2014 1 0 0
PCC112 2015 1 0 0
PCC112 2016 1 0 0
PCC112 2017 .8888889 0 0
PCC137 2014 .6666667 .3333333 0
PCC137 2015 .875 .125 .0038906
PCC137 2016 .7 .3 0
PCC137 2017 .7272727 .2727273 0
PCC180 2014 .8571429 .1428571 .2187463
PCC180 2015 .8571429 .1428571 .2099133
PCC180 2016 .7142857 .1428571 .2313776
PCC180 2017 .8571429 0 .2356354
PCC184 2014 .7142857 .2857143 0
PCC184 2015 .7142857 .2857143 .094759
PCC184 2016 .5454546 .4545455 .1427289
PCC184 2017 .4166667 .5 .1416394
PCC190 2015 1 0 0
PCC190 2016 1 0 0
PCC193 2015 .875 .125 .2109849
PCC193 2016 .875 .125 .2289314
PCC193 2017 .875 .125 .2392685
PCP002 2014 .8181818 .0909091 .158334
PCP002 2015 .8333333 .0833333 .1664084
PCP002 2016 .8461539 .0769231 0
PCP002 2017 .8461539 .0769231 0
PCP006 2014 .6666667 .3333333 0
PCP006 2015 .6666667 .3333333 0
PCP006 2016 .5 .4166667 0
PCP006 2017 .4166667 .4166667 0
PCP007 2014 .6666667 .3333333 .1360207
PCP007 2015 .6666667 .3333333 .0537396
PCP007 2016 .5 .4166667 .0443894
PCP007 2017 .4615385 .3846154 .0365828
PCP012 2014 .3076923 .6153846 .0002473
PCP012 2015 .5 .4166667 .0017089
PCP012 2016 .5 .4166667 .0041417
PCP012 2017 .4615385 .4615385 .0058938
PCP013 2014 .3333333 .6666667 .033904
PCP013 2015 .4 .6 .041884
PCP013 2016 .4 .6 .0086662
PCP013 2017 .3636364 .6363636 .0096596
PCP015 2014 .6666667 0 0
PCP015 2015 .6666667 0 0
PCP015 2016 .6666667 0 0
PCP015 2017 .6666667 0 0
PCP026 2014 .7142857 .2857143 .1648945
PCP026 2015 .7142857 .2857143 .0889663
PCP026 2016 .5454546 .4545455 .0914585
PCP026 2017 .4615385 .4615385 .0985584
PCP028 2014 .7272727 .1818182 .0075709
PCP028 2015 .6923077 .2307692 .0583897
PCP028 2016 .8571429 .1428571 .0515346
PCP028 2017 .8461539 .1538462 .0059249
PCP031 2014 .6666667 .1666667 .2658707
PCP031 2015 .6666667 .1666667 .1991171
PCP031 2016 .6666667 .1666667 .2005095
PCP031 2017 .5 .1666667 .2123085
PCP034 2014 .5714286 .4285714 .1590443
PCP034 2015 .5714286 .4285714 .093286
PCP034 2016 .5714286 .4285714 .1005387
PCP034 2017 .625 .375 .0668733
PCP038 2014 1 0 0
PCP038 2015 1 0 0
PCP038 2016 1 0 0
PCP038 2017 .8888889 0 0
PCP040 2014 .5714286 .4285714 .1210568
PCP040 2015 .5714286 .4285714 .0791967
PCP040 2016 .5714286 .4285714 .0787196
PCP040 2017 .5714286 .4285714 .0568668
PCP046 2014 .7 0 .2314688
PCP046 2015 .7 0 .2753106
PCP046 2016 .75 0 .253632
PCP046 2017 .8 0 .0423056
PCP049 2014 .8333333 0 .1473027
PCP049 2015 .8333333 0 .1420134
PCP049 2016 .8333333 0 .1571237
PCP049 2017 .6666667 .0833333 .1462483
PCP051 2014 .9333333 0 .2262231
PCP051 2015 .9285714 0 .2363433
PCP051 2016 .9285714 0 .2266219
PCP051 2017 1 0 .2463319
PCP055 2014 .7142857 .2857143 0
PCP055 2015 .8571429 .1428571 0
PCP055 2016 .8571429 .1428571 0
PCP055 2017 .8571429 .1428571 0
PCP056 2014 .8333333 .0833333 .2408228
PCP056 2015 .8333333 .0833333 .2328255
PCP056 2016 .8333333 .0833333 .2412998
PCP056 2017 .8181818 .0909091 .1935414
PCP059 2015 1 0 .0024153
PCP059 2016 1 0 .0118173
PCP059 2017 .8888889 0 0
PCP060 2014 .8333333 0 0
PCP060 2015 .8181818 0 0
PCP060 2016 .8181818 0 0
PCP060 2017 .9166667 0 .014168
PCP063 2015 .6666667 .1666667 .3019357
PCP063 2016 .6666667 .1666667 .359309
PCP063 2017 .6666667 .1666667 .3768455
PCP065 2014 1 0 .1685626
PCP065 2015 .875 0 .1685626
PCP065 2016 .875 0 .1685626
PCP066 2014 1 0 .2279507
PCP066 2015 1 0 .1943453
PCP066 2016 1 0 .2167093
PCP066 2017 1 0 .2102
PCP067 2014 .3333333 .6666667 0
PCP067 2015 .4 .6 0
PCP067 2016 .4 .6 0
PCP067 2017 .3636364 .6363636 0
PCP068 2014 .6666667 .2666667 .1092095
PCP068 2015 .6666667 .2666667 .0639344
PCP068 2016 .5 .5 .1044844
PCP068 2017 .3846154 .5384616 .0675599
PCP074 2014 .625 0 .0706518
PCP074 2015 .625 0 .0550648
PCP074 2016 .75 0 .0502538
PCP074 2017 .8571429 0 .0165491
PCP095 2014 1 0 .1097098
PCP095 2015 1 0 .102743
PCP095 2016 1 0 .105964
PCP095 2017 1 0 .1595217
PCP100 2014 .8333333 .1666667 .2292307
PCP100 2015 .7692308 .2307692 .2205166
PCP100 2016 .7692308 .2307692 .186603
PCP100 2017 .7142857 .2857143 .1904004
PCP104 2014 .8571429 .1428571 .002204
PCP104 2015 .8571429 .1428571 .0479405
PCP104 2016 .8571429 .1428571 .0702384
PCP104 2017 .7142857 .2142857 .0139079
PCP106 2014 .4285714 0 .2863814
PCP106 2015 .4285714 0 .3005472
PCP106 2016 .4285714 0 .2923104
PCP106 2017 .4285714 0 .3294773
PCP107 2014 .5555556 .1111111 .3517971
PCP107 2015 .6666667 .1111111 .3675488
PCP107 2016 .6666667 .1111111 .2716503
PCP107 2017 .6666667 .1111111 .1737379
PCP108 2014 .5833333 .1666667 .1175314
PCP108 2015 .5714286 .2857143 .1390923
PCP108 2016 .4285714 .2857143 .0112431
PCP108 2017 .5454546 .2727273 .1125252
PCP112 2014 .7142857 .2857143 0
PCP112 2015 .8333333 .1666667 .6061426
PCP112 2016 .6666667 .3333333 .4084667
PCP112 2017 .6666667 .3333333 .4668394
PCP114 2014 .8 0 .1585002
PCP114 2015 .8 0 .1598416
PCP114 2016 .8666667 0 .1903798
PCP114 2017 .8461539 0 .1971027
PCP120 2014 .5 .1666667 .2569646
PCP122 2014 .6 .2 .0157109
PCP122 2015 .6 .2 .0128408
PCP122 2016 .8 0 .0086906
PCP122 2017 .8571429 0 .0114121
PCP123 2014 .6666667 .3333333 0
PCP123 2015 .6666667 .3333333 0
PCP123 2016 .5 .4166667 0
PCP123 2017 .4615385 .3846154 0
PCP128 2014 .3333333 .6666667 0
PCP128 2015 .3333333 .6666667 0
PCP128 2016 .8571429 .1428571 0
PCP128 2017 .8571429 .1428571 0
PCP162 2014 .8888889 .1111111 .2387569
PCP162 2015 .8888889 .1111111 .1652769
PCP162 2016 .8888889 .1111111 .1830857
PCP162 2017 .8888889 .1111111 .1297299
PCP174 2014 .75 0 .1001805
PCP174 2015 .75 0 .09797
PCP174 2016 .7777778 0 .0996946
PCP174 2017 .7142857 0 0
PCP187 2014 .375 .125 .1724507
PCP187 2015 .25 .125 .1654808
PCP187 2016 .25 .125 .2036879
PCP187 2017 .375 .125 .1959073
PCP230 2014 .6666667 .3333333 .1820289
PCP230 2015 .6666667 .3333333 .1105221
PCP230 2016 .5 .4166667 .1122049
PCP241 2015 .6 .2 .0836666
PCP241 2016 .5 .3333333 .0920192
PCP241 2017 .5 .3333333 .0856685
PCP242 2015 .7777778 .2222222 0
PCP242 2016 .7777778 .2222222 0
PCP242 2017 .7777778 .2222222 0


Thank you

[Clyde Schechter]

Thanks for the example data. My bad: I mean to use high_low, not hl, as the regression variable.

Anyway, given the actual data, it goes like this:

egen panel = group(msacode)

xtset panel year
reshape long @ua, i(msacode year) j(hl) string
encode hl, gen(high_low)

xtreg risk i.high_low##(c.ua i.year), re vce(cluster panel)

The results you want are in the regression table row for high_low#c.ua

[Olga Kanj]

Thank you , it works.