SAS SQL Query Window User's Guide

Invoking the SQL Query Window

You can invoke the SQL Query Window in one of the following ways:

From the SAS Display Manager PROGRAM EDITOR window, issue the QUERY command from the command line.

You can also specify these optional arguments:

profile= the name of a user-defined profile that you want to use for your SQL Query Window session. You can specify a profile by using the following syntax:
profile=libname.catalog.profile

access= the access mode (source of the data that you are going to use) for the SQL Query Window session.

active= data= the name of the table (active SAS data set) that you want to use in your initial query.
You can select more than one table by using the following syntax:
data = 'table1, table2'

where table1 and table2 are the names of the tables that you want to use in your initial query.
If you use this argument, the SQL Query Window is invoked with the table(s) already selected, and you go directly to the SQL QUERY COLUMNS window.

include= the name of a stored query that you want to include in your SQL Query Window session. You can include a stored query by using the following syntax:
include=libname.catalog.query

where libname is the libname, catalog is the catalog in which the query is stored, and query is the query name.
If you use this argument, the SQL Query Window is invoked with the query components already selected, and you go directly to the SQL QUERY COLUMNS window.

If you have SAS/ASSIST software installed at your site, follow either of these selection paths, starting from the Primary Menu:

Data Mgmt. Query SQL Query
From a SAS/AF application, the method you use depends on whether the application has a frame or program screen:
- If the application has a frame or program screen, you can invoke it with this command:
```
SUBMIT COMMAND CONTINUE;
   QUERY
ENDF SUBMIT;
```
  Following the QUERY statement, you can specify any of the optional arguments that were described earlier for the PROGRAM EDITOR window.
- If the application has no frame or program screen, you can invoke it with a CALL EXECCMD statement:
```
CALL EXECCMD ('QUERY');
```
  Optional arguments can follow the word QUERY and must precede the closing quote.

Chapter Contents
Previous
Next
Top of Page

profile=	the name of a user-defined profile that you want to use for your SQL Query Window session. You can specify a profile by using the following syntax: profile=libname.catalog.profile
access=	the access mode (source of the data that you are going to use) for the SQL Query Window session.
active= data=	the name of the table (active SAS data set) that you want to use in your initial query. You can select more than one table by using the following syntax: data = 'table1, table2' where table1 and table2 are the names of the tables that you want to use in your initial query. If you use this argument, the SQL Query Window is invoked with the table(s) already selected, and you go directly to the SQL QUERY COLUMNS window.
include=	the name of a stored query that you want to include in your SQL Query Window session. You can include a stored query by using the following syntax: include=libname.catalog.query where libname is the libname, catalog is the catalog in which the query is stored, and query is the query name. If you use this argument, the SQL Query Window is invoked with the query components already selected, and you go directly to the SQL QUERY COLUMNS window.