LIBNAME Statement: PC Files on Microsoft Windows |
Indicates how SAS character missing values are handled during
insert, update, and DBKEY processing.
Valid in: |
DATA and PROC steps (when accessing PC files
data using SAS/ACCESS software)
|
Default value: |
YES
|
-
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 NULLCHARVAL values (regardless of whether
the data source allows NULLs for the column).
The NULLCHAR= option affects insert and
update processing and also applies when you use the DBKEY= option.
This option works in conjunction with the NULLCHARVAL
data set option, which 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.