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

Default SYSTEM 2000 Item Types

Here are the default conversions of SAS formats to SYSTEM 2000 item types. You cannot change them. However, you can alter the formats of the input SAS variables with the DATASETS procedure and its MODIFY and FORMAT statements if you want to affect the behavior of the type conversions. These formats will be saved in the access descriptor and view descriptor.

Default SYSTEM 2000 Item Types and Pictures
SAS Format SYSTEM 2000 Type

$w. CHAR X(n)

$CHARw. TEXT X(n)

any date format DATE

w. INTEGER 9(n)

w.d
DECIMAL 9(n-d-1).9(d)

DOLLARw.d
MONEY 9(n-d-1).9(d)

Ew.

if n. < 8 REAL

if n. >= 8 DOUBLE

$HEXw. UNDEFINED X(n)

***Default SYSTEM 2000 Item Types and Pictures***
SAS Format	SYSTEM 2000 Type
$w.	CHAR X(n)
$CHARw.	TEXT X(n)
any date format	DATE
w.	INTEGER 9(n)
w.d	DECIMAL 9(n-d-1).9(d)
DOLLARw.d	MONEY 9(n-d-1).9(d)
Ew.
if n. < 8	REAL
if n. >= 8	DOUBLE
$HEXw.	UNDEFINED X(n)

Note: n is the length of the SAS variable. The value of w is ignored. [cautionend]

If there is no SAS format, a character variable becomes a type CHARACTER item (with a picture equal to the variable length or the value you specified in an S2KLEN statement), numeric variables that are four bytes become type REAL, and numeric with eight bytes become type DOUBLE. The formats saved in the access descriptor and view descriptor will be $w. for character and BEST12. for numeric.

Chapter Contents
Previous
Next
Top of Page