SAS® ODBC Drivers
The SAS Drivers for ODBC are implementations of the ODBC interface standard that enable you to access, manipulate, and update SAS data sources from applications that are ODBC compliant. The SAS Drivers for ODBC connect from an ODBC-compliant application to SAS/SHARE servers, SAS Scalable Performance Data (SPD) Servers, or a local instance of a SAS ODBC server.
The SAS Drivers for ODBC are often used with productivity suites such as Microsoft Office. However, they can be used with any application that uses ODBC version 3.5 Core interface level functions.
Another ODBC-related product by SAS is SAS/ACCESS® Interface to ODBC. This SAS/ACCESS product enables SAS to act as an ODBC client and access data from third-party databases. For more information, see SAS/ACCESS software.
The most recent release is SAS ODBC Drivers 9.4.
64-Bit Driver for Windows x64
The December 2011 release of SAS 9.3 includes a 64-bit driver for Windows x64 operating environments. Now, 64-bit ODBC-compliant applications can use SAS Drivers for ODBC in native mode. The 64-bit driver does not support connections to the SAS® Scalable Performance Data (SPD) Server.
New DQUOTE=ANSI SQL Option
The DQUOTE=ANSI SQL option is new for SAS 9.3. When this option is enabled, values that are enclosed in double quotation marks are treated as variables by the SAS server that runs the query, rather than as a string. This option enables you to use DBMS names and other names that are not normally permissible in SAS as table names, column names, and aliases. This option appears on the General tab of the SAS ODBC Driver configuration dialog box.
Simplified Syntax for TCP/IP Communication
In previous releases of the SAS Drivers for ODBC, it was necessary to edit the TCP/IP services file for the client machine with a service name. The service name was used to define the server name, and the driver used the service name to look up the TCP/IP port number to use for communication with the SAS server. In SAS 9.3, a simplified syntax of two underscores and the port number are used for both local and SAS/SHARE server access. This enhancement avoids the need to edit the TCP/IP services file. However, the legacy behavior remains in the driver for sites that already have server names defined in the TCP/IP services file.
Free Online Documentation
- Most recent release for SAS ODBC Drivers
- All online documentation for supported releases of SAS ODBC Drivers [HTML]
- SAS ODBC Drivers titles in online bookstore [HTML]
SAS Publishing Representatives are available in the U.S. from 8-5 ET to answer your documentation questions. Contact us at 1-800-727-0025, option 4 or e-mail.
TrainingSAS currently does not offer public training for SAS ODBC Drivers. You may submit your requests for training using our Interest List.
Your input will be reviewed as we develop the course schedule throughout the year. From time to time, we are able to add course dates to our schedule based on your input.
Curriculum consultants are available in the U.S. from 9-5 EST. Contact us at 1-800-727-0025, option 4 or e-mail.
International customers, please contact your country office.
Online Support ResourcesThis page contains online support resources that are specific to this product. Visit the Support page to access various self-help and assisted-help resources or submit a problem through the SAS Technical Support form.
- Microsoft Access and Microsoft Excel fail to respond when you use these applications with the SAS 9.2 ODBC driver to export tables
- An error might occur when you use the SAS 9.2 ODBC driver to access SAS data sets from .NET or C# applications
- Rows cannot be edited or inserted when you use the SAS 9.2 ODBC Driver from an external tool
- An ODBC driver-manager error occurs when you use the SAS ODBC driver from the Oracle Business Intelligence Enterprise Edition
Integration with Microsoft Office CommunityShare your experiences, questions and ideas with other SAS Drivers for ODBC users.