SAS/ACCESS(R) 9.2 for Relational Databases: Reference, Second Edition
- What's New in SAS/ACCESS 9.2 for Relational Databases
Concepts- Overview of the 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
- 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 of 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 of 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
- General Reference
- SAS/ACCESS Features by Host
- Introduction
- 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 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 of the LIBNAME Statement for Relational Databases
- Assigning a Libref Interactively
- LIBNAME Statement Syntax for Relational Databases
- DBMS Interface Specifics for the LIBNAME Statement
- LIBNAME Options 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_OPTIONS= LIBNAME Option
- BULKEXTRACT= LIBNAME Option
- BULKLOAD= LIBNAME Option
- BULKUNLOAD= LIBNAME Option
- CAST= LIBNAME Option
- CAST_OVERHEAD_MAXPERCENT= LIBNAME Option
- CELLPROP= 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
- DBCLIENT_MAX_BYTES= LIBNAME Option
- DBCOMMIT= LIBNAME Option
- DBCONINIT= LIBNAME Option
- DBCONTERM= 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
- 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_ENABLE_INTERRUPT= LIBNAME Option
- OR_UPD_NOWHERE= LIBNAME Option
- PACKETSIZE= 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
- SCHEMA= LIBNAME Option
- SESSIONS= LIBNAME Option
- SHOW_SYNONYMS= 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
- TPT= 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_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_OPTIONS= Data Set Option
- BL_PARFILE= 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
- DBCOMMIT= Data Set Option
- DBCONDITION= 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
- DISTRIBUTED_BY= Data Set Option
- DISTRIBUTE_ON= 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
- PRESERVE_COL_NAMES= Data Set Option
- QUALIFIER= Data Set Option
- QUERY_BAND= Data Set Option
- QUERY_TIMEOUT= Data Set Option
- READ_ISOLATION_LEVEL= Data Set Option
- READ_LOCK_TYPE= Data Set Option
- READ_MODE_WAIT= Data Set Option
- READBUFF= 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
- 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 for Relational Databases
- Macro Variables for Relational Databases
- System Options for Relational Databases
- DB2CATALOG= System Option
- DBFMTIGNORE= System Option
- DBIDIRECTEXEC= System Option
- DBSRVTP= System Option
- SASTRACE= System Option
- SASTRACELOC= System Option
- SQLGENERATION= System Option
- SQLMAPPUTTO= System Option
- VALIDVARNAME= System Option
- The Pass-Through Facility for Relational Databases
- DBMS-Specific Reference
- SAS/ACCESS Interface to DB2 under 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
- 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
- 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 under 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
- 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 and Settings 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
- Pass-Through Facility Specifics for Greenplum
- Autopartioning for the Interface to 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 HP Neoview
- Introduction to SAS/ACCESS Interface to HP Neoview
- LIBNAME Statement Specifics for HP Neoview
- Data Set Options for HP Neoview
- Pass-Through Facility Specifics for HP Neoview
- Autopartioning 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 for Informix
- Introduction to SAS/ACCESS Interface to Informix
- LIBNAME Statement Specifics for Informix
- Data Set Options for Informix
- 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 of 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
- 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 for MySQL
- Introduction to SAS/ACCESS Interface to MySQL
- LIBNAME Statement Specifics for MySQL
- Data Set Options for MySQL
- 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
- 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
- Deploying and Using SAS Formats in 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Deploying and Using SAS Formats in Teradata
- In-Database Procedures in Teradata
- Locking in the Teradata Interface
- Naming Conventions for Teradata
- Data Types for Teradata
- Sample Code
- Accessing DBMS Data with the LIBNAME Statement
- About the LIBNAME Statement Sample Code
- Creating SAS Data Sets from DBMS Data
- Using the SQL Procedure with DBMS Data
- Using Other SAS Procedures with DBMS Data
- Calculating Statistics from DBMS Data
- Selecting and Combining DBMS Data
- Joining DBMS and SAS Data
- Accessing DBMS Data with the Pass-Through Facility
- About the Pass-Through Facility Sample Code
- Retrieving DBMS Data with a Pass-Through Query
- Combining a PROC SQL View with a SAS Data Set
- Using a Pass-Through Query in a Subquery
- Sample Data for SAS/ACCESS for Relational Databases
- Converting SAS/ACCESS Descriptors to PROC SQL Views
- The CV2VIEW Procedure
- Appendixes
- The ACCESS Procedure for Relational Databases
- Overview of the ACCESS Procedure for Relational Databases
- DBMS Specifics for the ACCESS Procedure
- Procedure Syntax
- PROC ACCESS Statement
- Database Connection Statements
- ASSIGN Statement
- CREATE Statement
- DROP Statement
- FORMAT Statement
- LIST Statement
- QUIT Statement
- RENAME Statement
- RESET Statement
- SELECT Statement
- SUBSET Statement
- TABLE= Statement
- UNIQUE Statement
- UPDATE Statement
- Using Descriptors with the ACCESS Procedure
- Examples of Using the ACCESS Procedure
- The DBLOAD Procedure for Relational Databases
- Overview of the DBLOAD Procedure for Relational Databases
- DBMS Specifics for the DBLOAD Procedure
- Procedure Syntax
- PROC DBLOAD Statement
- Database Connection Statements
- ACCDESC= Statement
- COMMIT= Statement
- DELETE Statement
- ERRLIMIT= Statement
- LABEL Statement
- LIMIT= Statement
- LIST Statement
- LOAD Statement
- NULLS Statement
- QUIT Statement
- RENAME Statement
- RESET Statement
- SQL Statement
- TABLE= Statement
- TYPE Statement
- WHERE Statement
- Example of Using the DBLOAD Procedure
- Recommended Reading
- Glossary
Index here
| Product | Release |
|---|---|
| SAS/ACCESS Interface to Sybase | 9.21 |
| SAS/ACCESS Interface to Oracle | 9.21 |
| SAS/ACCESS Interface to DB2 | 9.21 |
| SAS/ACCESS Interface to Greenplum | 9.21 |
| SAS/ACCESS Interface to Netezza | 9.21 |
| SAS/ACCESS Interface to ODBC | 9.21 |
| SAS/ACCESS Interface to Teradata | 9.21 |
| SAS/ACCESS Interface to Sybase IQ | 9.21 |
| SAS/ACCESS Interface to MySQL | 9.21 |
| SAS/ACCESS Interface to Microsoft SQL Server | 9.21 |
| SAS/ACCESS Interface to HP Neoview | 9.21 |
| SAS/ACCESS Interface to Informix | 9.21 |
| SAS/ACCESS Interface to OLE DB | 9.21 |
- Type
- Usage and Reference
- Last Updated
- 09Nov2009
 |
|
| Previous Page | | | Next Page |
| Performance Considerations |
Repeatedly Accessing Data
- CAUTION:
- If you need to access the most current DBMS data, access
it directly from the database every time. Do not follow the extraction suggestions
in this section.
![[cautionend]](../../../../common/62850/HTML/default/images/cautend.gif)
It is sometimes more efficient to extract (copy) DBMS data to a SAS data file than to repeatedly read the data by using a SAS view. SAS data files are organized to provide optimal performance with PROC and DATA steps. Programs that use SAS data files are often more efficient than SAS programs that read DBMS data directly.
Consider extracting data when you work with a large DBMS table and plan to use the same DBMS data in several procedures or DATA steps during the same SAS session.
You can extract DBMS data to a SAS data file by using the OUT= option, a DATA step, or ACCESS procedures.
|
|
| Previous Page | | | Next Page | | | Top of Page |
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
