Data Management for Business Success
Greater Speed and Functionality for Any Application
Your Gateway to Productivity
The Basic SYSTEM 2000 Software
Additional Products
From SAS Institute, the Leader in Data Management
Fast, Efficient Access to Large Volumes of Data
Database Management for Business Success
A SAS software user is conducting clinical trials as part of pharmaceutical
research and development. Results will be stored in the non-repetitive tree
structure of a SYSTEM 2000 database - a logical choice for experimental data.
The researcher accesses an FSEDIT screen and types in the clinical findings.
Then, with a press of the ENTER key, the data are stored in a SYSTEM 2000
database. Identifying data - such as a subject's biographical and medical
history - are stored only once, regardless of the number of clinical trials
involving the subject. The researcher can access data in the SYSTEM 2000
database easily using the software's indexing capabilities.
SYSTEM 2000 Data Management Software is a powerful, user-oriented database
system and a logical storage methodology for production applications. Combining
SYSTEM 2000 software with the SAS System meets a wide range of requirements for
many organizations.
By putting SYSTEM 2000 software to work, you can
- provide a more efficient way to store data and quickly retrieve information
- cut storage costs by identifying and eliminating redundant data
- merge and preprocess several data files for an application before you begin
your work
- provide coordinated access to your data
- prevent the loss of data in the event of power outage or CPU failure.
SYSTEM 2000 software is backed by the depth and breadth of SAS Institute's
technical support and authoritative documentation. We also offer a variety of
instructor-led training courses for SYSTEM 2000 users.
SYSTEM 2000 software helps you get a handle on your expanding applications.
Indexing provides fast data access, while features such as automatic data
recovery and enhanced data security keep your data safe. And because SYSTEM
2000 software combines with other SAS System components, you have more
flexibility than ever for new applications.
Fast Data Access
SYSTEM 2000 software offers complete and flexible multilevel, variable
indexing for fast data access. The index is maintained automatically, without
impacting applications or database structure.
Efficient Data Storage
SYSTEM 2000 data structures allow you to store each data value only once,
eliminating redundancy. Associated data in related records are tied
automatically to the parent data. And, depending on your data relationships,
you can structure SYSTEM 2000 data in table, hierarchical, network,
or relational formats. You can also store your data across multiple volumes,
so that all data is readily accessible.
Automatic Data Recovery
If you've ever lost data due to a power outage or CPU failure, you understand
why SYSTEM 2000 software's automatic recovery feature is so valuable. When
data are damaged, the system first rolls data back to their original state,
then applies the updates to bring data to the current state. If changes in
one database affect changes in other databases, you can instruct SYSTEM 2000
software to coordinate the automatic recovery of all data involved.
User-Controlled Recovery
SYSTEM 2000 software also provides an easy way to recover when erroneous
transactions are entered into the system. SYSTEM 2000 software lets you back
up and apply only those transactions that were entered correctly.
High-Level Data Security
With SYSTEM 2000 password protection you can control access to sensitive data
such as financial and clinical files while supplying end users with the data
they need. The same database can contain both public data and highly
confidential data, yet only authorized users can view or access the
confidential records.
SQL Support
You can use Structured Query Language (SQL) to retrieve data from several
databases or to combine data from two or more databases.
Flexible User Exits
SYSTEM 2000 user exits allow experienced users to customize the software's
features. These user exits can be used to tailor and extend security checks
for online systems, for encryption and decryption of data and for dynamic
file allocation.
The SAS/ACCESS" interface to SYSTEM 2000 software (MVS and CMS) allows any
SAS procedure, including the DATA step, to use a view of a database just as
if the data were in a SAS data set. The SAS/ACCESS interface allows you
to use all the familiar SAS system tools and also take advantage of the
efficient data storage, multiple simultaneous accesses through Multi-User
software, and integrity protection offered by the database management
capabilities.
The interface between SAS/ACCESS and SYSTEM 2000 software is direct and
transparent. That means greater speed, increased security, and simultaneous
update capability for multiple users.
ACCESS, DBLOAD, and QUEST are interface procedures for the SAS System and
SYSTEM 2000 software. These procedures provide more power for SAS software
and SYSTEM 2000 users.
ACCESS Procedure
Use the ACCESS procedure to describe the SYSTEM 2000 database structure and
store the description in a descriptor file. When you specify the descriptor
file, this SAS procedure operates directly on those variables you include and
no others.
DBLOAD Procedure
The DBLOAD procedure lets you create and load SYSTEM 2000 databases from a
SAS data set. PROC DBLOAD can automatically create a database organized in
the same way as the specified SAS data set, including the same variables and
variable names. You can also rename items, organize levels, or specify
indexing for each item.
QUEST Procedure
The QUEST procedure gives users an interactive way to generate ad hoc queries
and reports. SYSTEM 2000 statements are English-like and very powerful. You
can use these statements to create databases and for querying, updating, and
reporting, while results and messages appear on your screen in familiar
formats through Display Manager.
All QUEST language retrieval and update statements can specify qualifying
criteria using a where-clause. Easy-to-use syntax gives you relational-like
access to data values and records for retrieval or update. The SYSTEM 2000
retrieval commands are PRINT, LIST, TALLY, and COLLECT.
Facilities in the basic SYSTEM 2000 software include the Self-Contained
Facility, Data Base Manager, Integrated Data Dictionary, Relational Database
Access, Report Writer, QUEST, and a TSO interface. PLEX, the Programming
Language Extension to SYSTEM 2000, is also included in the basic system.
The Self-Contained Facility (SCF) gives you the flexibility of using ad hoc
syntax to query and update your data in a SYSTEM 2000 database. SCF operates
in one of three modes: QUEST, DEFINE, or CONTROL. The QUEST mode lets you query
and update your data. The DEFINE mode provides you access to the internal data
dictionary and allows you to change the database definition. The CONTROL mode
performs database administrator functions.
With SYSTEM 2000 Report Writer you can generate detailed reports from a
single scan of a database. Through a prompt-driven interface, you can
generate standard and custom reports.
SYSTEM 2000 software's Procedural Language Extension (PLEX) facility provides
access to SYSTEM 2000 data from COBOL, FORTRAN, PL/I, and Assembler
programming languages. The heart of the PLEX processor is its ability to
access data at the record level or selected items from a record.
PLEX allows you extra power for loading, searching, and manipulating data. The
powerful networking capabilities in PLEX are ideally suited for production
applications.
You can enhance your system with tools that extend the capabilities of your
SYSTEM 2000 software. Available options include Multi-User software, a CICS
interface, and QueX software, which are licensed separately.
SYSTEM 2000 Multi-User software allocates resources and schedules multiple
users for simultaneous processing. Multi-User software runs in one address
space and communicates with jobs in other address spaces via cross-memory
communications. This process allows a large number of users to retrieve and
update from the same or multiple databases simultaneously, while maintaining
data integrity, security, and automatic recovery. It automatically ensures
data protection during concurrent updates to the same record, and
automatically guards a database against conflicting tasks, even while the
database is being saved.
Multi-User software tracks and manages each user's input and output areas. To
maximize the performance of your applications, Multi-User software has tools
to fine-tune buffer usage and analyze throughput.
The SYSTEM 2000 interface to CICS provides access to SYSTEM 2000 databases
through SCF or user-written PLEX CICS transactions. CICS users share the
databases with batch and TSO users.
The CICS interface provides a communication link between CICS users and the
Multi-User software. The SCF Command Editor enables users with 3270-type
terminals to create, edit, and save SCF command streams.
QueX software is a full-screen, menu-driven, PLEX-based data manipulation
tool that provides controlled online access to databases. You can query and
update one or more SYSTEM 2000 databases with custom-built user views.
Without detailed knowledge of the data structure, you can retrieve any
sequence of related records from multiple databases. Novice users benefit
from a simple fill-in-the-blank approach while applications developers can
use QueX software for full networking and multiple database access.
SAS Institute will work with your organization to provide a customized data
management system that yields immediate rewards.
Since 1976, SAS Institute has been the leader in providing decision support
solutions for business, industry, government, and academic organizations
worldwide. More than 3.5 million users - spanning 120 countries- now rely on
software from SAS Institute, the world's largest privately held software
company.
The Institute's success is due in large measure to its ongoing commitment to
research and development ... as well as continuous technical support,
consulting services, and training options that protect your investment while
ensuring maximum productivity.
When you license SYSTEM 2000 software, you receive continuous technical
support from specialists who understand the intricacies of your operating
system. SAS Institute offers instructor-based training courses especially for
SYSTEM 2000 users, as well as the option to customize courses for your
organization's needs. Our complete, authoritative documentation allows you to
take full advantage of SYSTEM 2000 capabilities.
SAS Institute has established subsidiaries, offices, and distributors in
nearly 60 countries throughout the world to provide local support wherever
your business is located.
For details about training opportunities from SAS Institute, call Professional
Services at (512) 258-5171. Training and education services and a global
network of technical support professionals ensure rapid implementation of
Institute technologies with no disruption
to ongoing processes.