| The LIBNAME Statement for 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 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.
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.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
