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

DBFORCE= Data Set Option



Specifies whether to force the truncation of data during insert processing.
Valid in: DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default value: NO

Syntax
Syntax Description
Details

Syntax

DBFORCE=YES | NO

Syntax Description

YES

specifies that the rows that contain data values that exceed the length of the column are inserted, and the data values are truncated to fit the column length.

NO

specifies that the rows that contain data values that exceed the column length are not inserted.


Details

This option determines how the SAS/ACCESS engine handles rows that contain data values that exceed the length of the column.

The SAS data set option FORCE= overrides this option when it is used with PROC APPEND or the PROC SQL UPDATE statement. The PROC SQL UPDATE statement does not provide a warning before truncating the data.

space
Previous Page | Next Page | Top of Page