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?