DBLOAD Procedure Reference |
Table 8.1 contains the default conversions of SAS formats to
SYSTEM 2000 item types. These conversions cannot be changed. However, you
can alter the formats of the input SAS variables by using the MODIFY and FORMAT
statements in the DATASETS procedure if you want to affect the behavior of
the type conversions. The modified formats will be saved in the access and
view descriptors.
If there is no SAS format, a character variable becomes
the item type CHARACTER (with a picture equal to the length of the variable
or the value that is specified in the S2KLEN= statement), numeric variables
that are 4 bytes become the item type REAL, and numeric variables that are
8 bytes become the item type DOUBLE. The formats saved in the access and view
descriptors are $w. for character and BEST12.
for numeric.
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]](../../../../common/61925/HTML/default/images/cautend.gif)
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.