• Contents
  • About
  • SAS/ACCESS Interface to CA-Datacom/DB: Usage
    • Overview of the SAS/ACCESS Interface to CA-Datacom/DB
      • Introduction to the SAS/ACCESS Interface to CA-Datacom/DB
      • Purpose of the SAS/ACCESS Interface to CA-Datacom/DB
      • SAS/ACCESS Descriptor Files
      • Example Data in the CA-Datacom/DB Document
    • CA-Datacom/DB Essentials
      • Introduction to CA-Datacom/DB Essentials
      • CA-Datacom/DB and CA-DATADICTIONARY Software
      • CA-Datacom/DB Databases
      • CA-Datacom/DB Indexing
      • Selecting a Subset of CA-Datacom/DB Data
      • Sorting Data in a SAS/ACCESS View Descriptor
      • Security Features for CA-Datacom/DB
      • CA-Datacom/DB Execution Environments
    • Defining SAS/ACCESS Descriptor Files
      • Introduction to Defining SAS/ACCESS Descriptor Files
      • SAS/ACCESS Descriptor Files Essentials
      • Creating SAS/ACCESS Descriptor Files
      • Updating Descriptor Files
      • Extracting CA-Datacom/DB Data with the ACCESS Procedure
    • Using CA-Datacom/DB Data in SAS Programs
      • Introduction to Using CA-Datacom/DB Data in SAS Programs
      • Reviewing Columns for CA-Datacom/DB Data
      • Printing CA-Datacom/DB Data
      • Charting CA-Datacom/DB Data
      • Calculating Statistics for CA-Datacom/DB Data
      • Selecting and Combining CA-Datacom/DB Data
      • Updating a SAS Data File with CA-Datacom/DB Data
      • Performance Considerations
    • Browsing and Updating CA-Datacom/DB Data
      • Introduction to Browsing and Updating CA-Datacom/DB Data
      • Browsing and Updating CA-Datacom/DB Data with the SAS/FSP Procedures
      • Browsing and Updating CA-Datacom/DB Data with the SQL Procedure
      • Appending CA-Datacom/DB Data with the APPEND Procedure
  • SAS/ACCESS Interface to CA-Datacom/DB: Reference
    • ACCESS Procedure Reference
      • Introduction to ACCESS Procedure Reference
      • ACCESS Procedure Description
      • ACCESS Procedure Syntax
      • Using PROC ACCESS Statement Options
      • SAS Passwords for SAS/ACCESS Descriptors
      • Invoking the ACCESS Procedure
      • WHERE Clause in a View Descriptor
      • SORT Clause in a View Descriptor
      • Creating and Using View Descriptors Efficiently
      • ACCESS Procedure Data Conversions
      • ASSIGN Statement
      • CONTENT Statement
      • CREATE Statement
      • DATABASE Statement
      • DBSTAT Statement
      • DROP Statement
      • EXTEND Statement
      • FORMAT Statement
      • INFORMAT Statement
      • KEY Statement
      • LIST Statement
      • LISTINFO Statement
      • LISTOCC Statement
      • OCCURS Statement
      • PASSWORD Statement
      • QUIT Statement
      • RENAME Statement
      • RESET Statement
      • SELECT Statement
      • SUBSET Statement
      • TABLE Statement
      • TBLSTAT Statement
      • UPDATE Statement
      • URT Statement
      • USER Statement
  • Appendixes
    • Information for the Database Administrator
      • Introduction to the Information for the Database Administrator
      • How the SAS/ACCESS Interface to CA-Datacom/DB Works
      • Retrieval Processing
      • Update Processing
      • Recovery Processing
      • How Changing the CA-DATADICTIONARY Database Affects Descriptor Files
      • SAS Security with CA-Datacom/DB
      • User Requirements Table (URT)
      • Locks and the Spool Files
      • Direct Addressing and Access by Row Number
      • Password Encryption and Decryption in CA-Datacom/DB
      • Maximizing the CA-Datacom/DB Interface Performance
      • Multi-Tasking with CA-Datacom/DB
      • Error Messages and Debugging Information for CA-Datacom/DB
      • System Options for the CA-Datacom/DB Interface
    • Advanced Topics
      • Introduction to Advanced Topics
      • Data Set Options
      • Using Multiple View Descriptors
      • User Exits from CA-Datacom/DB
      • Deleting and Inserting Data Records in CA-Datacom/DB
      • Missing Values (Nils) in CA-Datacom/DB Tables
      • SAS WHERE Clause Conditions Not Acceptable to CA-Datacom/DB
      • Deciding How to Specify Selection Criteria in CA-Datacom/DB
      • Validation of Data Values in CA-Datacom/DB
      • Validation against CA-DATADICTIONARY
      • DDBCOMIT= Data Set Option
      • DDBERLMT= Data Set Option
      • DDBKEY= Data Set Option
      • DDBLOAD= Data Set Option
      • DDBLOCK= Data Set Option
      • DDBPW= Data Set Option
      • DDBSV= Data Set Option
      • DDBTRACE= Data Set Option
      • DDBURT= Data Set Option
      • DDBUSER= Data Set Option
    • Data and Descriptors for the Examples
      • Introduction to Data and Descriptors for the Examples
      • CA-Datacom/DB Tables
      • Access Descriptors for the CA-Datacom/DB Tables
      • View Descriptors for the CA-Datacom/DB Tables
      • SAS Data Files Used for CA-Datacom/DB Examples
  • Recommended Reading
  • Glossary


ProductRelease
SAS/ACCESS Interface to CA-Datacom/DB9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
14Jul2015