|
Andrea,
Try putting the FROM clause before the WHERE clause.
Bob Abelson
HGSI
240 314 4400 x1374
bob_abelson@hgsi.com
"Wainwright, Andrea" <andrea.wainwright@CAPITALONE.COM>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
07/16/2004 09:41 AM
Please respond to "Wainwright, Andrea"
To: SAS-L@LISTSERV.UGA.EDU
cc:
Subject: What is wrong with my proc sql?
proc sql;
create table y.usm as
select varA,
varB,
RESIDENCE_ID
where substr(residence_id,13,1)='9'
_____
22
76
ERROR 22-322: Syntax error, expecting one of the following: a quoted
string,
!, !!, &, (, *, **, +, ',', -, '.', /, <, <=, <>, =,
>, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, FORMAT, FROM, GE,
GT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH,
LIKE, LT, NE, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
17 from data.mydata;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of
statements.
**************************************************************************
The information transmitted herewith is sensitive information intended
only
for use by the individual or entity to which it is addressed. If the
reader
of this message is not the intended recipient, you are hereby notified
that
any review, retransmission, dissemination, distribution, copying or other
use of, or taking of any action in reliance upon this information is
strictly prohibited. If you have received this communication in error,
please contact the sender and delete the material from your computer.
|
