Macro Variables and System Options for Relational Databases

DBFMTIGNORE= System Option

Specifies whether to ignore numeric formats.

Default value:	NODBFMTIGNORE
Valid in:	configuration file, SAS invocation, OPTIONS statement, SAS System Options window
DBMS Support:	Teradata

Syntax
Syntax Description
Details
See Also

Syntax

DBFMTIGNORE | NODBFMTIGNORE

Syntax Description

DBFMTIGNORE: specifies that numeric formats are ignored and FLOAT data type is created.
NODBFMTIGNORE: specifies that numeric formats are used.

Details

This option pertains only to SAS formats that are numeric. SAS takes all other formats--such as date, time, datetime, and char--as hints when processing output. You normally use numeric formats to specify a database data type when processing output. Use this option to ignore numeric formats and create a FLOAT data type instead. For example, the SAS/ACCESS engine creates a table with a column type of INT for a SAS variable with a format of 5.0.