exporting results derived from a program

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

rbriceno
Posts: 15
Joined: Wed Dec 08, 2010 1:46 pm

exporting results derived from a program

Postby rbriceno » Thu Feb 10, 2011 3:09 pm

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12295
Joined: Tue Sep 16, 2008 5:38 pm

Re: exporting results derived from a program

Postby EViews Gareth » Thu Feb 10, 2011 3:27 pm

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

rbriceno
Posts: 15
Joined: Wed Dec 08, 2010 1:46 pm

Re: exporting results derived from a program

Postby rbriceno » Fri Feb 11, 2011 8:33 am

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.
Attachments
stepwise1.prg
program for stepwise
(2.59 KiB) Downloaded 103 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12295
Joined: Tue Sep 16, 2008 5:38 pm

Re: exporting results derived from a program

Postby EViews Gareth » Fri Feb 11, 2011 8:53 am

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

jose
Posts: 3
Joined: Tue Mar 01, 2011 8:38 am

Re: exporting results derived from a program

Postby jose » Tue Mar 01, 2011 9:18 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12295
Joined: Tue Sep 16, 2008 5:38 pm

Re: exporting results derived from a program

Postby EViews Gareth » Tue Mar 01, 2011 9:30 am

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
Follow us on Twitter @IHSEViews

jose
Posts: 3
Joined: Tue Mar 01, 2011 8:38 am

Re: exporting results derived from a program

Postby jose » Wed Mar 02, 2011 1:31 pm

thanks I was doing that... hoped there was some other though

Thanks

jose
Posts: 3
Joined: Tue Mar 01, 2011 8:38 am

Re: exporting results derived from a program

Postby jose » Wed Mar 02, 2011 2:16 pm

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12295
Joined: Tue Sep 16, 2008 5:38 pm

Re: exporting results derived from a program

Postby EViews Gareth » Wed Mar 02, 2011 2:25 pm

Try putting "do" at the start of the line with the command.
Follow us on Twitter @IHSEViews


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 4 guests