Chapter Contents |
Previous |
Next |
SAS/ACCESS Interface to ADABAS Software |
SAS/ACCESS software uses SAS/ACCESS descriptor files to establish a connection between the SAS System and ADABAS. You create these files with the ACCESS procedure.
There are two types of SAS/ACCESS descriptor files: access descriptors and view descriptors.
Relationship among ADABAS Data, an Access Descriptor, and View Descriptors illustrates the relationships among ADABAS data, an access descriptor, and view descriptors.
Relationship among ADABAS Data, an Access Descriptor, and View Descriptors
Access Descriptor Files |
View Descriptor Files |
Each view descriptor can define all of the data or a particular subset of the data described by one access descriptor (and therefore one ADABAS file or DDM). For example, you may want to use only three or four possible data fields and only some of the logical records. The view descriptor allows you to select the data fields you want and, by specifying selection criteria, to select only the specific data you want. For example, your selection criteria might be that the date of transaction is July 3, 1987, and that customers' names begin with W.
Typically, for each access descriptor, you will have several view descriptors, selecting different subsets of data.
You can join data from multiple ADABAS files or NATURAL DDMs with the SAS System SQL procedure. The SQL procedure can join data from SAS data files, PROC SQL views, and SAS/ACCESS view descriptors into one resulting file. In addition, SAS/ACCESS view descriptors can come from different database management systems. For examples that use the SQL procedure, see Using ADABAS Data in SAS Programs and Browsing and Updating ADABAS Data.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.