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)2
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.
2When the (n) is omitted from the CHAR definition, a column of CHAR(1) is created.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 23, 2017