Date:         Tue, 6 Dec 2005 13:46:45 -0500
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Data set names on SQL
Comments: To: Steve <stevelaba@yahoo.com>
Content-Type: text/plain; charset="us-ascii"

Steve:
SAS and SAS SQL do not recognize three level names (except in certain
SAS catalogs). Use an explicit and distinct alias.
 PROC SQL;
   CREATE TABLE WRK.INDIR5 AS
    SELECT T1.*,T2.*
    FROM WRK.INDIR4 AS T1 LEFT JOIN BID AS T2
      ON T1.ADJBIDID = T2.BIDIDHDR ;

Sig
-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Steve
Sent: Tuesday, December 06, 2005 1:34 PM
To: sas-l@uga.edu
Subject: Data set names on SQL


I used a lib name to help give me more space

 LIBNAME WRK 'E@.PANQ.BMCS074.SAS.TEMP' SPACE=(CYL,(5000,1000))
                DISP=(NEW,DELETE,DELETE) ;

but when I reference the file with SQL it says the name
WRK.INDIR4.ADJBIDID  is no good

PROC SQL;
   CREATE TABLE WRK.INDIR4 AS
    SELECT *
    FROM INDIR3 LEFT JOIN BID
      ON INDIR3.ADJBIDID = BID.BIDIDHDR ;


 PROC SQL;
   CREATE TABLE WRK.INDIR5 AS
    SELECT *
    FROM WRK.INDIR4 LEFT JOIN BID
      ON WRK.INDIR4.ADJBIDID = BID.BIDIDHDR ;

I'm on the mainframe sas 8.2

Thanks