Page 1 of 1
exporting results derived from a program
Posted: Thu Feb 10, 2011 3:09 pm
by rbriceno
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
Re: exporting results derived from a program
Posted: Thu Feb 10, 2011 3:27 pm
by EViews Gareth
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.
Re: exporting results derived from a program
Posted: Fri Feb 11, 2011 8:33 am
by rbriceno
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.
Re: exporting results derived from a program
Posted: Fri Feb 11, 2011 8:53 am
by EViews Gareth
If you want statistics that are not part of the standard equation output, you'll have to freeze those into tables too. Something like:
Re: exporting results derived from a program
Posted: Tue Mar 01, 2011 9:18 am
by jose
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
Re: exporting results derived from a program
Posted: Tue Mar 01, 2011 9:30 am
by EViews Gareth
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:
Code: Select all
freeze(mytxt) y.X12
mytxt.save c:\temp\x12output.txt
Re: exporting results derived from a program
Posted: Wed Mar 02, 2011 1:31 pm
by jose
thanks I was doing that... hoped there was some other though
Thanks
Re: exporting results derived from a program
Posted: Wed Mar 02, 2011 2:16 pm
by jose
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
Re: exporting results derived from a program
Posted: Wed Mar 02, 2011 2:25 pm
by EViews Gareth
Try putting "do" at the start of the line with the command.