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
Content-Type: text/plain; charset="us-ascii"
proc append is the fastest way to load a SAS dataset into a database table.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Phil Spence
Sent: Wednesday, October 27, 2010 2:49 PM
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?