Chapter Contents

Previous

Next
SAS/ACCESS Interface to ADABAS Software

ACCESS Procedure Formats and Informats

When you create SAS/ACCESS descriptor files from ADABAS data, the ACCESS procedure converts data field types and lengths to default SAS System variable formats and informats.

The following summary information will help you understand the data conversion.

The following table shows the default SAS System variable formats and informats that the ACCESS procedure assigns to each ADABAS data type in an ADABAS file.

Default SAS Formats and Informats for ADABAS File Processing
ADABAS Type Description Standard Length in Bytes SAS Format and Informat
A alphanumeric <=200 $ADBLEN.


>200 $200
B binary < = 4 (2 x ADBLEN) + 1

(unsigned) > 4 and < =8 (2 x ADBLEN).


> 8 and < =100 $HEX(2 x ADBLEN) .


> 100 $HEX200.
F fixed (signed)
8.
G floating point (signed)
BEST12.
P packed decimal (signed)
(2 x ADBLEN + 1).
U unpacked decimal < = 16 (ADBLEN + 1).

(zoned decimal) > 16 $HEX(2 x ADBLEN).

(signed)


The following information applies to this table:

The following table shows the default SAS System variable formats and informats that the ACCESS procedure assigns to each ADABAS data type in a NATURAL DDM.

Default SAS Formats and Informats for NATURAL DDM Processing
ADABAS Type Description Standard Length in Bytes SAS Format and Informat
A alphanumeric < = 200 $DDMLEN.


> 200 $200.
B binary (unsigned) < = 4 (DDMLEN + DECPT + SIGNPT) .


> 4 and < = 8 (DDMLEN +DECPT) .


> 8 and < = 100 $HEX(2 x ADBLEN).


> 100 $HEX200.
F fixed (signed)
(DDMLEN + DECPT + SIGNPT) .
G floating point (signed)
BEST12.
P packed decimal (signed)
(DDMLEN + DDMDEC + DECPT + SIGNPT) . DDMDEC.
U unpacked decimal (zoned decimal) (signed) < = 16 (DDMLEN + DDMDEC + DECPT + SIGNPT) . DDMDEC.


> 16 $HEX(2 x ADBLEN).

The following information applies to this table:


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.