Contents
About
Title Page
What's New in SAS 9.2 Drivers for ODBC
SAS ODBC Driver
Overview: SAS ODBC Driver
What Is ODBC?
What Is the SAS ODBC Driver?
Types of Data Accessed with the SAS ODBC Driver
Understanding SAS
What Software Do I Need?
Accessibility Features in the SAS ODBC Driver
Defining Your Data Sources
Introduction to Defining Data Sources
Accessing the SAS ODBC Driver Dialog Boxes
Setting Up a Connection to Local Data
Setting Up a Connection to SAS/SHARE Server
Setting Up a Connection to SPD Server
TCP/IP Services File
SQL Options on the General Tab
Using the General Tab
Using the Servers Tab
Using the Libraries Tab
Modifying a Data Source Definition
Specifying a Different Server for a Defined Data Source
Deleting a Data Source Definition
Using the SAS ODBC Driver
Introduction to Using the SAS ODBC Driver
Accessing Your Data Sources
Understanding Access to Local Data Sources
Understanding Access to SAS/SHARE Data Sources
Userid/Password Override
Using Data Sets That Have One-Level Names
Updating Attached Tables
Using SQL Statements to Access SAS Data Sources
Accessing the SAS Libraries MAPS, SASUSER, and SASHELP
Passwords
Programmer's Reference
Introduction to the Programmer's Reference
Support for and Implementation of ODBC Functions
Support for SQL Grammar
Supported Data Types
User-Specified SQL Options
Security Notes
SAS ODBC Driver Error Codes
Return Codes and Associated Messages
SAS ODBC Driver Return Codes
S1000 Communications Access Method Errors
TCP/IP Winsock Return Codes
Recommended Reading
Glossary
Product
Release
SAS Drivers for ODBC
9.2
Type
Usage and Reference
Copyright Date
May 2010
Last Updated
08Sep2010