SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

QUEST Procedure Syntax

PROC QUEST <S2KMODE= M|S> <BLANKS>;

MCS;

QUIT;

SCS;

SYSTEM 2000 statement;

SAS statements that can be issued anywhere, for example, TITLE and FILENAME, are also available when you are using the QUEST procedure.

Note: If you issue a RUN statement, the SAS System ignores it during a QUEST session. [cautionend]

Description

The QUEST procedure enables you to access SYSTEM 2000 software from within the SAS System to perform a variety of tasks, for example,

retrieving data from a database
updating data in a database
defining a new database
assigning passwords to a database
saving a database
restoring a database
enabling rollback.

The QUEST procedure is interactive. You enter SYSTEM 2000 statements, and the SYSTEM 2000 software executes them as soon as you submit them. You do not need a RUN statement.

PROC QUEST Statement Options

You can use the PROC QUEST statement without any arguments. Do not use any arguments if you want to use the QUEST procedure in a Multi-User environment. Also, by default, the SAS System will delete leading, trailing, and extraneous embedded blanks in SYSTEM 2000 statements.

The following options can be used with the PROC QUEST statement:

S2KMOD|S2KMD= M|S

specifies your mode of accessing SYSTEM 2000 software, M for Multi-User or S for single-user. Use M to access Multi-User SYSTEM 2000 software running in a different CMS machine or OS/390 address space. Use S to load and execute your own copy of SYSTEM 2000 software in your machine or address space. The default is M.

S2KMD= is an alias for S2KMODE=. (ACCESS=, ACC=, DBACCESS=, and DBACC=, which were available for Version 5, are also acceptable synonyms.)

BLANKS|BLANK

retains all blanks in SYSTEM 2000 statements and passes them along to SYSTEM 2000 software. If you do not specify the BLANKS option, SAS software deletes extraneous blanks by default; that is, leading, trailing, and multiple blanks between words are stripped from the statements before SYSTEM 2000 reads the statements. You can specify the BLANKS option in order to retain blanks in LIST column headings, TEXT values, and report titles and headings. BLANK is an alias for BLANKS.

Procedure Statements

The QUEST procedure statements specify how SYSTEM 2000 statements will be submitted within the QUEST procedure: a command at time (single command submission) or as a series of queued commands (multiple command submission). Or, you can submit SYSTEM 2000 statements in a Command File and not use any statements.

Multiple command submission and Command Files are supported only in Multi-User access mode.

The QUEST statements are described below. All of the statements are optional. Guidelines for specifying SYSTEM 2000 statements are provided in SYSTEM 2000 Statement. For information about the single-user and Multi-User execution environments, see Single-User and Multi-User Operation.

Chapter Contents
Previous
Next
Top of Page