Previous Page | Next Page

LIBNAME Statement: PC Files on Microsoft Windows

DBFORCE



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.

Previous Page | Next Page | Top of Page