How Table Options Interact with Other Types of Options

Many types of options share the same name and have the same function. For example, you can compress a SAS data set by specifying the COMPRESS= table option as a connection string option and as a FedSQL statement table option.
When more than one type of option with the same function is specified, the software follows the following order of precedence:
  1. FedSQL statement table option
  2. data source connection string option
For example, if a connection string includes COMPRESS=NO, and a FedSQL statement includes the table option COMPRESS=YES, then the table option overrides the connection string specification for the named table.
If you are submitting FedSQL statements in a Base SAS session, the following order of precedence applies:
  1. FedSQL statement option
  2. LIBNAME statement option
  3. data source connection string option
  4. system option
That is, FedSQL statement table options override a LIBNAME statement option, which overrides a data source connection string option.
Copyright © SAS Institute Inc. All rights reserved.