DBFORCE

Specifies whether to force the truncation of data during insert processing.
Valid in: DATA and PROC steps
Default: NO

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 width.
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.