Data Types for SASHDAT

The following table lists the data type support for a SASHDAT table. A SASHDAT table contains data that is added to the Hadoop Distributed File System (HDFS) by SAS.

The BIGINT, BINARY, DECIMAL, FLOAT, INTEGER, NCHAR, NVARCHAR, NUMERIC, REAL, SMALLINT, TINYINT, VARBINARY, and VARCHAR data types are not supported for data type definition.

A SASHDAT table is Write only for data and Read-Write for metadata information such as column attributes.

Data Types for SASHDAT
Data Type Definition Keyword 1	SASHDAT Data Type	Description
CHAR(n)	CHAR(n)	Fixed-length character string.
DATE	DATE	64-bit double precision, floating-point number. By default, applies the DATE9 SAS format.
DOUBLE	DOUBLE	64-bit double-precision, floating-point number.
TIME(p)	DOUBLE	64-bit double precision, floating-point number. By default, applies the TIME8 SAS format.
TIMESTAMP(p)	DOUBLE	64-bit double precision, floating-point number. By default, applies the DATETIME19.2 SAS format.
1The CT_PRESERVE= connection argument, which controls how data types are mapped, can affect whether a data type can be defined. The values FORCE (default) and FORCE_COL_SIZE do not affect whether a data type can be defined. The values STRICT and SAFE can result in an error if the requested data type is not native to the data source, or the specified precision or scale is not within the data source range.