Contents
About
What’s New in SAS Federation Server LIBNAME Engine in SAS 9.4
Introduction
Introduction to SAS Federation Server LIBNAME Engine
Understanding the LIBNAME Engine
Using the LIBNAME Engine
Intended Audience
Usage
Establishing a Connection to SAS Federation Server
Components of the LIBNAME Statement
Server Connection
Data Source Connection
Data Source Processing Options
Security
About Security on the LIBNAME Engine
SAS File Passwords
SAS Federation Server Security
Data Type Support
About SAS Federation Server Data Type Support
Translation of SAS Federation 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
About SAS Names
Support for Column Names with Special Characters
Reserved Language Keywords
SAS Functionality Available through the Engine
Data Source Access and Processing
LIBNAME Statement Processing Options
Nonexistent Values
Numeric Column Length
SAS Data Set Options
SAS Formats and Informats
SAS Indexes
SAS Names and Support for DBMS Names
SAS Passwords
SAS System Options
SAS Procedures
Examples of Using the Engine
Connect to SAS Federation Server and Reference a DSN Definition
Control Data Source Processing with a LIBNAME Statement Option
Apply a SAS Data Set Option
Control Data Source Processing with a SAS System Option and a LIBNAME Statement Option
Authenticate with an Authentication Domain
Using the SCHEMA= Data Set Option to Reference a Subsequent Data Source in a Federated DSN
Using the SCHEMA= Data Source Processing Option
Reference
LIBNAME Statement for the FEDSVR Engine
LIBNAME Statement Syntax
Data Source Processing LIBNAME Statement Options for the FEDSVR Engine
ACCESS= LIBNAME Statement Option
APPLICATIONNAME= 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
INSERT_SQL= LIBNAME Statement Option
INSERTBUFF= 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
System Options for the FEDSVR Engine
About SAS System Options for the FEDSVR Engine
BUFNO= System Option
BUFSIZE= System Option
COMPRESS= System Option
FIRSTOBS= System Option
OBS= System Option
SASTRACE= System Option
SASTRACELOC= System Option
SQLUNDOPOLICY= System Option
VALIDVARNAME= System Option
Data Set Options for the FEDSVR Engine
About the FEDSVR LIBNAME Engine Data Set Options
Specifying Data Set Options
How Data Set Options Interact with Other Types of Options
ALTER= Data Set Option
BL_LOAD_REPLACE= Data Set Option
BL_LOG= Data Set Option
BL_OPTIONS= 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
Appendix
ICU License
Recommended Reading
Glossary
Product
Release
Base SAS
9.4_M4
SAS Federation Server
9.4_M4
Type
Usage and Reference
Copyright Date
November 2016
Last Updated
22Nov2016