How Data Set Options Interact with Other Types of Options

Many types of options share the same name and have the same function. For example, you can request to compress a SAS data set by specifying COMPRESS= as a connection string option and as a LIBNAME statement option.
When more than one type of option with the same function is specified, the software honors the following order of precedence:
  1. data set option
  2. LIBNAME statement option
  3. data source connection string option
  4. system option
That is, a data set option overrides a LIBNAME statement option, which overrides a data source connection string option.