Date:         Thu, 10 May 2001 15:20:26 -0400
Reply-To:     Ray Pass <raypass@ATT.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ray Pass <raypass@ATT.NET>
Subject:      Re: Oracle to SAS
In-Reply-To:  <200105101902.f4AJ2Tr65096@listserv.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"; format=flowed

Terry,

Do follow Chuck's advice, but as long as you've got V8 up and running, the
easiest way to access those Oracle tables by far is to use the new RDBMS
engine facility on the LIBNAME statement.  You'll need SAS/ACCESS Software
for Relational Databases - Oracle flavor up and running, but all you've got
to do is provide the proper credentials info (user id, password, etc) on
the LIBNAME statement, along with the ORACLE engine keyword, and you just
treat the Oracle tables like any other SAS data sets.  It really works like
a charm.  HTH.

Ray





At 03:02 PM 05/10/2001 -0400, Charles Patridge wrote:
>Terry,
>
>There are some good papers in the SUGI proceedings which should shed
>considerable light on your question -
>
>Go to
>On-Line SUGI Proceedings can be viewed at
>
>http://www.sas.com/usergroups/sugi/proceedings/index.html
>
>Find papers 110-26 and 10-26 from SUGI 26 proceedings.
>
>Also find "Version 7 Enhancements to SAS/Access System" (this maybe in
>proceedings 24 or 25) by Vino Gona
>
>These should help you to figure out how to read Oracle tables within SAS
>
>HTH,
>Charles Patridge
>Email: Charles_S_Patridge@prodigy.net

*------------------------------------------------*
| Ray Pass, Ph.D.         voice: (914) 693-5553  |
| Ray Pass Consulting      eFax: (914) 206-3780  |
| 5 Sinclair Place                               |
| Hartsdale, NY 10530    e-mail: raypass@att.net |
*------------------------------------------------*