Hello users of this list. I am starting to discover eviews programming capabilities. I have 8 eviews files where I recently ran the following stepwise program (one program that applies for all files, just changing the isin number each time):
'isin 169
wfopen "D:\data\isin169.wf1"
smpl if ano>=2009
equation eqSW.stepls(method=uni,btol=0.05,back) logliq c @ logsap l1liq l2liq l3liq l4liq l1sap l2sap l3sap l4sap liqmk pprom sem dv
wfsave "D:\data\isin169.wf1"
wfclose
What I would like to know is how can I extract the results of the final stepwise equation into a txt or xls file. I want to extract the variables, the coefficients, the p-values and the values for 3 tests: Jarque-Bera, White heteroskedasticity and Breusch-Godfrey for autocorrelation.
Thanks for your help
exporting results derived from a program
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13308
- Joined: Tue Sep 16, 2008 5:38 pm
Re: exporting results derived from a program
Code: Select all
freeze(mytable) eqSW.stats
mytable.save(t=rtf) d:\data\myoutput.rtf
There I chose rtf as the file format. You could also have CSV, TXT or HTML.
Follow us on Twitter @IHSEViews
Re: exporting results derived from a program
thanks Gareth, but I think that I need something like your post on "http://forums.eviews.com/viewtopic.php?f=15&t=1631". Since I'm starting to develop skills in eviews programming, where can I see the syntax that I need to use in order to include in the equation output table the values for Jarque-Bera and its p-value, Breusch-Godfrey (4 lags) and its p-value and White heteroskedasticity test and its p-value?
I tried applying the code lines you sent me on each of the the 8 individual files, but it seems like I have something wrong since I only got one table. I mention this, since my wish is to apply my program and get the summary table for all the 8 final models produced.
I tried applying the code lines you sent me on each of the the 8 individual files, but it seems like I have something wrong since I only got one table. I mention this, since my wish is to apply my program and get the summary table for all the 8 final models produced.
- Attachments
-
- stepwise1.prg
- program for stepwise
- (2.59 KiB) Downloaded 247 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13308
- Joined: Tue Sep 16, 2008 5:38 pm
Re: exporting results derived from a program
If you want statistics that are not part of the standard equation output, you'll have to freeze those into tables too. Something like:
Code: Select all
freeze(mytable2) eq.hettest
Follow us on Twitter @IHSEViews
Re: exporting results derived from a program
the info was very helpful... but i wonder if there's a way to extract results from a x12 ARIMA output..
the thing is I need to evaluate x12 forecast SE, upper and lower bands... I have the txt output but I need only the forecast part, it's very troublesome to extract that to an excel worksheet manually... please let me knoew if there's a way to do so.
thanks in advance
the thing is I need to evaluate x12 forecast SE, upper and lower bands... I have the txt output but I need only the forecast part, it's very troublesome to extract that to an excel worksheet manually... please let me knoew if there's a way to do so.
thanks in advance
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13308
- Joined: Tue Sep 16, 2008 5:38 pm
Re: exporting results derived from a program
Not easy.
The best thing you'll be able to do is freeze the X12 output text into a text object, then save that text object to disk as a text file, then see if Excel can make any sense out of the text file.
Something like:
The best thing you'll be able to do is freeze the X12 output text into a text object, then save that text object to disk as a text file, then see if Excel can make any sense out of the text file.
Something like:
Code: Select all
freeze(mytxt) y.X12
mytxt.save c:\temp\x12output.txt
Follow us on Twitter @IHSEViews
Re: exporting results derived from a program
thanks I was doing that... hoped there was some other though
Thanks
Thanks
Re: exporting results derived from a program
I got another question... i use the code to save the x12 output ina a txt file, but i use it en 20 series in a eviews workfile so everytime a run the program i got 20 new windows with the output... is there any way to disable this windows to appear???
thank in advance
thank in advance
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13308
- Joined: Tue Sep 16, 2008 5:38 pm
Re: exporting results derived from a program
Try putting "do" at the start of the line with the command.
Follow us on Twitter @IHSEViews
Who is online
Users browsing this forum: No registered users and 31 guests