SAS ODBC Drivers

SAS® ODBC Drivers

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.

white marble texture

The most recent release is SAS ODBC Drivers 9.47. 

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.

Documentation

Find user's guides and other technical documentation for SAS® Drivers for ODBC

SAS 9.4 Drivers for ODBC: User's Guide 

Help for SAS 9.4 Drivers for ODBC is accessible within the product.
  

Previous Versions

SAS 9.3 Drivers for ODBC

  • What's New in SAS 9.3 HTML 
  • SAS 9.3 Drivers for ODBC: User's Guide, Second Edition PDF | HTML
  • Help for SAS 9.3 Drivers for ODBC is accessible within the product.

New Information

  • 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.

SAS 9.2 Drivers for ODBC

  • What's New in SAS 9.2 HTML
  • SAS 9.2 Drivers for ODBC: User's Guide, Second Edition PDF | HTML 
  • Help for SAS 9.2 Drivers for ODBC is accessible within the product.

SAS 9.1.3 Driver for ODBC

  • SAS ODBC Driver 9.1 User's Guide and Programmer's Reference PDF
  • Help for SAS ODBC Driver 9.1.3 is accessible within the product.

SAS 8 Driver for ODBC

  • SAS ODBC Driver User's Guide and Programmer's Reference SAS OnlineDoc.

Stay Connected

Be part of the SAS community. We offer a variety of ways for you to interact with users and experts.

SAS Community Denmark Grafik

Software Downloads

The downloads application contains updates for SAS products and solutions.

ODBC Drivers
white marble texture

Hot Fixes

Find quick solutions to problems or conduct routine system maintenance. SAS hot fixes have been tested and are fully supported.

SAS 9.4

SAS 9.2

Get Help

Search Knowledge Base

Start here to find answers quickly, without having to open a support track.

Ask SAS Community

Interact with other SAS users to ask questions and get answers.

Contact Technical Support

Get  technical support for your SAS software via our support track system.

Back to Top