SAS ACCESS 9.1 Interface To Adabas: Reference

Front Cover\r......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