LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2007, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 8 Nov 2007 10:02:35 -0700
Reply-To:     Ken Barz <Ken.Barz@CPCMED.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ken Barz <Ken.Barz@CPCMED.ORG>
Subject:      Re: SQL newbie question
In-Reply-To:  A<OF8628688C.296A4517-ON8625738D.00543A0A-8625738D.0054B07D@fd9ns01.okladot.state.ok.us>
Content-Type: text/plain; charset="us-ascii"

It wants a semicolon after your where clause to separate the select statements.

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Masuod Pajoh Sent: Thursday, November 08, 2007 8:25 AM To: SAS-L@LISTSERV.UGA.EDU Subject: SQL newbie question

proc sql; create view PropItem as select * from pls.PROPITEM as prop where contid="070403" select item.idescr item.descrl from pls.ITEMLIST as item where prop.propitem=item.item ; quit;

returns: 136 proc sql; 137 select * 138 from pls.PROPITEM as prop 139 where contid="070403" 140 select item.idescr item.descrl - 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, INTERSECT, LE, LET, LT, LTT, NE, NET, OR, ORDER, UNION, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

What am I missing?


Back to: Top of message | Previous page | Main SAS-L page