search:
Search support.sas.com
KNOWLEDGE BASE
System Requirements
Install Center
Product Documentation
Papers
Samples & SAS Notes
Focus Areas
SUPPORT
License Assistance
Administrator Services
Downloads & Hot Fixes
LEARNING CENTER
Bookstore
Training
Certification
SAS Learning Edition
Higher Education Resources
SAS OnDemand For Academics
COMMUNITY
User Groups
Events
E-Newsletters
support.sas.com
KNOWLEDGE BASE
SUPPORT
LEARNING CENTER
COMMUNITY
Product Documentation
>
SAS 9.2 Documentation
Print
|
E-mail
|
Bookmark
|
Feedback
SAS/ACCESS(R) 9.2 Interface to SYSTEM 2000(R): Reference
PDF
|
Purchase
Contents
About
SAS/ACCESS Interface to SYSTEM 2000 Software: Usage
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
TALLY Statement Output
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 Reference
ACCESS Procedure in SAS and SYSTEM 2000
ACCESS Procedure Statements
ACCESS Procedure Syntax
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)
where-clause in SYSTEM 2000
ordering-clause in SYSTEM 2000
Creating and Using View Descriptors Efficiently
PROC ACCESS Data Conversions
DBLOAD Procedure Reference
DBLOAD Procedure and SYSTEM 2000
DBLOAD Procedure 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)
Creating Customized View Descriptors
Default SYSTEM 2000 Item Types
Allocating the Database Files
Adding Disjoint Schema Records
Loading One SYSTEM 2000 Database from Another
QUEST Procedure Reference
QUEST Procedure in SAS with SYSTEM 2000
QUEST Procedure Syntax
MCS Procedure Statement (Optional)
QUIT Procedure Statement (Optional)
SCS Procedure Statement (Optional)
SYSTEM 2000 Statements and the QUEST Procedure
Single-User Mode
Multi-User Mode
Appendixes
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
Using a 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
Database Definition for Database EMPLOYEE
Access Descriptors
View Descriptors
SAS Data Files
Recommended Reading
Glossary
Index here
Product
Release
SAS/ACCESS Interface to System 2000
9.2
Type
Usage and Reference
Copyright Date
March 2008
Last Updated
15Apr2008
Previous Page
|
Next Page
Previous Page
|
Next Page
SAS/ACCESS 9.2 Interface to SYSTEM 2000: Reference
The SAS/ACCESS Interface to SYSTEM 2000
Overview of the SAS/ACCESS Interface to SYSTEM 2000
Example Data in This Document
Previous Page
|
Next Page
|
Top of Page
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
Previous Page
|
Next Page
|
Top of Page