|
Data Type Definition
Keyword
|
HDMD Data Type
|
Description
|
Data Type Returned
|
|---|---|---|---|
|
BIGINT
|
BIGINT
|
A large signed, exact
whole number, with a precision of 19 digits. The range of integers
is -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
|
BIGINT
|
|
CHAR(n)
|
CHAR(n)
|
A fixed-length character
string.
|
CHAR(n)
|
|
DATE
|
DATE
|
Date value.
|
DATE
|
|
DECIMAL/NUMERIC(p,s)
|
DECIMAL1
|
A fixed-point decimal
number, with 38 digits precision.
|
DOUBLE
|
|
DOUBLE
|
DOUBLE
|
A signed, approximate,
double-precision, floating-point number.
Note: Supports SAS missing values
|
DOUBLE
|
|
FLOAT
|
DOUBLE
|
A signed, approximate,
double-precision, floating-point number.
Note: Supports SAS missing values
|
DOUBLE
|
|
INTEGER
|
INTEGER
|
A regular size signed,
exact whole number, with a precision of 10 digits. The range of integers
is -2,147,483,648 to 2,147,483,647.
|
INTEGER
|
|
REAL
|
REAL
|
A signed, approximate,
single-precision, floating-point number.
Note: Supports SAS missing values
|
REAL
|
|
SMALLINT
|
SMALLINT
|
A small signed, exact
whole number, with a precision of five digits. The range of integers
is -32,768 to 32,767.
|
SMALLINT
|
|
TIME(p)
|
TIME[(p)]
|
Time value with optional
precision.
|
TIME[(p)]
|
|
TIMESTAMP(p)
|
TIMESTAMP[(p)]
|
Date and time value
with optional precision.
|
TIMESTAMP[(p)]
|
|
TINYINT
|
TINYINT
|
A very small signed,
exact whole number, with a precision of three digits. The range of
integers is -128 to 127.
|
TINYINT
|
|
VARCHAR(n)
|
VARCHAR(n)
|
Varying-length character
string data.
|
VARCHAR(n)
|
| 1Decimals processed by SAS are processed using a DOUBLE, which can alter the precision. | |||