- Title Page
- What's New in SAS/ACCESS 9.3 for Relational Databases
- Accessibility Features of SAS/ACCESS Interfaces
Concepts- Overview of SAS/ACCESS Interface to Relational Databases
- About This Document
- Methods for Accessing Relational Database Data
- Selecting a SAS/ACCESS Method
- SAS Views of DBMS Data
- Choosing Your Degree of Numeric Precision
- SAS Names and Support for DBMS Names
- Introduction to SAS/ACCESS Naming
- SAS Naming Conventions
- SAS/ACCESS Default Naming Behaviors
- Renaming DBMS Data
- Options That Affect SAS/ACCESS Naming Behavior
- Naming Behavior When Retrieving DBMS Data
- Naming Behavior When Creating DBMS Objects
- SAS/ACCESS Naming Examples
- DBMS-Specific Naming Conventions
- Data Integrity and Security
- Introduction to Data Integrity and Security
- DBMS Security
- SAS Security
- Potential Result Set Differences When Processing Null Data
- Performance Considerations
- Increasing Throughput of the SAS Server
- Limiting Retrieval
- Repeatedly Accessing Data
- Sorting DBMS Data
- Temporary Table Support for SAS/ACCESS
- Optimizing Your SQL Usage
- Overview: Optimizing Your SQL Usage
- Passing Functions to the DBMS Using PROC SQL
- Passing Joins to the DBMS
- Passing the DELETE Statement to Empty a Table
- When Passing Joins to the DBMS Will Fail
- Passing DISTINCT and UNION Processing to the DBMS
- Optimizing the Passing of WHERE Clauses to the DBMS
- Using the DBINDEX=, DBKEY=, and MULTI_DATASRC_OPT= Options
- Threaded Reads
- Overview: Threaded Reads in SAS/ACCESS
- Underlying Technology of Threaded Reads
- SAS/ACCESS Interfaces and Threaded Reads
- Scope of Threaded Reads
- Options That Affect Threaded Reads
- Generating Trace Information for Threaded Reads
- Performance Impact of Threaded Reads
- Autopartitioning Techniques in SAS/ACCESS
- Data Ordering in SAS/ACCESS
- Two-Pass Processing for SAS Threaded Applications
- When Threaded Reads Do Not Occur
- Summary of Threaded Reads
- How SAS/ACCESS Works
- Introduction to How SAS/ACCESS Works
- How the SAS/ACCESS LIBNAME Statement Works
- How the SQL Pass-Through Facility Works
- How the ACCESS Procedure Works
- How the DBLOAD Procedure Works
- In-Database Processing with SAS/ACCESS
- General Reference
- SAS/ACCESS Features by Host
- Introduction
- SAS/ACCESS Interface to Aster nCluster: Supported Features
- SAS/ACCESS Interface to DB2 under UNIX and PC Hosts: Supported Features
- SAS/ACCESS Interface to DB2 under z/OS: Supported Features
- SAS/ACCESS Interface to Greenplum: Supported Features
- SAS/ACCESS Interface to Hadoop: Supported Features
- SAS/ACCESS Interface to HP Neoview: Supported Features
- SAS/ACCESS Interface to Informix: Supported Features
- SAS/ACCESS Interface to Microsoft SQL Server: Supported Features
- SAS/ACCESS Interface to MySQL: Supported Features
- SAS/ACCESS Interface to Netezza: Supported Features
- SAS/ACCESS Interface to ODBC: Supported Features
- SAS/ACCESS Interface to OLE DB: Supported Features
- SAS/ACCESS Interface to Oracle: Supported Features
- SAS/ACCESS Interface to Sybase: Supported Features
- SAS/ACCESS Interface to Sybase IQ: Supported Features
- SAS/ACCESS Interface to Teradata: Supported Features
- The LIBNAME Statement for Relational Databases
- Overview: LIBNAME Statement for Relational Databases
- Assigning a Libref Interactively
- LIBNAME Statement Syntax for Relational Databases
- ACCESS= LIBNAME Option
- ADJUST_BYTE_SEMANTIC_COLUMN_LENGTHS= LIBNAME Option
- ADJUST_NCHAR_COLUMN_LENGTHS= LIBNAME Option
- AUTHDOMAIN= LIBNAME Option
- AUTHID= LIBNAME Option
- AUTOCOMMIT= LIBNAME Option
- BL_KEEPIDENTITY= LIBNAME Option
- BL_KEEPNULLS= LIBNAME Option
- BL_LOG= LIBNAME Option
- BL_NUM_ROW_SEPS= LIBNAME Option
- BL_OPTIONS= LIBNAME Option
- BL_PORT= LIBNAME Option
- BULKEXTRACT= LIBNAME Option
- BULKLOAD= LIBNAME Option
- BULKUNLOAD= LIBNAME Option
- CAST= LIBNAME Option
- CAST_OVERHEAD_MAXPERCENT= LIBNAME Option
- CELLPROP= LIBNAME Option
- CHAR_AS_NCHAR= LIBNAME Option
- COMMAND_TIMEOUT= LIBNAME Option
- CONNECTION= LIBNAME Option
- CONNECTION_GROUP= LIBNAME Option
- CONNECTION_TIMEOUT= LIBNAME Option
- CURSOR_TYPE= LIBNAME Option
- DB_LENGTH_SEMANTICS_BYTE= LIBNAME Option
- DB_OBJECTS= LIBNAME Option
- DBCLIENT_MAX_BYTES= LIBNAME Option
- DBCOMMIT= LIBNAME Option
- DBCONINIT= LIBNAME Option
- DBCONTERM= LIBNAME Option
- DBCREATE_TABLE_EXTERNAL= LIBNAME Option
- DBCREATE_TABLE_OPTS= LIBNAME Option
- DBGEN_NAME= LIBNAME Option
- DBINDEX= LIBNAME Option
- DBLIBINIT= LIBNAME Option
- DBLIBTERM= LIBNAME Option
- DBLINK= LIBNAME Option
- DBMAX_TEXT= LIBNAME Option
- DBMSTEMP= LIBNAME Option
- DBNULLKEYS= LIBNAME Option
- DBPROMPT= LIBNAME Option
- DBSASLABEL= LIBNAME Option
- DBSERVER_MAX_BYTES= LIBNAME Option
- DBSLICEPARM= LIBNAME Option
- DEFER= LIBNAME Option
- DEGREE= LIBNAME Option
- DELETE_MULT_ROWS= LIBNAME Option
- DIMENSION= LIBNAME Option
- DIRECT_EXE= LIBNAME Option
- DIRECT_SQL= LIBNAME Option
- ENABLE_BULK= LIBNAME Option
- ERRLIMIT= LIBNAME Option
- ESCAPE_BACKSLASH= LIBNAME Option
- FASTEXPORT= LIBNAME Option
- FETCH_IDENTITY= LIBNAME Option
- IGNORE_ READ_ONLY_COLUMNS= LIBNAME Option
- IN= LIBNAME Option
- INSERT_SQL= LIBNAME Option
- INSERTBUFF= LIBNAME Option
- INTERFACE= LIBNAME Option
- KEYSET_SIZE= LIBNAME Option
- LOCATION= LIBNAME Option
- LOCKTABLE= LIBNAME Option
- LOCKTIME= LIBNAME Option
- LOCKWAIT= LIBNAME Option
- LOGDB= LIBNAME Option
- LOGIN_TIMEOUT= LIBNAME Option
- MAX_CONNECTS= LIBNAME Option
- MODE= LIBNAME Option
- MULTI_DATASRC_OPT= LIBNAME Option
- MULTISTMT= LIBNAME Option
- OR_BINARY_DOUBLE= LIBNAME Option
- OR_ENABLE_INTERRUPT= LIBNAME Option
- OR_UPD_NOWHERE= LIBNAME Option
- PACKETSIZE= LIBNAME Option
- PARTITION_KEY= LIBNAME Option
- PREFETCH= LIBNAME Option
- PRESERVE_COL_NAMES= LIBNAME Option
- PRESERVE_TAB_NAMES= LIBNAME Option
- QUALIFIER= LIBNAME Option
- QUALIFY_ROWS= LIBNAME Option
- QUERY_BAND= LIBNAME Option
- QUERY_TIMEOUT= LIBNAME Option
- QUOTE_CHAR= LIBNAME Option
- QUOTED_IDENTIFIER= LIBNAME Option
- READBUFF= LIBNAME Option
- READ_ISOLATION_LEVEL= LIBNAME Option
- READ_LOCK_TYPE= LIBNAME Option
- READ_MODE_WAIT= LIBNAME Option
- REMOTE_DBTYPE= LIBNAME Option
- REREAD_EXPOSURE= LIBNAME Option
- RESULTS= LIBNAME Option
- SCHEMA= LIBNAME Option
- SESSIONS= LIBNAME Option
- SHOW_SYNONYMS= LIBNAME Option
- SLEEP= LIBNAME Option
- SPOOL= LIBNAME Option
- SQL_FUNCTIONS= LIBNAME Option
- SQL_FUNCTIONS_COPY= LIBNAME Option
- SQL_OJ_ANSI= LIBNAME Option
- SQLGENERATION= LIBNAME Option
- STRINGDATES= LIBNAME Option
- TEMPORAL_QUALIFIER= LIBNAME Option
- TENACITY= LIBNAME Option
- TPT= LIBNAME Option
- TR_ENABLE_INTERRUPT= LIBNAME Option
- TRACE= LIBNAME Option
- TRACEFILE= LIBNAME Option
- UPDATE_ISOLATION_LEVEL= LIBNAME Option
- UPDATE_LOCK_TYPE= LIBNAME Option
- UPDATE_MODE_WAIT= LIBNAME Option
- UPDATE_MULT_ROWS= LIBNAME Option
- UPDATE_SQL= LIBNAME Option
- UPDATEBUFF= LIBNAME Option
- USE_ODBC_CL= LIBNAME Option
- UTILCONN_TRANSIENT= LIBNAME Option
- Data Set Options for Relational Databases
- About the Data Set Options for Relational Databases
- AUTHID= Data Set Option
- AUTOCOMMIT= Data Set Option
- BL_ALLOW_READ_ACCESS= Data Set Option
- BL_ALLOW_WRITE_ACCESS= Data Set Option
- BL_BADDATA_FILE= Data Set Option
- BL_BADFILE= Data Set Option
- BL_CLIENT_DATAFILE= Data Set Option
- BL_CODEPAGE= Data Set Option
- BL_CONTROL= Data Set Option
- BL_COPY_LOCATION= Data Set Option
- BL_CPU_PARALLELISM= Data Set Option
- BL_DATA_BUFFER_SIZE= Data Set Option
- BL_DATAFILE= Data Set Option
- BL_DATAFILE= Data Set Option [Teradata only]
- BL_DB2CURSOR= Data Set Option
- BL_DB2DATACLAS= Data Set Option
- BL_DB2DEVT_PERM= Data Set Option
- BL_DB2DEVT_TEMP= Data Set Option
- BL_DB2DISC= Data Set Option
- BL_DB2ERR= Data Set Option
- BL_DB2IN= Data Set Option
- BL_DB2LDCT1= Data Set Option
- BL_DB2LDCT2= Data Set Option
- BL_DB2LDCT3= Data Set Option
- BL_DB2LDEXT= Data Set Option
- BL_DB2MGMTCLAS= Data Set Option
- BL_DB2MAP= Data Set Option
- BL_DB2PRINT= Data Set Option
- BL_DB2PRNLOG= Data Set Option
- BL_DB2REC= Data Set Option
- BL_DB2RECSP= Data Set Option
- BL_DB2RSTRT= Data Set Option
- BL_DB2SPC_PERM= Data Set Option
- BL_DB2SPC_TEMP= Data Set Option
- BL_DB2STORCLAS= Data Set Option
- BL_DB2TBLXST= Data Set Option
- BL_DB2UNITCOUNT= Data Set Option
- BL_DB2UTID= Data Set Option
- BL_DBNAME= Data Set Option
- BL_DEFAULT_DIR= Data Set Option
- BL_DELETE_DATAFILE= Data Set Option
- BL_DELETE_ONLY_DATAFILE= Data Set Option
- BL_DELIMITER= Data Set Option
- BL_DIRECT_PATH= Data Set Option
- BL_DISCARDFILE= Data Set Option
- BL_DISCARDS= Data Set Option
- BL_DISK_PARALLELISM= Data Set Option
- BL_ENCODING= Data Set Option
- BL_ERRORS= Data Set Option
- BL_ESCAPE= Data Set Option
- BL_EXECUTE_CMD= Data Set Option
- BL_EXECUTE_LOCATION= Data Set Option
- BL_EXCEPTION= Data Set Option
- BL_EXTERNAL_WEB= Data Set Option
- BL_FAILEDDATA= Data Set Option
- BL_FORCE_NOT_NULL= Data Set Option
- BL_FORMAT= Data Set Option
- BL_HEADER= Data Set Option
- BL_HOST= Data Set Option
- BL_HOSTNAME= Data Set Option
- BL_INDEX_OPTIONS= Data Set Option
- BL_INDEXING_MODE= Data Set Option
- BL_KEEPIDENTITY= Data Set Option
- BL_KEEPNULLS= Data Set Option
- BL_LOAD_METHOD= Data Set Option
- BL_LOAD_REPLACE= Data Set Option
- BL_LOCATION= Data Set Option
- BL_LOG= Data Set Option
- BL_METHOD= Data Set Option
- BL_NULL= Data Set Option
- BL_NUM_ROW_SEPS= Data Set Option
- BL_OPTIONS= Data Set Option
- BL_PARFILE= Data Set Option
- BL_PATH= Data Set Option
- BL_PORT= Data Set Option
- BL_PORT_MAX= Data Set Option
- BL_PORT_MIN= Data Set Option
- BL_PRESERVE_BLANKS= Data Set Option
- BL_PROTOCOL= Data Set Option
- BL_QUOTE= Data Set Option
- BL_RECOVERABLE= Data Set Option
- BL_REJECT_LIMIT= Data Set Option
- BL_REJECT_TYPE= Data Set Option
- BL_REMOTE_FILE= Data Set Option
- BL_RETRIES= Data Set Option
- BL_RETURN_WARNINGS_AS_ERRORS= Data Set Option
- BL_ROWSETSIZE= Data Set Option
- BL_SERVER_DATAFILE= Data Set Option
- BL_SQLLDR_PATH= Data Set Option
- BL_STREAMS= Data Set Option
- BL_SUPPRESS_NULLIF= Data Set Option
- BL_SYNCHRONOUS= Data Set Option
- BL_SYSTEM= Data Set Option
- BL_TENACITY= Data Set Option
- BL_TRIGGER= Data Set Option
- BL_TRUNCATE= Data Set Option
- BL_USE_PIPE= Data Set Option
- BL_WARNING_COUNT= Data Set Option
- BUFFERS= Data Set Option
- BULK_BUFFER= Data Set Option
- BULKEXTRACT= Data Set Option
- BULKLOAD= Data Set Option
- BULKUNLOAD= Data Set Option
- CAST= Data Set Option
- CAST_OVERHEAD_MAXPERCENT= Data Set Option
- COMMAND_TIMEOUT= Data Set Option
- CURSOR_TYPE= Data Set Option
- DB_ONE_CONNECT_PER_THREAD= Data Set Option
- DBCOMMIT= Data Set Option
- DBCONDITION= Data Set Option
- DBCONSTRAINT= Data Set Option
- DBCREATE_TABLE_EXTERNAL= Data Set Option
- DBCREATE_TABLE_LOCATION= Data Set Option
- DBCREATE_TABLE_OPTS= Data Set Option
- DBFORCE= Data Set Option
- DBGEN_NAME= Data Set Option
- DBINDEX= Data Set Option
- DBKEY= Data Set Option
- DBLABEL= Data Set Option
- DBLINK= Data Set Option
- DBMASTER= Data Set Option
- DBMAX_TEXT= Data Set Option
- DBNULL= Data Set Option
- DBNULLKEYS= Data Set Option
- DBPROMPT= Data Set Option
- DBSASLABEL= Data Set Option
- DBSASTYPE= Data Set Option
- DBSLICE= Data Set Option
- DBSLICEPARM= Data Set Option
- DBTYPE= Data Set Option
- DEGREE= Data Set Option
- DIMENSION= Data Set Option
- DISTRIBUTE_ON= Data Set Option
- DISTRIBUTED_BY= Data Set Option
- ERRLIMIT= Data Set Option
- ESCAPE_BACKSLASH= Data Set Option
- FETCH_IDENTITY= Data Set Option
- IGNORE_ READ_ONLY_COLUMNS= Data Set Option
- IN= Data Set Option
- INSERT_SQL= Data Set Option
- INSERTBUFF= Data Set Option
- KEYSET_SIZE= Data Set Option
- LOCATION= Data Set Option
- LOCKTABLE= Data Set Option
- MBUFSIZE= Data Set Option
- ML_CHECKPOINT= Data Set Option
- ML_ERROR1= Data Set Option
- ML_ERROR2= Data Set Option
- ML_LOG= Data Set Option
- ML_RESTART= Data Set Option
- ML_WORK= Data Set Option
- MULTILOAD= Data Set Option
- MULTISTMT= Data Set Option
- NULLCHAR= Data Set Option
- NULLCHARVAL= Data Set Option
- OR_PARTITION= Data Set Option
- OR_UPD_NOWHERE= Data Set Option
- ORHINTS= Data Set Option
- PARTITION_KEY= Data Set Option
- PRESERVE_COL_NAMES= Data Set Option
- QUALIFIER= Data Set Option
- QUERY_BAND= Data Set Option
- QUERY_TIMEOUT= Data Set Option
- READBUFF= Data Set Option
- READ_ISOLATION_LEVEL= Data Set Option
- READ_LOCK_TYPE= Data Set Option
- READ_MODE_WAIT= Data Set Option
- SASDATEFMT= Data Set Option
- SCHEMA= Data Set Option
- SEGMENT_NAME= Data Set Option
- SESSIONS= Data Set Option
- SET= Data Set Option
- SLEEP= Data Set Option
- TEMPORAL_QUALIFIER= Data Set Option
- TENACITY= Data Set Option
- TPT= Data Set Option
- TPT_APPL_PHASE= Data Set Option
- TPT_BUFFER_SIZE= Data Set Option
- TPT_CHECKPOINT_DATA= Data Set Option
- TPT_DATA_ENCRYPTION= Data Set Option
- TPT_ERROR_TABLE_1= Data Set Option
- TPT_ERROR_TABLE_2= Data Set Option
- TPT_LOG_TABLE= Data Set Option
- TPT_MAX_SESSIONS= Data Set Option
- TPT_MIN_SESSIONS= Data Set Option
- TPT_PACK= Data Set Option
- TPT_PACKMAXIMUM= Data Set Option
- TPT_RESTART= Data Set Option
- TPT_TRACE_LEVEL= Data Set Option
- TPT_TRACE_LEVEL_INF= Data Set Option
- TPT_TRACE_OUTPUT= Data Set Option
- TPT_WORK_TABLE= Data Set Option
- TRAP151= Data Set Option
- UPDATE_ISOLATION_LEVEL= Data Set Option
- UPDATE_LOCK_TYPE= Data Set Option
- UPDATE_MODE_WAIT= Data Set Option
- UPDATE_SQL= Data Set Option
- UPDATEBUFF= Data Set Option
- Macro Variables and System Options for Relational Databases
- Introduction to Macro Variables and System Options
- Macro Variables for Relational Databases
- System Options for Relational Databases
- DB2CATALOG= System Option
- DBFMTIGNORE= System Option
- DBIDIRECTEXEC= System Option
- DBSLICEPARM= System Option
- DBSRVTP= System Option
- SASTRACE= System Option
- SASTRACELOC= System Option
- SQLGENERATION= System Option
- SQLMAPPUTTO= System Option
- VALIDVARNAME= System Option
- The SQL Pass-Through Facility for Relational Databases
- DBMS-Specific Reference
- SAS/ACCESS Interface to Aster nCluster
- Introduction to SAS/ACCESS Interface to Aster nCluster
- LIBNAME Statement Specifics for Aster nCluster
- Data Set Options for Aster nCluster
- SQL Pass-Through Facility Specifics for Aster nCluster
- Autopartitioning Scheme for Aster nCluster
- Passing SAS Functions to Aster nCluster
- Passing Joins to Aster nCluster
- Bulk Loading for Aster nCluster
- Naming Conventions for Aster nCluster
- Data Types for Aster nCluster
- SAS/ACCESS Interface to DB2 for UNIX and PC Hosts
- Introduction to SAS/ACCESS Interface to DB2 under UNIX and PC Hosts
- LIBNAME Statement Specifics for DB2 under UNIX and PC Hosts
- Data Set Options for DB2 under UNIX and PC Hosts
- SQL Pass-Through Facility Specifics for DB2 under UNIX and PC Hosts
- Autopartitioning Scheme for DB2 under UNIX and PC Hosts
- Temporary Table Support for DB2 under UNIX and PC Hosts
- Calling Stored Procedures in DB2 under UNIX and PC Hosts
- DBLOAD Procedure Specifics for DB2 under UNIX and PC Hosts
- Passing SAS Functions to DB2 under UNIX and PC Hosts
- Passing Joins to DB2 under UNIX and PC Hosts
- Bulk Loading for DB2 under UNIX and PC Hosts
- Locking in the DB2 under UNIX and PC Hosts Interface
- Naming Conventions for DB2 under UNIX and PC Hosts
- Data Types for DB2 under UNIX and PC Hosts
- SAS/ACCESS Interface to DB2 for z/OS
- Introduction to SAS/ACCESS Interface to DB2 under z/OS
- LIBNAME Statement Specifics for DB2 under z/OS
- Data Set Options for DB2 under z/OS
- SQL Pass-Through Facility Specifics for DB2 under z/OS
- Autopartitioning Scheme for DB2 under z/OS
- Temporary Table Support for DB2 under z/OS
- Calling Stored Procedures in DB2 under z/OS
- ACCESS Procedure Specifics for DB2 under z/OS
- DBLOAD Procedure Specifics for DB2 under z/OS
- The DB2EXT Procedure
- The DB2UTIL Procedure
- Maximizing DB2 under z/OS Performance
- Passing SAS Functions to DB2 under z/OS
- Passing Joins to DB2 under z/OS
- SAS System Options, Settings, and Macros for DB2 under z/OS
- Bulk Loading for DB2 under z/OS
- Locking in the DB2 under z/OS Interface
- Naming Conventions for DB2 under z/OS
- Data Types for DB2 under z/OS
- Understanding DB2 under z/OS Client/Server Authorization
- DB2 under z/OS Information for the Database Administrator
- SAS/ACCESS Interface to Greenplum
- Introduction to SAS/ACCESS Interface to Greenplum
- LIBNAME Statement Specifics for Greenplum
- Data Set Options for Greenplum
- SQL Pass-Through Facility Specifics for Greenplum
- Autopartitioning Scheme for Greenplum
- Passing SAS Functions to Greenplum
- Passing Joins to Greenplum
- Bulk Loading for Greenplum
- Naming Conventions for Greenplum
- Data Types for Greenplum
- SAS/ACCESS Interface to Hadoop
- Introduction to SAS/ACCESS Interface to Hadoop
- LIBNAME Statement Specifics for Hadoop
- Data Set Options for Hadoop
- SQL Pass-Through Facility Specifics for Hadoop
- Passing SAS Functions to Hadoop
- Passing Joins to Hadoop
- Bulk Loading for Hadoop
- Naming Conventions for Hive
- Data Types for Hadoop
- Sample Code for Hadoop
- SAS/ACCESS Interface to HP Neoview
- Introduction to SAS/ACCESS Interface to HP Neoview
- LIBNAME Statement Specifics for HP Neoview
- Data Set Options for HP Neoview
- SQL Pass-Through Facility Specifics for HP Neoview
- Autopartitioning Scheme for HP Neoview
- Temporary Table Support for HP Neoview
- Passing SAS Functions to HP Neoview
- Passing Joins to HP Neoview
- Bulk Loading and Extracting for HP Neoview
- Naming Conventions for HP Neoview
- Data Types for HP Neoview
- SAS/ACCESS Interface to Informix
- Introduction to SAS/ACCESS Interface to Informix
- LIBNAME Statement Specifics for Informix
- Data Set Options for Informix
- SQL Pass-Through Facility Specifics for Informix
- Autopartitioning Scheme for Informix
- Temporary Table Support for Informix
- Passing SAS Functions to Informix
- Passing Joins to Informix
- Locking in the Informix Interface
- Naming Conventions for Informix
- Data Types for Informix
- Overview: Informix Servers
- SAS/ACCESS Interface to Microsoft SQL Server
- Introduction to SAS/ACCESS Interface to Microsoft SQL Server
- LIBNAME Statement Specifics for Microsoft SQL Server
- Data Set Options for Microsoft SQL Server
- SQL Pass-Through Facility Specifics for Microsoft SQL Server
- DBLOAD Procedure Specifics for Microsoft SQL Server
- Passing SAS Functions to Microsoft SQL Server
- Locking in the Microsoft SQL Server Interface
- Naming Conventions for Microsoft SQL Server
- Data Types for Microsoft SQL Server
- SAS/ACCESS Interface to MySQL
- Introduction to SAS/ACCESS Interface to MySQL
- LIBNAME Statement Specifics for MySQL
- Data Set Options for MySQL
- SQL Pass-Through Facility Specifics for MySQL
- Autocommit and Table Types
- Understanding MySQL Update and Delete Rules
- Passing SAS Functions to MySQL
- Passing Joins to MySQL
- Naming Conventions for MySQL
- Data Types for MySQL
- Case Sensitivity for MySQL
- SAS/ACCESS Interface to Netezza
- Introduction to SAS/ACCESS Interface to Netezza
- LIBNAME Statement Specifics for Netezza
- Data Set Options for Netezza
- SQL Pass-Through Facility Specifics for Netezza
- Temporary Table Support for Netezza
- Passing SAS Functions to Netezza
- Passing Joins to Netezza
- Bulk Loading and Unloading for Netezza
- Naming Conventions for Netezza
- Data Types for Netezza
- SAS/ACCESS Interface to ODBC
- Introduction to SAS/ACCESS Interface to ODBC
- LIBNAME Statement Specifics for ODBC
- Data Set Options for ODBC
- SQL Pass-Through Facility Specifics for ODBC
- Autopartitioning Scheme for ODBC
- DBLOAD Procedure Specifics for ODBC
- Temporary Table Support for ODBC
- Passing SAS Functions to ODBC
- Passing Joins to ODBC
- Bulk Loading for ODBC
- Locking in the ODBC Interface
- Naming Conventions for ODBC
- Data Types for ODBC
- SAS/ACCESS Interface to OLE DB
- Introduction to SAS/ACCESS Interface to OLE DB
- LIBNAME Statement Specifics for OLE DB
- Data Set Options for OLE DB
- SQL Pass-Through Facility Specifics for OLE DB
- Temporary Table Support for OLE DB
- Passing SAS Functions to OLE DB
- Passing Joins to OLE DB
- Bulk Loading for OLE DB
- Locking in the OLE DB Interface
- Accessing OLE DB for OLAP Data
- Naming Conventions for OLE DB
- Data Types for OLE DB
- SAS/ACCESS Interface to Oracle
- Introduction to SAS/ACCESS Interface to Oracle
- LIBNAME Statement Specifics for Oracle
- Data Set Options for Oracle
- SQL Pass-Through Facility Specifics for Oracle
- Autopartitioning Scheme for Oracle
- Temporary Table Support for Oracle
- ACCESS Procedure Specifics for Oracle
- DBLOAD Procedure Specifics for Oracle
- Maximizing Oracle Performance
- Passing SAS Functions to Oracle
- Passing Joins to Oracle
- Bulk Loading for Oracle
- Locking in the Oracle Interface
- Naming Conventions for Oracle
- Data Types for Oracle
- SAS/ACCESS Interface to Sybase
- Introduction to SAS/ACCESS Interface to Sybase
- LIBNAME Statement Specifics for Sybase
- Data Set Options for Sybase
- SQL Pass-Through Facility Specifics for Sybase
- Autopartitioning Scheme for Sybase
- Temporary Table Support for Sybase
- ACCESS Procedure Specifics for Sybase
- DBLOAD Procedure Specifics for Sybase
- Passing SAS Functions to Sybase
- Passing Joins to Sybase
- Bulk Loading for Sybase
- Reading Multiple Sybase Tables
- Locking in the Sybase Interface
- Naming Conventions for Sybase
- Data Types for Sybase
- Case Sensitivity in Sybase
- National Language Support for Sybase
- SAS/ACCESS Interface to Sybase IQ
- Introduction to SAS/ACCESS Interface to Sybase IQ
- LIBNAME Statement Specifics for Sybase IQ
- Data Set Options for Sybase IQ
- SQL Pass-Through Facility Specifics for Sybase IQ
- Autopartitioning Scheme for Sybase IQ
- Passing SAS Functions to Sybase IQ
- Passing Joins to Sybase IQ
- Bulk Loading for Sybase IQ
- Locking in the Sybase IQ Interface
- Naming Conventions for Sybase IQ
- Data Types for Sybase IQ
- SAS/ACCESS Interface to Teradata
- Introduction to SAS/ACCESS Interface to Teradata
- LIBNAME Statement Specifics for Teradata
- Data Set Options for Teradata
- SQL Pass-Through Facility Specifics for Teradata
- Autopartitioning Scheme for Teradata
- Temporary Table Support for Teradata
- Passing SAS Functions to Teradata
- Passing Joins to Teradata
- Maximizing Teradata Read Performance
- Maximizing Teradata Load Performance
- Teradata Processing Tips for SAS Users
- Locking in the Teradata Interface
- Naming Conventions for Teradata
- Data Types for Teradata
- Temporal Data Types for Teradata
- Sample Code
- Accessing DBMS Data with the LIBNAME Statement
- Overview: LIBNAME Statement Sample Code
- Examples: Create SAS Data Sets from DBMS Data
- Examples: Use the SQL Procedure with DBMS Data
- Examples: Use Other SAS Procedures with DBMS Data
- Example: Calculate Statistics from DBMS Data
- Example: Select and Combine DBMS Data
- Example: Join DBMS and SAS Data
- Accessing DBMS Data with the SQL Pass-Through Facility
- Overview: SQL Pass-Through Facility Sample Code
- Example: Retrieve DBMS Data with a Pass-Through Query
- Example: Combine an SQL View with a SAS Data Set
- Example: Use a Pass-Through Query in a Subquery
- Sample Data for SAS/ACCESS for Relational Databases
- Converting SAS/ACCESS Descriptors to PROC SQL Views
- Appendixes
- ACCESS Procedure
- Syntax: ACCESS Procedure
- PROC ACCESS
- Database Connection
- ASSIGN
- CREATE
- DROP
- FORMAT
- LIST
- QUIT
- RENAME
- RESET
- SELECT
- SUBSET
- TABLE=
- UNIQUE
- UPDATE
- Overview: ACCESS Procedure
- DBMS Specifics: ACCESS Procedure
- Using Descriptors with the ACCESS Procedure
- Examples: ACCESS Procedure
- DBLOAD Procedure
- Recommended Reading
- Glossary
| Product | Release |
|---|---|
| SAS/ACCESS Product of Choice | |
| SAS/ACCESS Interface to Aster nCluster | 9.3_M2 |
| SAS/ACCESS Interface to DB2 | 9.3_M2 |
| SAS/ACCESS Interface to Greenplum | 9.3 |
| SAS/ACCESS Interface to Hadoop | 9.3 |
| SAS/ACCESS Interface to Informix | 9.3 |
| SAS/ACCESS Interface to Microsoft SQL Server | 9.3_M2 |
| SAS/ACCESS Interface to MySQL | 9.3_M2 |
| SAS/ACCESS Interface to HP Neoview | 9.3 |
| SAS/ACCESS Interface to Netezza | 9.3 |
| SAS/ACCESS Interface to ODBC | 9.3_M2 |
| SAS/ACCESS Interface to OLE DB | 9.3_M2 |
| SAS/ACCESS Interface to Oracle | 9.3 |
| SAS/ACCESS Interface to Sybase | 9.3 |
| SAS/ACCESS Interface to Sybase IQ | 9.3 |
| SAS/ACCESS Interface to Teradata | 9.3_M2 |
- Type
- Usage and Reference
- Copyright Date
- August 2012
- Last Updated
- 15Sep2014