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
|
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, trailing blanks are trimmed in columns with a data type of CHARACTER when converting to a VARCHAR data type. |
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
|
Function SAS_PUT does
not exist
Data truncation
SQL syntax error near
the location of the first argument in the SAS_PUT( ) function
call