Macro Variables and System Options for Relational Databases |
Specifies whether to ignore numeric
formats.
Default value: |
NODBFMTIGNORE
|
Valid in: |
configuration file, SAS invocation, OPTIONS
statement, SAS System Options window
|
DBMS Support: |
Teradata
|
DBFMTIGNORE | NODBFMTIGNORE
|
- DBFMTIGNORE
-
specifies that numeric formats are ignored and FLOAT data
type is created.
- NODBFMTIGNORE
-
specifies that numeric formats are used.
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.
Deploying and Using SAS Formats in Teradata
In-Database Procedures in Teradata
SQL_FUNCTIONS= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.