When using SAS Federation Server LIBNAME engine, the default processing mode for
null values is SAS
missing value behavior. The following are instances of when you might want to change the mode to
ANSI SQL null value behavior:
-
an application processes a third-party
database and wants the same results as on the
DBMS, which processes data with ANSI SQL null value behavior.
-
an application processes data and wants the same results as a client application that
connects to SAS Federation Server with a client-side
driver, which processes data with ANSI SQL null value behavior
To change the null value processing behavior for the LIBNAME engine to have an ANSI
SQL null value inserted into a character
column instead of a blank, use the
NULLCHAR= Data Set Option.