• Contents
  • About
  • The SAS/ACCESS Interface to SYSTEM 2000
    • Overview of the SAS/ACCESS Interface to SYSTEM 2000
    • Example Data in This Document
  • SYSTEM 2000 Software
    • Overview of SYSTEM 2000
    • SYSTEM 2000 Databases
    • SYSTEM 2000 Item Types
    • SYSTEM 2000 Indexing
    • Selecting a Subset of Data
    • Sorting Output
    • SYSTEM 2000 Passwords
    • SYSTEM 2000 Execution Environments
    • SYSTEM 2000 Database Files
  • SAS/ACCESS Descriptor Files
    • Overview of SAS/ACCESS Descriptor Files
    • Defining SAS/ACCESS Descriptor Files
    • Creating Descriptor Files
  • SYSTEM 2000 Data in SAS Programs
    • Using SYSTEM 2000 Data in SAS
    • Reviewing Variables
    • Printing Data
    • Charting Data
    • Calculating Statistics
    • Selecting and Combining Data with the SQL Procedure
    • Updating SAS Data Files with SYSTEM 2000 Data
    • Performance Considerations
  • Browsing and Updating SYSTEM 2000 Data
    • Browsing and Updating SYSTEM 2000 Data Directly from SAS
    • Browsing and Updating with SAS/FSP
    • Browsing and Updating with the SQL Procedure
    • Using the APPEND Procedure
    • Browsing and Updating with the QUEST Procedure
  • Creating and Loading SYSTEM 2000 Databases
    • DBLOAD Procedure in SAS and SYSTEM 2000
    • Selecting a Processing Mode for Loading Data
  • SAS/ACCESS 9 for SYSTEM 2000: Reference
    • ACCESS Procedure in SAS and SYSTEM 2000
    • ACCESS Procedure Statements
    • ACCESS Procedure Syntax
    • The PROC ACCESS Statement
    • where-clause in SYSTEM 2000
    • ordering-clause in SYSTEM 2000
    • Creating and Using View Descriptors Efficiently
    • PROC ACCESS Data Conversions
    • ASSIGN= Statement (Optional)
    • BYKEY Statement (Optional)
    • CREATE Statement (Required)
    • DATABASE Statement (Required)
    • DROP Statement (Optional)
    • FORMAT Statement (Optional)
    • INFORMAT Statement (Optional)
    • LENGTH Statement (Optional)
    • LIST Statement (Optional)
    • QUIT Statement (Optional)
    • RENAME Statement (Optional)
    • RESET Statement (Optional)
    • SELECT Statement (Optional)
    • SUBSET Statement (Optional)
    • S2KPW Statement (Optional)
    • UNIQUE Statement (Optional)
  • DBLOAD Procedure Reference
    • DBLOAD Procedure and SYSTEM 2000
    • Creating Customized View Descriptors
    • Default SYSTEM 2000 Item Types
    • Allocating the Database Files
    • Adding Disjoint Schema Records
    • Loading One SYSTEM 2000 Database from Another
    • DBLOAD Procedure Options Syntax
    • DBLOAD Procedure Statements Syntax
    • ACCDESC= Statement (Optional)
    • CREATE Statement (Required)
    • DBN= Statement (Required)
    • DELETE Statement (Optional)
    • INDEX Statement (Optional)
    • LABEL Statement (Optional)
    • LEVEL Statement (Optional)
    • LIST Statement (Optional)
    • LOAD Statement (Required)
    • QUIT Statement (Optional)
    • RENAME Statement (Optional)
    • RESET Statement (Optional)
    • S2KLEN Statement (Optional)
    • S2KLOAD Statement (Optional)
    • S2KMODE= Statement (Optional)
    • S2KPW= Statement (Required)
    • VIEWDESC= Statement (Required) | (Optional)
    • WHERE Statement (Optional)
  • QUEST Procedure Reference
    • QUEST Procedure in SAS with SYSTEM 2000
    • Statements in PROC QUEST
    • SYSTEM 2000 Statements and the QUEST Procedure
    • Single-User Mode
    • Multi-User Mode
    • QUEST Procedure Syntax
    • MCS Procedure Statement (Optional)
    • QUIT Procedure Statement (Optional)
    • SCS Procedure Statement (Optional)
  • Topics for Database Administrators
    • SYSTEM 2000 and the SAS/ACCESS Interface
    • Changing a SYSTEM 2000 Database Password
    • Changing a Database Definition
    • Data Security
    • Enabling the Rollback Log
    • Locking Record Levels
    • Maximizing SYSTEM 2000 Performance
  • Advanced Topics for Users
    • Overriding Options
    • Using Multiple View Descriptors
    • Deleting Data Records
    • Inserting Data Records
    • BY Key
    • Missing Values (Nulls)
    • WHERE Clauses in SAS and where-clauses in SYSTEM 2000
    • Specifying Selection Criteria
    • Connecting Strings to Order Conditions
    • Stored Strings in SYSTEM 2000
  • Example Programs
    • Using the Example Programs
    • SYSTEM 2000 Database Definition for Database EMPLOYEE
    • Access Descriptors
    • View Descriptors
    • SAS Data Files
  • Recommended Reading
  • Glossary


ProductRelease
SAS/ACCESS Interface to SYSTEM 20009.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
14Jul2015