When using the LIBNAME engine
for DataFlux Federation Server, 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 the
DataFlux 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.