PROGRAMME FOR TABLES

[molugbode]

I have created some tables to store the output from my equations. I have used the freeze option so that I can extract the numbers I want from the table. However I have over 60 equations and therefore 60 tables, so extracting the numbers manually is painstakingly slow. For example from the table below, I would like to extract the c and it's corresponding prob, coefficients for ftallsh, boegbpr, uktbtnd, ukmbryd and their corresponding prob, adjusted r-squared, f-statistic and its prob and also the durbin-watson stat. Is it possible to use a programme for this and if not is there an alternative option? Many thanks in advance. p.s New to EVIEWS programming


Variable Coefficient Std. Error t-Statistic Prob.

C 0.0020 0.0009 2.1685 0.0304
FTALLSH 0.5424 0.0636 8.5225 0.0000
BOEGBPR(-1) -0.0018 0.0011 -1.7515 0.0802
UKTBTND(-1) 0.0761 0.0549 1.3855 0.1663
UKMBRYD(-1) -0.0011 0.0073 -0.1520 0.8792

R-squared 0.1461 Mean dependent var 0.0030
Adjusted R-squared 0.1422 S.D. dependent var 0.0283
S.E. of regression 0.0262 Akaike info criterion -4.4371
Sum squared resid 0.6061 Schwarz criterion -4.4101
Log likelihood 1968.4250 Hannan-Quinn criter. -4.4268
F-statistic 37.6426 Durbin-Watson stat 1.8425
Prob(F-statistic) 0.0000

[tchaithonov]

Hi there,

You can check the command reference with the keyword "equation". You should be able to find things such as <equation_name>.coef(i) for individual coefficients, dw for Durbin-Watson, etc. Use 1 "for" loop to generate the numbers and assign them to a table, as follows:

table tab_results
tab_results(1,1) = "R-squared"
tab_results(1,2) = <equation_name>.r2
...
table tab_coef
for !i = 1 to 5
tab_coef(!i,1) = <equation_name>.coef(!i)
next

That should do it ...

[molugbode]

Many thanks for your suggestion.