Date:         Wed, 27 Oct 2010 19:37:50 +0000
Reply-To:     F J Kelley <jkelley@UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         F J Kelley <jkelley@UGA.EDU>
Subject:      Re: create Oracle table with SQL pass through
In-Reply-To:  <4B7D94293459DE418D902EFAF874C4A7085E58535F@STPPEX.catmktg.com>
Content-Type: text/plain; charset="iso-8859-1"

a popular topic.  See also Lois Levin:
Methods of Storing SAS® Data into Oracle Tables
http://www2.sas.com/proceedings/sugi29/106-29.pdf

Also Dianne Louise Rhodes
Talking to Your RDBMS Using SAS/ACCESS®
http://www2.sas.com/proceedings/forum2007/239-2007.pdf

________________________________________
From: SAS(r) Discussion [SAS-L@LISTSERV.UGA.EDU] on behalf of Suzanne McCoy [Suzanne.McCoy@CATALINAMARKETING.COM]
Sent: Wednesday, October 27, 2010 3:11 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: [SAS-L] create Oracle table with SQL pass through

http://analytics.ncsu.edu/sesug/1999/087.pdf contains an example


-----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?