Date:         Thu, 28 Feb 2008 10:29:17 -0800
Reply-To:     "Duell, Bob" <BD9439@ATT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Duell, Bob" <BD9439@ATT.COM>
Subject:      Re: Weird error
Comments: To: Jane <program.sas@GMAIL.COM>
In-Reply-To:  A<200802271658.m1RGLR1Z017926@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Hi,

Here is a SAS Problem Note on this error, apparently caused by a
database column defined with a length of zero (which I've never heard of
before):

http://support.sas.com/kb/5/565.html

Apparently it will be fixed in 9.2.

Bob

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Jane
Sent: Wednesday, February 27, 2008 8:58 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Weird error

I read a data table from Oracle database

When I use the following code:

data test;
   set abc.have;
run;

Then SAS gave an error message:
ERROR: Invalid sequence of commands for file abc.have.DATA.

But when I use the following code:

proc sql;
    create table test as
    select *
    from abc.have;
quit;

Then everything is fine.

Does anyone have any idea about this error?

Thanks
Jane