Data Types for SPD Server Tables

The following table lists the data type support for an SPD Server table.

The BINARY, DECIMAL, NUMERIC, NCHAR, NVARCHAR, and VARBINARY data types are not supported for data type definition.

For some data type definitions, the data type is mapped to CHAR, which is a Base SAS character data type, or DOUBLE, which is a Base SAS numeric data type. For data source specific information about the SAS numeric and SAS character data types, see SAS Language Reference: Concepts.

Data Types for SPD Server Tables
Data Type Definition Keyword	SPD Data Set Data Type	Description	Data Type Returned
BIGINT1	DOUBLE	64-bit double precision, floating-point number. Note: There is potential for loss of precision.	DOUBLE
CHAR(n)	CHAR(n)	Fixed-length character string. Note: Cannot contain ANSI SQL null values.	CHAR(n)
DATE 2	DOUBLE	64-bit double precision, floating-point number. By default, applies the DATE9 SAS format.	DOUBLE
DOUBLE1	DOUBLE	64-bit double precision, floating-point number.	DOUBLE
FLOAT(p) 1	DOUBLE	64-bit double precision, floating-point number.	DOUBLE
INTEGER1	DOUBLE	64-bit double precision, floating-point number.	DOUBLE
REAL1	DOUBLE	64-bit double precision, floating-point number.	DOUBLE
SMALLINT1	DOUBLE	64-bit double precision, floating-point number.	DOUBLE
TIME(p)2	DOUBLE	64-bit double precision, floating-point number. By default, applies the TIME8 SAS format.	DOUBLE
TIMESTAMP(p)2	DOUBLE	64-bit double precision, floating-point number. By default, applies the DATETIME19.2 SAS format.	DOUBLE
TINYINT1	DOUBLE	64-bit double precision, floating-point number.	DOUBLE
VARCHAR(n)	CHAR(n)	Fixed-length character string. Note: Cannot contain ANSI SQL null values.	CHAR(n)
1Do not apply date and time SAS formats to a numeric data type. For date and time values, use DATE, TIME, or TIMESTAMP data types.
2Because the values are stored as double precision, floating-point numbers, you can use the values in arithmetic expressions.

Last updated: February 23, 2017