Translation of the DataFlux Federation Server Data Types

The DataFlux Federation Server data types are translated to and from the following predetermined legacy SAS data types:

DataFlux Federation Server Data Type Translation

DataFlux Federation Server Data Type	Legacy SAS Data Type	Description
BIGINT	SAS numeric	Applies the SAS format 20. Because a SAS numeric is a DOUBLE, which is an approximate numeric data type rather than an exact numeric data type, there is potential for loss of precision.
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. 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.