SAS ACCESS 9.1 Interface To Adabas: Reference

✍ Scribed by The SAS Technical Team Writers

• Publisher: SAS Publishing
• Year: 2004
• Tongue: English
• Leaves: 177
• Category: Library

✦ Synopsis

All the power and flexibility of SAS can be used to analyze and present data directly from ADABAS databases. Gaining ADABAS database access can be as simple as filling in the blanks. And analyzing and reporting on that same data can be as easy as pointing and clicking. This title provides complete details for using the ACCESS procedure in a non-windowing environment and contains reference information required by an applications programmer to write access and view descriptors to access ADABAS data and use it in SAS. This title shows you how to perform the following tasks: create SAS/ACCESS descriptor files using the ACCESS procedure, directly access ADABAS data from within a SAS program using the SAS/ACCESS descriptor files created with the ACCESS procedure, extract ADABAS data and place it in a SAS data file using the ACCESS procedure, the DATA step, or other SAS procedures, and update ADABAS data using the SQL procedure, SAS/FSP software, SAS/AF software, and the APPEND procedure. This title provides applications programmers, end users, and administrators the reference information needed to use ADABAS data with SAS

✦ Table of Contents

Front Cover
......Page 0
Title Page......Page 2
Copyright......Page 3
Contents......Page 4
Overview......Page 6
SAS/ACCESS Interface to ADABAS: Usage......Page 8
Purpose of the SAS/ACCESS Interface to ADABAS......Page 10
SAS/ACCESS Descriptor Files for ADABAS......Page 11
Example Data in the ADABAS Document......Page 12
Introduction to ADABAS Essentials......Page 14
ADABAS Databases......Page 15
ADABAS Files......Page 16
ADABAS Descriptors......Page 17
Data Field Types......Page 18
Mapping Data between SAS and ADABAS......Page 19
Data Field Formats and Lengths......Page 20
ADABAS Security Options......Page 21
NATURAL Security Options......Page 22
Introduction to Using ADABAS Data in SAS Programs......Page 24
Reviewing ADABAS Variables......Page 25
Printing ADABAS Data......Page 26
Charting ADABAS Data......Page 27
Calculating Statistics Using the MEANS Procedure......Page 29
Selecting and Combining ADABAS Data......Page 31
Selecting and Combining Data Using the WHERE Statement......Page 32
Selecting and Combining Data Using the SQL Procedure......Page 33
Updating a SAS Data File with ADABAS Data......Page 39
Performance Considerations......Page 41
Introduction to Browsing and Updating ADABAS Data......Page 44
Browsing and Updating Data Using the FSVIEW Procedure......Page 45
Specifying a SAS WHERE Expression While Browsing or Updating Data......Page 46
Adding and Deleting Data with the SAS/FSP Procedures......Page 48
Browsing Data with the SELECT Statement......Page 50
Updating Data with the UPDATE Statement......Page 52
Inserting and Deleting Data with the INSERT and DELETE Statements......Page 54
Appending ADABAS Data with the APPEND Procedure......Page 56
SAS/ACCESS Interface to ADABAS: Reference......Page 60
Introduction to ACCESS Procedure Reference......Page 62
ACCESS Procedure Syntax for ADABAS......Page 63
Description......Page 64
SAS Passwords for SAS/ACCESS Descriptors......Page 65
Assigning Passwords......Page 66
Invoking the ACCESS Procedure......Page 67
ACCESS PROCEDURE Statements for ADABAS......Page 68
View WHERE Clause Syntax......Page 95
View WHERE Clause Examples......Page 96
View SORT Clause Syntax......Page 100
Creating and Using ADABAS View Descriptors Efficiently......Page 101
ACCESS Procedure Formats and Informats for ADABAS......Page 102
Effects of the SAS/ACCESS Interface on ADABAS Data......Page 104
Appendices......Page 106
Introduction to the Information for the Database Administrator......Page 108
How the ADABAS Interface View Engine Works......Page 109
Retrieval Processing......Page 110
Update Processing......Page 113
Changes That Have No Effect on Existing View Descriptors......Page 114
How the Interface View Engine Uses Security Specifications......Page 115
Effects of Changing Security Options......Page 117
Maximizing ADABAS Performance......Page 118
ADBAUSE System Options Default Values......Page 119
View Engine ADBEUSE System Options Default Values......Page 120
Introduction to Advanced Topics......Page 122
Data Set Options for ADABAS......Page 123
Adding an ADABAS Observation......Page 125
BY Key Examples......Page 126
Missing Values (Nulls)......Page 128
Using Multiple-Value Fields in Selection Criteria......Page 129
WHERE Clause Examples......Page 130
Periodic Group Fields in Selection Criteria......Page 131
WHERE Clause Examples......Page 132
Using a SAS WHERE Clause for Selection Criteria......Page 134
SAS WHERE Clause Conditions Acceptable to ADABAS......Page 135
When a SAS WHERE Clause Must Reference Descriptor Data Fields......Page 136
SAS WHERE Clause......Page 137
Example Data......Page 138
CUSTOMERS ADABAS File......Page 139
EMPLOYEE ADABAS File......Page 145
INVOICE ADABAS File......Page 147
ORDER ADABAS File......Page 149
EMPLOYEE DDM......Page 152
ORDER DDM......Page 153
Access Descriptors Based on ADABAS Files......Page 154
Access Descriptors Based on the NATURAL DDMs......Page 155
VLIB.CUSPHON View Descriptor......Page 157
VLIB.USACUST View Descriptor......Page 158
MYDATA.OUTOFSTK SAS Data File......Page 159
LIB6.BIRTHDAY Data File......Page 160
Recommended Reading......Page 162
Glossary......Page 164
Index......Page 170