Date:         Mon, 23 Feb 2009 18:57:10 -0500
Reply-To:     Phil Rack <PhilRack@MINEQUEST.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Phil Rack <PhilRack@MINEQUEST.COM>
Subject:      Re: SAS connect to Oracle
Comments: To: Paul Lambson <paullambson@GMAIL.COM>
In-Reply-To:  <4415f996-9e00-40ce-8958-25ef5a9efac5@33g2000yqm.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Paul,

You will need one of the SAS/Access products to connect and read Oracle
tables. There are three SAS products that can handle this for you. They are:
SAS/Access to ODBC, SAS/Access to Ole DB, and SAS Access to Oracle.

Fwiw, WPS has the ODBC interface as part of the base package and not an
extra charge.

Philip Rack
MineQuest, LLC
SAS & WPS Consulting and WPS Reseller
Tel: (614) 457-3714
Web: www.MineQuest.com
Blog: www.MineQuest.com/WordPress


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Paul
Lambson
Sent: 02/23/2009 6:42 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SAS connect to Oracle

Hello All,

I recently moved from a large company that had SAS with all the bells
and whistles. The new company is about to get SAS, they are planning
on getting SAS/BASE. I need to be sure that I will be able to access
Oracle databases with this product.

I am familliar with using the PROC SQL step and connecting to Oracle
(not ODBC). Will I be able to continue this practice with the stripped
down version of SAS?

Thanks,
Paul Lambson