SAS(R) 9.2 Language Interfaces to the Table Server
Introduction- Concepts
- Understand the SAS Language Interfaces
- Connect to the Data Access Services
- Overview: Connect to the Data Access Services
- Connect to the Data Access Services in Process
- Connect to the Data Access Services in Process with a Table Service Definition
- Connect to the SAS Table Server
- Data Source Connection
- Security for the Interfaces
- SAS Table Server Data Type Support
- About the SAS Table Server Data Type Support
- Translation of the SAS Table Server Data Types
- Override Default Legacy SAS Data Type
- Null Values
- About Null Values
- Null Value Processing Modes
- Potential Result Set Differences
- Change Null Processing Modes
- SAS Names
- SAS Language Elements
- LIBNAME Engine
- Using the LIBNAME Engine
- LIBNAME Statement for the Engine
- LIBNAME Engine SAS System Options
- About SAS System Options
- BUFNO= System Option
- BUFSIZE= System Option
- FIRSTOBS= System Option
- OBS= System Option
- SASTRACE= System Option
- SASTRACELOC= System Option
- TSID= System Option
- VALIDVARNAME= System Option
- LIBNAME Statement Data Source Processing Options
- About the LIBNAME Statement Options
- ACCESS= LIBNAME Statement Option
- AUTOCOMMIT= LIBNAME Statement Option
- COMPRESS= LIBNAME Statement Option
- CONNECTION= LIBNAME Statement Option
- DBCOMMIT= LIBNAME Statement Option
- DBGEN_NAME= LIBNAME Statement Option
- DBINDEX= LIBNAME Statement Option
- DBLIBINIT= LIBNAME Statement Option
- DBLIBTERM= LIBNAME Statement Option
- DBNULLKEYS= LIBNAME Statement Option
- DBPROMPT= LIBNAME Statement Option
- DBSASLABEL= LIBNAME Statement Option
- DEFER= LIBNAME Statement Option
- DIRECT_EXE= LIBNAME Statement Option
- DIRECT_SQL= LIBNAME Statement Option
- IGNORE_ READ_ONLY_COLUMNS= LIBNAME Statement Option
- INSERTBUFF= LIBNAME Statement Option
- INSERT_SQL= LIBNAME Statement Option
- MULTI_DATASRC_OPT= LIBNAME Statement Option
- PRESERVE_COL_NAMES= LIBNAME Statement Option
- PRESERVE_TAB_NAMES= LIBNAME Statement Option
- QUALIFIER= LIBNAME Statement Option
- READBUFF= LIBNAME Statement Option
- READ_ISOLATION_LEVEL= LIBNAME Statement Option
- READ_LOCK_TYPE= LIBNAME Statement Option
- REREAD_EXPOSURE= LIBNAME Statement Option
- SCHEMA= LIBNAME Statement Option
- SPOOL= LIBNAME Statement Option
- SQL_FUNCTIONS= LIBNAME Statement Option
- STRINGDATES= LIBNAME Statement Option
- UPDATE_ISOLATION_LEVEL= LIBNAME Statement Option
- UPDATE_LOCK_TYPE= LIBNAME Statement Option
- UTILCONN_TRANSIENT= LIBNAME Statement Option
- LIBNAME Engine Data Set Options
- LIBNAME Engine Data Set Options
- Syntax
- How Data Set Options Interact with Other Types of Options
- ALTER= Data Set Option
- BL_LOAD_REPLACE= Data Set Option
- BL_OPTIONS= Data Set Option
- BL_LOG= Data Set Option
- BUFNO= Data Set Option
- BUFSIZE= Data Set Option
- BULKLOAD= Data Set Option
- BULKOPTS= Data Set Option
- COMPRESS= 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
- DBMASTER= Data Set Option
- DBNULL= Data Set Option
- DBNULLKEYS= Data Set Option
- DBSASLABEL= Data Set Option
- DBSASTYPE= Data Set Option
- DBTYPE= Data Set Option
- DROP= Data Set Option
- ENCRYPT= Data Set Option
- FIRSTOBS= Data Set Option
- IDXNAME= Data Set Option
- IDXWHERE= Data Set Option
- IGNORE_READ_ONLY_COLUMNS= Data Set Option
- INSERTBUFF= Data Set Option
- INSERT_SQL= Data Set Option
- KEEP= Data Set Option
- LABEL= Data Set Option
- NULLCHAR= Data Set Option
- NULLCHARVAL= Data Set Option
- OBS= Data Set Option
- PRESERVE_COL_NAMES= Data Set Option
- PW= Data Set Option
- QUALIFIER= Data Set Option
- READ= Data Set Option
- READ_ISOLATION_LEVEL= Data Set Option
- READ_LOCK_TYPE= Data Set Option
- READBUFF= Data Set Option
- RENAME= Data Set Option
- REUSE= Data Set Option
- SASDATEFMT= Data Set Option
- SCHEMA= Data Set Option
- TYPE= Data Set Option
- UPDATE_ISOLATION_LEVEL= Data Set Option
- UPDATE_LOCK_TYPE= Data Set Option
- WHERE= Data Set Option
- WRITE= Data Set Option
- Examples of Using the LIBNAME Engine
- Create a SAS Data Set with TSPL Statements
- Access an Oracle Database
- Connect to the SAS Table Server and Submit an Arbitrary Connection String
- Connect to the SAS Table Server and Reference a DSN Definition
- Use a Table Service Definition and Reference a DSN Definition
- Create a File DSN
- Reference a File DSN
- Data Library Manager on SAS Management Console
- TSSQL and TSPL Procedures
- Using the TSSQL and TSPL Procedures
- TSSQL and TSPL Procedure Syntax
- Examples of Using the TSSQL and TSPL Procedures
- Create a SAS Data Set with TSPL Statements
- Query a SAS Data Set with TSSQL Statements
- Connect to a Data Source Using Attributes from Previously Assigned Libref
- Create Multiple Tables from Previously Assigned Librefs
- Use a Macro Variable to Connect to a Data Source
- Connect to the SAS Table Server and Submit an Arbitrary Connection String
- Connect to the SAS Table Server and Reference a DSN Definition
- Use a Table Service Definition and Reference a DSN Definition
- Access Multiple Data Sources
- Appendix
Index here
| Product | Release |
|---|---|
| Base SAS | 9.2 |
| SAS Table Server | 9.2 |
- Type
- Usage and Reference
- Copyright Date
- February 2009
- Last Updated
- 26Feb2009
