Date: Fri, 25 Oct 2002 13:48:25 -0600
Reply-To: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject: Re: Libraries, ODBC, and Access database
Content-Type: text/plain; charset=US-ASCII
Open Database Connectivity (ODBC)
Two ODBC drivers are available under the SAS System under Windows, the
SAS ODBC Driver and the Universal ODBC Driver.
The SAS ODBC Driver is included in the base SAS System. It provides
read and write access to ODBC data for both local and remote (requires
SAS/SHARE and SAS/SHARE*NET) SAS servers to retrieve and update SAS
data. The SAS ODBC Driver allows the use of variables names up to
32-bytes as well as the use of name literals. For more information on
installing the SAS ODBC Driver, see the installation documentation for
the SAS System under Windows. For more information about configuring and
using the SAS ODBC Driver, see SAS ODBC Driver User's Guide and
The Universal ODBC Driver enables other applications to access SAS data
without requiring access to the SAS System. The Universal ODBC Driver
provides read-only access to ODBC data.
The Universal ODBC Driver is significant because it enables other
applications, such as Microsoft Excel, to directly access data stored in
SAS formats without requiring the SAS application software. For
organizations that store large amounts of SAS data on PC networks, this
driver opens up the server data to more applications than ever before.
The Universal ODBC Driver is sold separately and operates only on
Windows platforms. The driver provides access to the standard data
sources, including SAS data sets, CFO Vision financial databases (FDBs),
SAS multidimensional database (MDDB) files, and JMP files. This driver
also supports access to SAS data generated on other platforms, such as
UNIX and OpenVMS.
So the answer depends on what you mean by "use ODBC", and which version
of SAS you're using.
Manager, Technical Development
METRICS Department, First Health
West Sacramento, California USA
>>> Rocko <rockosanto@AOL.COM> 10/25/2002 12:21 PM >>>
What additional addons to SAS do i need to use ODBC?