| 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 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 © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
