Exporting estimated coefficients

[lenka]

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

[EViews Gareth]

You'd have to build a table up in EViews, using a combination of the tables you get from:

Code: Select all

freeze(tab1) reg_yyy.effects freeze(tab2) reg_yyy.stats