Hello all,
Can you help how I can export the regression coefficients and standard errors to excel?
I was using collect export command, but it gives me error could not write cell format halign() to file or could not write cell format border() to file. Similar to this problem.
Here is my code:
How can I do it with putexcel or other alternative command? Exporting the standard error by using putexcel doesn't seem to be straight forward and I am not sure how to loop several regression (changing the excel's cell target) when using putexcel. Thank you for your help.
Best regards,
Abdan
Can you help how I can export the regression coefficients and standard errors to excel?
I was using collect export command, but it gives me error could not write cell format halign() to file or could not write cell format border() to file. Similar to this problem.
Here is my code:
Code:
xtset ID year
collect clear
collect _r_b _r_se, tag(model[trade_gdp]): xtreg trade_gdp lag* lead* i.year if emde==1, fe
collect _r_b _r_se, tag(model[tb_gdp]): xtreg tb_gdp lag* lead* i.year if emde==1, fe
collect _r_b _r_se, tag(model[agri_gdp]): xtreg agri_gdp lag* lead* i.year if emde==1, fe
collect layout (model) (colname[lag5 lag4 lag3 lag2 lag1 lead0 lead1 lead2 lead3 lead4 lead5]#result result[N])
collect style header result[N], level(label)
collect export "${root}\output\5yrma\event_study_v2.xlsx", sheet(reg_output, replace) modify
Code:
* Example generated by -dataex-. For more info, type help dataex clear input long ID int year float(trade_gdp tb_gdp agri_gdp lag1 lag2 lag3 lag4 lag5 lead1 lead2 lead3 lead4 lead5 lead0 emde) 1 1980 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1981 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1982 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1983 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1984 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1985 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1986 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1987 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1988 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1989 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1990 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1991 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1992 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1993 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1994 . . . 0 0 0 0 0 0 0 0 0 0 0 0 1 1995 171.3621 -1.565144 .50592214 0 0 0 0 0 0 0 0 0 0 0 0 1 1996 175.34413 -2.0647774 .48582995 0 0 0 0 0 0 0 0 0 0 0 0 1 1997 168.7819 -3.7199125 .4299781 0 0 0 0 0 0 0 0 0 0 0 0 1 1998 163.26736 -3.991949 .4079168 0 0 0 0 0 0 0 0 0 0 0 0 1 1999 164.559 -4.701686 .3832685 0 0 0 0 0 0 0 0 0 0 0 0 1 2000 145.07288 3.6991425 .018607536 0 0 0 0 0 0 0 0 0 0 0 0 1 2001 140.39111 1.602459 .018617487 0 0 0 0 0 0 0 0 0 0 0 0 1 2002 133.23077 -4.1021442 .018053934 0 0 0 0 1 0 0 0 0 0 0 0 1 2003 132.7943 -7.331865 .018010583 0 0 0 1 0 0 0 0 0 0 0 0 1 2004 132.43094 -3.099813 .017566258 0 0 1 0 0 0 0 0 0 0 0 0 1 2005 145.05028 -8.899684 .017327778 0 1 0 0 0 0 0 0 0 0 0 0 1 2006 141.04263 -11.854321 .017507704 1 0 0 0 0 0 0 0 0 0 0 0 1 2007 139.97232 -9.849785 .017838597 0 0 0 0 0 0 0 0 0 0 1 0 1 2008 139.11015 -8.051559 .016997399 0 0 0 0 0 1 0 0 0 0 0 0 1 2009 137.55658 -11.71945 .019906854 0 0 0 0 0 0 1 0 0 0 0 0 1 2010 135.46466 -15.028282 .02049209 0 0 0 0 0 0 0 1 0 0 0 0 1 2011 154.4378 -14.935761 .0203949 0 0 0 0 0 0 0 0 1 0 0 0 1 2012 156.6452 -10.438106 .02146875 0 0 0 0 0 0 0 0 0 1 0 0 1 2013 161.8913 -8.794657 .01781746 0 0 0 0 0 0 0 0 0 0 1 0 1 2014 162.88205 -6.331065 .014812973 0 0 0 0 0 1 0 0 0 0 0 0 1 2015 145.83366 -.1278376 .012519788 0 0 0 0 0 0 1 0 0 0 0 0 1 2016 142.23976 1.4011066 .018611768 0 0 0 0 0 0 0 1 0 0 0 0 1 2017 143.80429 1.293084 .02391857 0 0 0 0 0 0 0 0 1 0 0 0 1 2018 145.21356 -.7080044 .02225303 0 0 0 0 0 0 0 0 0 1 0 0 1 2019 145.34357 1.1256104 .02757268 0 0 0 0 0 0 0 0 0 0 0 0 1 2020 124.16237 -13.508754 . 0 0 0 0 0 0 0 0 0 0 0 0 1 2021 139.90009 -1.7606694 . 0 0 0 0 0 0 0 0 0 0 0 0 1 2022 160.45926 5.789954 . 0 0 0 0 0 0 0 0 0 0 0 0 2 1980 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1981 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1982 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1983 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1984 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1985 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1986 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1987 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1988 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1989 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1990 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1991 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1992 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1993 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1994 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1995 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1996 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1997 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1998 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 1999 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 2000 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 2001 . . . 0 0 0 0 0 0 0 0 0 0 0 1 2 2002 . . 38.62789 0 0 0 0 0 0 0 0 0 0 0 1 2 2003 . . 37.418854 0 0 0 0 1 0 0 0 0 0 0 1 2 2004 . . 29.72107 0 0 0 1 0 0 0 0 0 0 0 1 2 2005 . . 31.114855 0 0 1 0 0 0 0 0 0 0 0 1 2 2006 . . 28.63597 0 1 0 0 0 0 0 0 0 0 0 1 2 2007 . . 30.10501 1 0 0 0 0 0 0 0 0 0 0 1 2 2008 . . 24.89227 0 0 0 0 0 0 0 0 0 0 1 1 2 2009 . . 29.2975 0 0 0 0 0 1 0 0 0 0 0 1 2 2010 . . 26.21007 0 0 0 0 0 0 1 0 0 0 0 1 2 2011 . . 23.743664 0 0 0 0 0 0 0 1 0 0 0 1 2 2012 . . 24.390873 0 0 0 0 0 0 0 0 1 0 0 1 2 2013 . . 22.810663 0 0 0 0 0 0 0 0 0 1 0 1 2 2014 . . 22.13704 1 0 0 0 0 0 0 0 0 0 0 1 2 2015 . . 20.634323 0 0 0 0 0 0 0 0 0 0 1 1 2 2016 . . 25.740314 0 0 0 0 0 1 0 0 0 0 0 1 2 2017 . . 26.4202 0 0 0 0 0 0 1 0 0 0 0 1 2 2018 . . 22.042896 0 0 0 0 0 0 0 1 0 0 0 1 2 2019 . . 25.77397 0 0 0 0 0 0 0 0 1 0 0 1 2 2020 46.7099 -25.86826 29.97558 0 0 0 0 0 0 0 0 0 1 0 1 2 2021 51.41172 -22.72741 33.59762 0 0 0 0 0 0 0 0 0 0 0 1 2 2022 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1980 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1981 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1982 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1983 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1984 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1985 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1986 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1987 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1988 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1989 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1990 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1991 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1992 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1993 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1994 . . . 0 0 0 0 0 0 0 0 0 0 0 1 3 1995 . . 6.653214 0 0 0 0 0 0 0 0 0 0 0 1 3 1996 . . 7.026869 0 0 0 0 0 0 0 0 0 0 0 1 3 1997 . . 9.002018 0 0 0 0 0 0 0 0 0 0 0 1 3 1998 . . 12.911182 0 0 0 0 0 0 0 0 0 0 0 1 3 1999 . . 6.290257 0 0 0 0 0 0 0 0 0 0 0 1 3 2000 . . 5.66469 0 0 0 0 0 0 0 0 0 0 0 1 3 2001 . . 8.156377 0 0 0 0 0 0 0 0 0 0 0 1 3 2002 105.30174 8.868249 5.83955 0 0 0 0 0 0 0 0 0 0 0 1 3 2003 103.90123 4.741448 6.198384 0 0 0 0 1 0 0 0 0 0 0 1 3 2004 103.57995 13.18077 6.250878 0 0 0 1 0 0 0 0 0 0 0 1 3 2005 106.59096 24.46157 5.060403 0 0 1 0 0 0 0 0 0 0 0 1 3 2006 94.62516 32.310566 5.19128 0 1 0 0 0 0 0 0 0 0 0 1 3 2007 108.06007 27.7515 5.242278 1 0 0 0 0 0 0 0 0 0 0 1 3 2008 121.3647 23.58535 4.805339 0 0 0 0 0 0 0 0 0 0 1 1 3 2009 122.44614 -4.931543 6.621197 0 0 0 0 0 1 0 0 0 0 0 1 3 2010 104.12364 18.962597 6.180294 0 0 0 0 0 0 1 0 0 0 0 1 3 2011 99.98251 21.35739 5.845681 0 0 0 0 0 0 0 1 0 0 0 1 3 2012 91.80009 20.080164 6.06963 0 0 0 0 0 0 0 0 1 0 0 1 3 2013 86.81194 14.68224 6.507493 0 0 0 0 0 0 0 0 0 1 0 1 3 2014 79.33292 10.057137 7.547057 0 0 0 0 0 0 0 0 0 0 0 1 3 2015 62.88852 -3.37932 9.122535 0 0 0 0 1 0 0 0 0 0 0 1 3 2016 53.37016 2.878813 9.831169 0 0 0 1 0 0 0 0 0 0 0 1 3 2017 52.25682 5.751382 10.016996 0 0 1 0 0 0 0 0 0 0 0 1 3 2018 66.37801 15.294566 8.607741 0 1 0 0 0 0 0 0 0 0 0 1 3 2019 57.82954 23.75197 7.882625 1 0 0 0 0 0 0 0 0 0 0 1 3 2020 65.94203 10.687053 9.946544 0 0 0 0 0 0 0 0 0 0 1 1 3 2021 74.4645 21.02605 11.486345 0 0 0 0 0 1 0 0 0 0 0 1 3 2022 68.1701 18.67575 13.64911 0 0 0 0 0 0 1 0 0 0 0 1 end
Best regards,
Abdan
Comment