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 |
| SAS Names and Support for DBMS Names |
Naming Behavior When Retrieving DBMS Data
The following two tables illustrate how SAS/ACCESS processes DBMS names when retrieving data from a DBMS. This information applies generally to all interfaces. In some cases, however, it is not necessary to specify these options because the option default values are DBMS-specific. See the documentation for your SAS/ACCESS interface for details. Examples that illustrate the different types of naming actions and defaults are available.
| DBMS Column Name | Desired SAS Variable Name | Options |
|---|---|---|
| Case-sensitive DBMS column name, such as Flight | Case-sensitive SAS variable name, such as Flight | No options are necessary |
| DBMS column name with characters that are not valid in SAS names, such as My$Flight | Case-sensitive SAS variable name where an underscore replaces the invalid characters, such as My_Flight | No options are necessary |
| DBMS column name with characters that are not valid in SAS names, such as My$Flight | Nonstandard, case-sensitive SAS variable name, such as My$Flight | PROC SQL DQUOTE=ANSI or, in a DATA or PROC step, use a SAS name literal such as 'My$Flight'n and VALIDVARNAME=ANY |
| DBMS Table Name | Desired SAS Data Set Name | Options |
|---|---|---|
| Default DBMS table name, such as STAFF | Default SAS data set or member name (uppercase), such as STAFF | PRESERVE_TAB_NAMES=NO |
| Case-sensitive DBMS table name, such as Staff | Case-sensitive SAS data set, such as Staff | PRESERVE_TAB_NAMES=YES |
| DBMS table name with characters that are not valid in SAS names, such as All$Staff | Nonstandard, case-sensitive SAS data set name, such as All$Staff | PROC SQLDQUOTE=ANSI and PRESERVE_TAB_NAMES=YES or, in a DATA step or PROC, use a SAS name literal such as 'All$Staff'n and PRESERVE_TAB_NAMES=YES |
|
|
| Previous Page | | | Next Page | | | Top of Page |
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
