error message 7 is an illegal or reserved name

For questions regarding programming in the EViews programming language.

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

AnnH
Posts: 22
Joined: Fri Mar 09, 2012 11:42 am

error message 7 is an illegal or reserved name

Postby AnnH » Wed Mar 13, 2013 9:05 am

I get this error message:
Error: 7 is an illegal or reserved name in "READ(t=xls, c3, na=na, s=q) "C:\model\Sales\Stocks.xls" 7"

for this statement:
READ(t=xls, c3, na=na, s=q) "C:\model\Sales\Stocks.xls" 7

I'm having trouble figuring out what is wrong because previously in the program, I use this statement and it works ok:
READ(t=xls, b2, na=na) "C:\model\Sales\Output.xls" 61

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

Re: error message 7 is an illegal or reserved name

Postby EViews Gareth » Wed Mar 13, 2013 10:01 am

First comment is that you shouldn't be using the READ command :) You should use IMPORT instead.

However, to debug the READ command, could you provide the excel file?

AnnH
Posts: 22
Joined: Fri Mar 09, 2012 11:42 am

Re: error message 7 is an illegal or reserved name

Postby AnnH » Wed Mar 13, 2013 12:44 pm

figured out that I had a problem with how the N/A's were written i excel... once I fixed that it worked fine.

Will be switching over to import statements, thanks!


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 1 guest