Chapter Contents
Previous
Next
SAS/ACCESS Interface to CA-DATACOM/DB: Reference

Missing Values (Nils)

When the interface view engine stores a missing value in a CA-DATACOM/DB table, the missing value is represented by all blanks for both numeric and character type fields. When the engine retrieves a missing value, it appears as all blanks for SAS character columns and as a period (.) for SAS numeric columns.

Note:   A system option is available if you want to set missing values to zeros. See System Options.  [cautionend]


Chapter Contents
Previous
Next
Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.