Date:         Wed, 27 Oct 2010 15:08:55 -0400
Reply-To:     Suzanne McCoy <Suzanne.McCoy@CATALINAMARKETING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Suzanne McCoy <Suzanne.McCoy@CATALINAMARKETING.COM>
Subject:      Re: create Oracle table with SQL pass through
Comments: To: Phil Spence <linux70@COMCAST.NET>
In-Reply-To:  <201010271849.o9RH2bE7011095@willow.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

proc append is the fastest way to load a SAS dataset into a database table.


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Phil Spence
Sent: Wednesday, October 27, 2010 2:49 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: create Oracle table with SQL pass through

I have never used the SQL pass through facility in SAS. I have always used
the libname engine. That said, I need the correct syntax to create an Oracle
table from a work library using the SQL pass thru. Oddly, I have not been
able to find an example of this. Is the pass through a 'read-only' facility?