SAS ACCESS 9.1 Interface to CA-Datacom DB: Reference

✍ Scribed by The SAS Technical Team Writers

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

✦ Synopsis

Take advantage of the power of SAS as you analyze and present data directly from CA-Datacom/DB databases. There's no risk to database integrity, since CA-Datacom/DB security levels and MVS security are fully supported. You can provide access capabilities to as many, or as few, users as necessary. In this title, you will learn how to perform the following tasks with this SAS/ACCESS interface: create SAS/ACCESS descriptor files using the ACCESS procedure, directly access data in CA-Datacom/DB tables from within a SAS program, using the descriptor files created with the ACCESS procedure, extract CA-Datacom/DB data and place it in a SAS data file using the ACCESS procedure or the DATA step, update data in CA-Datacom/DB tables using the SQL procedure, the APPEND procedure, SAS/FSP software, or SAS/AF software. You will also learn to print, plot, and chart the data described by the descriptor files and use it to create other SAS data files. This title contains reference information required by applications programmers, end users, and administrators who need to use CA-Datacom/DB data with SAS.

✦ Table of Contents

SAS/ACCESS 9.1 Interface to CA-Datacom/DB
......Page 2
Contents......Page 4
Details......Page 8
SAS/ACCESS Interface to CA-Datacom/DB: Usage......Page 10
Purpose of the SAS/ACCESS Interface to CA-Datacom/DB......Page 12
SAS/ACCESS Descriptor Files......Page 13
View Descriptor Files......Page 14
Example Data in the CA-Datacom/DB Document......Page 15
CA-Datacom/DB and CA-DATADICTIONARY Software......Page 16
CA-Datacom/DB Databases......Page 17
RECORD Entity-type......Page 18
Data Types in CA-Datacom/DB Fields......Page 19
Sorting Data in a SAS/ACCESS View Descriptor......Page 21
CA-Datacom/DB Execution Environments......Page 22
SAS/ACCESS Descriptor Files Essentials......Page 24
Creating Access Descriptors and View Descriptors in One PROC Step......Page 25
Updating Descriptor Files......Page 29
Extracting CA-Datacom/DB Data with the ACCESS Procedure......Page 30
Introduction to Using CA-Datacom/DB Data in SAS Programs......Page 32
Reviewing Columns for CA-Datacom/DB Data......Page 33
Printing CA-Datacom/DB Data......Page 34
Charting CA-Datacom/DB Data......Page 35
Calculating Statistics for CA-Datacom/DB Data......Page 36
Using the MEANS Procedure......Page 37
Using the RANK Procedure......Page 38
Selecting Data with the WHERE Statement......Page 39
Combining Data with the SQL Procedure......Page 40
Updating a Version 6 Data File......Page 47
Updating a Version 8 and Later Data File......Page 49
Performance Considerations......Page 50
Browsing and Updating CA-Datacom/DB Data with the SAS/FSP Procedures......Page 52
Updating Data with PROC FSEDIT......Page 53
Browsing and Updating Data with PROC FSVIEW......Page 54
Specifying a WHERE Clause While Browsing or Updating Data......Page 55
Inserting and Deleting Data Records with the SAS/FSP Procedures......Page 57
Browsing Data with the SELECT Statement......Page 59
Updating Data with the UPDATE Statement......Page 61
Appending CA-Datacom/DB Data with the APPEND Procedure......Page 62
SAS/ACCESS Interface to CA-Datacom/DB: Reference......Page 66
Introduction to ACCESS Procedure Reference......Page 68
ACCESS Procedure Syntax......Page 69
PROC ACCESS Statement Options......Page 70
SAS Passwords for SAS/ACCESS Descriptors......Page 71
Assigning Passwords for SAS/ACCESS Descriptors......Page 72
Invoking the ACCESS Procedure......Page 74
Statements......Page 75
View WHERE Clause Syntax......Page 98
The Asterisk in View WHERE Clauses......Page 99
Specifying Values in View WHERE Clauses......Page 100
View SORT Clause Guidelines......Page 104
Creating and Using View Descriptors Efficiently......Page 105
ACCESS Procedure Data Conversions......Page 106
Appendices......Page 108
How the SAS/ACCESS Interface to CA-Datacom/DB Works......Page 110
How the CA-Datacom/DB Interface View Engine Works......Page 111
Retrievals with No WHERE Clause......Page 112
The Internal Record ID (RID)......Page 113
Repositioning to an Inserted Record......Page 114
How Changing the CA-DATADICTIONARY Database Affects Descriptor Files......Page 115
Changes That Cause Existing View Descriptors to Fail......Page 116
User Requirements Table (URT)......Page 117
Maximizing the CA-Datacom/DB Interface Performance......Page 118
Multi-Tasking with CA-Datacom/DB......Page 119
System Options for the CA-Datacom/DB Interface......Page 120
Data Set Options......Page 122
User Exits from CA-Datacom/DB......Page 128
Missing Values (Nils) in CA-Datacom/DB Tables......Page 129
SAS WHERE Clause......Page 130
Validation against CA-DATADICTIONARY......Page 131
Introduction to Data and Descriptors for the Examples......Page 134
CA-DATADICTIONARY Statements for Sample Tables......Page 135
CUSTOMERS Table......Page 141
EMPLOYEES Table......Page 143
INVOICE Table......Page 145
ORDER Table......Page 147
MYLIB.CUSTS Access Descriptor......Page 149
MYLIB.INVOICE Access Descriptor......Page 150
VLIB.CUSORDR View Descriptor......Page 151
VLIB.EMPS View Descriptor......Page 152
VLIB.USAINV View Descriptor......Page 153
MYDATA.OUTOFSTK Data File......Page 154
LIB6.BIRTHDAY Data File......Page 155
Recommended Reading......Page 158
Glossary......Page 160
Index......Page 166