SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

ACCESS Procedure Data Conversions

The following table shows the default SAS System variable formats and informats that are assigned by the ACCESS procedure to each SYSTEM 2000 item type.

Default SAS System Variable Formats and Informats for SYSTEM 2000 Item Types
SYSTEM 2000 Item Type and Picture SAS Format and Informat

CHAR X(n) $n

TEXT X(n) $CHARn.

DATE DATE7.

INTEGER 9(n) n.

DECIMAL 9(n).9(d) n+d+1.d

MONEY 9(n).9(d) n+d+1.d

REAL BEST12.

DOUBLE BEST12.

UNDEFINED X(n) $HEXn*2.

***Default SAS System Variable Formats and Informats for SYSTEM 2000 Item Types***
SYSTEM 2000 Item Type and Picture	SAS Format and Informat
CHAR X(n)	$n
TEXT X(n)	$CHARn.
DATE	DATE7.
INTEGER 9(n)	n.
DECIMAL 9(n).9(d)	n+d+1.d
MONEY 9(n).9(d)	n+d+1.d
REAL	BEST12.
DOUBLE	BEST12.
UNDEFINED X(n)	$HEXn*2.

If SYSTEM 2000 data fall outside valid SAS data ranges, you get an error message in the SAS LOG when you try to read the data. For example, a SYSTEM 2000 date may not fall in the valid SAS date range.

Chapter Contents
Previous
Next
Top of Page