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.