EViews.com

Posted: **Sun Feb 23, 2014 9:10 pm**

Hello,

I am certain this is a trivial issue, but the infuriating thing is at one point in time I had this working. I am using eviews 8 and want to simply loop through a folder of .xlsx files > create regressions > output the results into a single text file.

The typical output from the regression is fine, I don't necessarily need to manipulate the results quite yet.

Code: Select all



 %filenames = @wdir(%PATH%)
cd %PATH%
%file = @word(%filenames,1)
pageload %file


output(t) out.txt

for !i=2 to @wcount(%filenames)

    %file = @word(%filenames, !i)
    import %file
	equation eq1
	eq1.ls revenue c01

next

Posted: **Sun Feb 23, 2014 9:39 pm**

Probably need the (p) option on the LS

Posted: **Mon Feb 24, 2014 3:33 pm**

You are correct, the (p) is the only thing that was wrong.

I have another question regarding this same snippet. On some of the files I am importing I am having matrix inversion issues, more specifically my matrices are singular in *some* instances. However it stops my loop, are there any mechanisms available to continue the loop without stopping entirely?

Thanks

Posted: **Mon Feb 24, 2014 3:59 pm**

I spoke too soon.

maximum error count!

Thank you for your time regardless

EViews.com

output(t) no results

output(t) no results

Re: output(t) no results

Re: output(t) no results

Re: output(t) no results