Translation of SAS Federation Server Data Types

SAS Federation Server data types are translated to and from the following predetermined legacy SAS data types:
SAS Federation Server Data Type Translation
SAS Federation Server Data Type
Legacy SAS Data Type
Description
BIGINT
SAS numeric
Applies the SAS format 20.
Because a SAS numeric type is a DOUBLE, there is potential for loss of precision. A DOUBLE is an approximate numeric data type rather than an exact numeric data type.
CHAR(n)
SAS character
Applies the SAS format $n.
DATE
SAS numeric
Applies the SAS format DATE9.
Valid SAS date values are in the range from 1582-01-01 to 9999-12-31. Dates outside the SAS date range are not supported and are treated as invalid dates.
DOUBLE
SAS numeric
FLOAT(p)
SAS numeric
INTEGER
SAS numeric
Applies the SAS format 11.
NCHAR(n)
SAS character
Applies the SAS format $n.
NVARCHAR(n)
SAS character
Applies the SAS format $n.
REAL
SAS numeric
SMALLINT
SAS numeric
Applies the SAS format 6.
TIME(p)
SAS numeric
Applies the SAS format TIME8.
The LIBNAME engine does not support fractions of seconds for time values.
TIMESTAMP(p)
SAS numeric
Applies the SAS format DATETIME19.2.
TINYINT
SAS numeric
Applies the SAS format 4.
VARBINARY(n)
SAS character
Applies the SAS format $n.
VARCHAR(n)
SAS character
Applies the SAS format $n.