store results in tables

[shuchang]

I would like store results of multiple regressions into a table. Each column is one regression. In this column, the elements are [coef1, tstat of coef1, coef2, tstat of coef 2, ..., no. of observations, etc]. Ideally I also indicate the significance level of coeffients, eg, *** for 1% etc. In some other programmes, eg Stata, this can be easily done. In Eviews, do you have to write a fairly long programme to do this? If this is the case, are there some sample programmes?

Best,
Chang

[EViews Gareth]

http://forums.eviews.com/viewtopic.php?f=5&t=1638

[shuchang]

Hi Gareth, thanks for the reply.

It seems unfortunate that Eviews requires complicated programmes for storing certain output into a table. It is difficult if one has many regressions to report. For example, for I have below, I need a lot of programming to get the table. Anyway, this may be one area future Eviews versions can resolve.

Best, Chang

for %1 aud nzd hkd idr inr krw myr php sgd thb 'for the country loop

equation eq_usd.ls {%1}usd_d c eurusd_d jpyusd_d cnyusd_d cnhusd_d

next 'for the country loop

for %1 s_full s_pre2012 s_from2012 s_non_market s_market 'for the sample loop

smpl {%1}

for %2 asia 'for the different panel loop

p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnhusd_d
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d cnhusd_d
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d mp_dum
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnhusd_d mp_dum
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d cnhusd_d mp_dum
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d @movav(repo7d,5)
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnhusd_d @movav(repo7d,5)
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d cnhusd_d @movav(repo7d,5)
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d mp_dum 100*dlog(em_cdx) 100*dlog(oil)
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnhusd_d mp_dum 100*dlog(em_cdx) 100*dlog(oil)
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d cnhusd_d mp_dum 100*dlog(em_cdx) 100*dlog(oil)
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d @movav(repo7d,5) 100*dlog(em_cdx) 100*dlog(oil)
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnhusd_d @movav(repo7d,5) 100*dlog(em_cdx) 100*dlog(oil)
p_{%2}.ls(cx=f) ?usd_d c eurusd_d jpyusd_d cnyusd_d cnhusd_d @movav(repo7d,5) 100*dlog(em_cdx) 100*dlog(oil)

next 'for the different panel loop

next 'for the sample loop

[EViews Gareth]

You'd probably find the EqTabs Add-in useful too.

[shuchang]

Where can I find the EqTab add-in? Is it free?

[EViews Gareth]

Yes it is. You can download add-ins from the add-ins menu.

[shuchang]

Just saw this, and found it useful. Follow up questions though:

-What is the command for it? Inst

-Can it include panel equation result too? I could not get the panel estimate even using the menu?

-to use this function, it is better that I use the different names for the equations? Otherwise, it can only report the final set of regressions.

[EViews Gareth]

Documentation is available from the Manage Add-ins menu.

Yes, you should give your equations different names.

[shuchang]

It doesn't seem to be able to report estimation results from a pooled regression?

[EViews Gareth]

No. It should do panels though.

[shuchang]

Hi Gareth, many thanks.