Contents
About
SAS/ACCESS Interface to ADABAS: Usage
Overview of the SAS/ACCESS Interface to ADABAS
Introduction to the SAS/ACCESS Interface to ADABAS
Purpose of the SAS/ACCESS Interface to ADABAS
SAS/ACCESS Descriptor Files for ADABAS
Example Data in the ADABAS Document
ADABAS Essentials
Introduction to ADABAS Essentials
ADABAS DBMS
ADABAS Databases
Accessing ADABAS Files in NATURAL Programs
ADABAS Data Fields
ADABAS Null Values
ADABAS and NATURAL Security Options
ADABAS Data in SAS Programs
Introduction to Using ADABAS Data in SAS Programs
Reviewing ADABAS Variables
Printing ADABAS Data
Charting ADABAS Data
Calculating Statistics with ADABAS Data
Selecting and Combining ADABAS Data
Updating a SAS Data File with ADABAS Data
Performance Considerations
Browsing and Updating ADABAS Data
Introduction to Browsing and Updating ADABAS Data
Browsing and Updating ADABAS Data with the SAS/FSP Procedures
Browsing and Updating ADABAS Data with the SQL Procedure
Browsing Data with the SELECT Statement
Updating Data with the UPDATE Statement
Inserting and Deleting Data with the INSERT and DELETE Statements
Appending ADABAS Data with the APPEND Procedure
SAS/ACCESS Interface to ADABAS: Reference
ACCESS Procedure Reference
Introduction to ACCESS Procedure Reference
Introduction to SAS/ACCESS Interface to ADABAS Software
Description of ACCESS and VIEW Files
Additional Topics About the ACCESS Procedure
Case Sensitivity in the ACCESS Procedure
ACCESS Procedure Syntax for ADABAS
Options for the ACCESS Procedure
SAS Passwords for SAS/ACCESS Descriptors
Invoking the ACCESS Procedure
ADBFILE Statement
ASSIGN Statement
CONTENT Statement
CREATE Statement
DDM= Statement
DROP Statement
EXTEND Statement
FORMAT Statement
INFORMAT Statement
KEY Statement
LIST Statement
LISTINFO Statement
LISTOCC Statement
MVF Statement
NSS Statement
QUIT Statement
RENAME Statement
RESET Statement
SECFILE Statement
SECURITY Statement
SELECT Statement
SUBSET Statement
SYSFILE Statement
UPDATE Statement
WHERE Clause in an ADABAS View Descriptor
SORT Clause in a View Descriptor
Creating and Using ADABAS View Descriptors Efficiently
ACCESS Procedure Formats and Informats for ADABAS
Effects of the SAS/ACCESS Interface on ADABAS Data
Appendixes
Information for the Database Administrator
Introduction to the Information for the Database Administrator
SAS/ACCESS Interface to ADABAS
Effects of Changing an ADABAS File or NATURAL DDM on Descriptor Files
Data Security with ADABAS
Controlling Data Locks with ADABAS
Maximizing ADABAS Performance
Debugging Information for ADABAS
System Options for PROC ACCESS and the Interface View Engine
Advanced Topics
Introduction to Advanced Topics
Data Set Options for ADABAS
Using Multiple View Descriptors
Deleting an ADABAS Observation
Adding an ADABAS Observation
Using a BY Key to Resolve Ambiguous Inserts
Missing Values (Nulls)
Using Multiple-Value Fields in Selection Criteria
Periodic Group Fields in Selection Criteria
SAS WHERE Clause
Deciding How to Specify Selection Criteria
Example Data
Introduction to the ADABAS Example Data
ADABAS Files
NATURAL DDMs Based on the ADABAS Files
Access Descriptors for ADABAS
View Descriptors Based on the Access Descriptors for ADABAS
SAS Data Files for ADABAS
Recommended Reading
Glossary
Product
Release
SAS/ACCESS Interface to Adabas
9.2
Type
Usage and Reference
Copyright Date
March 2008
Last Updated
15Apr2008