SAS Institute. The Power to Know

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

Previous Page | Next Page

LIBNAME Statement: PC Files on Microsoft Windows

NULLCHARVAL



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 these actions occurs:

  • the string is truncated if DBFORCE=YES

  • the operation fails if DBFORCE=NO.

Previous Page | Next Page | Top of Page