Page 1 of 1

store results in tables

Posted: Mon Oct 28, 2013 8:59 pm
by 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

Re: store results in tables

Posted: Mon Oct 28, 2013 9:22 pm
by EViews Gareth

Re: store results in tables

Posted: Mon Oct 28, 2013 11:51 pm
by 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

Re: store results in tables

Posted: Tue Oct 29, 2013 8:05 am
by EViews Gareth
You'd probably find the EqTabs Add-in useful too.

Re: store results in tables

Posted: Tue Oct 29, 2013 6:07 pm
by shuchang
Where can I find the EqTab add-in? Is it free?

Re: store results in tables

Posted: Tue Oct 29, 2013 6:42 pm
by EViews Gareth
Yes it is. You can download add-ins from the add-ins menu.

Re: store results in tables

Posted: Tue Oct 29, 2013 7:08 pm
by 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.

Re: store results in tables

Posted: Tue Oct 29, 2013 7:41 pm
by EViews Gareth
Documentation is available from the Manage Add-ins menu.

Yes, you should give your equations different names.

Re: store results in tables

Posted: Tue Oct 29, 2013 8:07 pm
by shuchang
It doesn't seem to be able to report estimation results from a pooled regression?

Re: store results in tables

Posted: Tue Oct 29, 2013 8:34 pm
by EViews Gareth
No. It should do panels though.

Re: store results in tables

Posted: Tue Oct 29, 2013 8:38 pm
by shuchang
Hi Gareth, many thanks.