Chapter Contents


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

SYSTEM 2000 Statement

The SYSTEM 2000 statement in the QUEST procedure can be any valid SYSTEM 2000 statement that is available in the Self-Contained Facility, including

For more information, see the SYSTEM 2000 Quick Reference Guide.

Note:    When you submit SYSTEM 2000 statements through the QUEST procedure, the statements are subject to SAS syntax rules. For example, statements must end with a semicolon (;) instead of a colon (:), '/*' and '*/' delimit comments, and so on. SYSTEM 2000 statements containing a character literal longer than 200 characters are rejected.

Also, if you want to use the single quote or the double quote as the delimiter in a SYSTEM 2000 where-clause, you must use one of the techniques described below. Otherwise, the quotes cause ambiguity between the SAS System parser and the SYSTEM 2000 parser.  [cautionend]

A quoted string is required if the SYSTEM 2000 where-clause condition contains

Also, you might want to use quoted strings simply because you are accustomed to using them in other systems.

To use the single quote or double quote around a value in a where-clause condition, you can use either of these methods:

If a value contains a single quote, change the delimiter to the double quote with one of the methods shown above.


SYSTEM 2000 messages are displayed on the log window, along with SAS System messages.

The ECHO ON statement displays echoes of SYSTEM 2000 statements in the output window along with the statement's output. This is convenient for debugging or interpreting results.

With ECHO OFF, the SYSTEM 2000 statement echoes do not appear in the output window.

Note:   If you use ECHO ON and the MCS statement, often the echo of a SYSTEM 2000 command will not appear immediately above the output for the command.   [cautionend]

SYSTEM 2000 Strings and Functions

You will probably need to modify any existing SYSTEM 2000 strings and functions for the QUEST procedure because

To avoid problems with the system separator, issue the SEPARATOR IS statement to change the separator. For example, the following statement changes the separator to the # sign:

      separator is #;

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.