NullInterpret
The defined symbol will be interpreted as NULL when it occurs in a text file, Excel file or an inline statement. This is a user-defined variable.
Syntax:
NullInterpret
Examples:
set NullInterpret=' ';
set NullInterpret =;
will not return NULL values for blank values in Excel, but it will for a CSV text file.
set NullInterpret ='';
will return NULL values for blank values in Excel.