SAS Institute. The Power to Know

SAS/ACCESS(R) 9.2 Interface to PC Files: Reference

space
Previous Page | Next Page

The LIBNAME Statement for PC Files on Microsoft Windows

NULLCHARVAL= Data Set Option



Defines the character string that replaces SAS character missing values during insert, update, and DBKEY= processing.
Valid in: DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default value: a blank character

Syntax
Details

Syntax

NULLCHARVAL='character-string'


Details

This option affects insert and update processing and also applies when you use the DBKEY= option.

This option works with the NULLCHAR= option, which determines whether a SAS character NULL value is treated as a NULL value.

If NULLCHARVAL= is longer than the maximum column width, one of the following occurs:

  • The string is truncated if DBFORCE=YES.

  • The operation fails if DBFORCE=NO.

space
Previous Page | Next Page | Top of Page