LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Indicates how SAS character missing values are handled during
insert, update, and DBKEY= processing.
Valid in: |
DATA and PROC steps
|
Default value: |
SAS
|
- YES
-
indicates that character missing values in SAS data sets
are treated as NULL values if the data source allows them. Otherwise, an error
is returned.
- NO
-
indicates that character missing values in SAS data sets
are treated as the NULLCHARVAL= value, regardless of whether the data source
allows NULLs for the column.
This option affects insert and update processing and also
applies when you use the DBKEY= option.
in conjunction with the NULLCHARVAL= data set option, NULLCHARVAL= determines
what is inserted when NULL values are not allowed.
All SAS numeric missing values (represented in SAS as .) are treated
by the data source as
NULLs.
DBKEY.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.