Data Types and the SAS_PUT( ) Function

The SAS_PUT( ) function supports direct use of the Teradata data types shown in the following table. In some cases, the Teradata database performs an implicit conversion of the input data to the match the input data type that is defined for the SAS_PUT( ) function. For example, all compatible numeric data types are implicitly converted to FLOAT before they are processed by the SAS_PUT( ) function.
Teradata Data Types Supported by the SAS_PUT( ) Function
Type of Data
Data Type
Numeric
BYTEINT
SMALLINT
INTEGER
BIGINT1
DECIMAL (ANSI NUMERIC)1
FLOAT (ANSI REAL or DOUBLE PRECISION)
Date and time
DATE
TIME
TIMESTAMP
Character23
CHARACTER4
VARCHAR
LONG VARCHAR
1Numeric precision might be lost when inputs are implicitly converted to FLOAT before they are processed by the SAS_PUT( ) function.
2Only the Latin 1 character set is supported for character data. UNICODE is not supported at this time.
3When character inputs are larger than 256 characters, the results depend on the session mode associated with the Teradata connection.
4The SAS_PUT( ) function has a VARCHAR data type for its first argument when the value passed has a data type of CHARACTER. Therefore, columns with a data type of CHARACTER have their trailing blanks trimmed when converting to a VARCHAR data type.
The SAS_PUT( ) function does not support direct use of the Teradata data types shown in the following table. In some cases, unsupported data types can be explicitly converted to a supported type by using SAS or SQL language constructs. For information about performing explicit data conversions, see the topic on data types for Teradata in SAS/ACCESS for Relational Databases: Reference and your Teradata documentation.
Teradata Data Types Not Supported by the SAS_PUT( ) Function
Type of Data
Data Type
ANSI date and time
INTERVAL
TIME WITH TIME ZONE
TIMESTAMP WITH TIME ZONE
GRAPHIC server character set
GRAPHIC
VARGRAPHIC
LONG VARGRAPHIC
Binary and large object
CLOB
BYTE
VARBYTE
BLOB
If an incompatible data type is passed to the SAS_PUT( ) function, various error messages can appear in the SAS log including the following messages:
  • Function SAS_PUT does not exist
  • Data truncation
  • SQL syntax error near the location of the first argument in the SAS_PUT( ) function call