Exporting estimated coefficients
Posted: Mon Jun 17, 2013 7:44 am
Hi,
I have a panel of country-level data and I estimate the regression (REG_YYY), let's say YYY = C(1) + C(2)*AAA + C(3)*BBB. I store the coefficients and dummy variables as vectors:
vector coefs_YYY = REG_YYY.@coefs
vector cx_YYY=REG_YYY.@effects
From the vectors themeselves it is not clear with which variables/countries are the coefficients associated. I would like to export the coefficients into excel/access in a table form, with countries in a row and coefficients as columns (see attached, sheet 1). Is there a way to do it?
The reason I am asking is that I plan to run a similar form of equation for various subsets of countries and I would like to obtain a big matrix with coefficients that can be easily used in excel (for example see attached, sheet 2).
Thank you
Lenka
I have a panel of country-level data and I estimate the regression (REG_YYY), let's say YYY = C(1) + C(2)*AAA + C(3)*BBB. I store the coefficients and dummy variables as vectors:
vector coefs_YYY = REG_YYY.@coefs
vector cx_YYY=REG_YYY.@effects
From the vectors themeselves it is not clear with which variables/countries are the coefficients associated. I would like to export the coefficients into excel/access in a table form, with countries in a row and coefficients as columns (see attached, sheet 1). Is there a way to do it?
The reason I am asking is that I plan to run a similar form of equation for various subsets of countries and I would like to obtain a big matrix with coefficients that can be easily used in excel (for example see attached, sheet 2).
Thank you
Lenka