SAS/CONNECT User's Guide

Syntax for the SELECT Statement

SELECT list</ MEMTYPE=mtype |
ENTRYTYPE=etype>;

The SELECT statement enables you to select for downloading specific members in a SAS data library or specific entries in a SAS catalog. You cannot use both the EXCLUDE and SELECT statements in the same PROC DOWNLOAD step, but you can specify multiple SELECT statements.

The SELECT statement can have two forms, members of a SAS Data Library and entries of a SAS Catalog. Both of these forms are discussed in detail.

Members of a SAS Data Library

You can use the following form of the SELECT statement with the INLIB= and OUTLIB= options in the PROC DOWNLOAD statement:

SELECT list</ MEMTYPE=mtype>;

When you use the SELECT statement to select members of a library for downloading, list specifies the members to select for downloading. You can explicitly name all members to select or use one of the following forms of name lists:

: (colon): specifies all member names that begin with the string of characters that immediately precede the colon. For example, if you specify TEST:, all of the selected members begin with the letters TEST.
- (hyphen): specifies all member names that fall lexicographically between the names on either side of the hyphen. You can use this wildcard character only between two names that begin with the same string of characters and end in a number, for example, TEST1-TEST5.

For information about using the MEMTYPE= option, see Using the MEMTYPE= Option.

Entries in a SAS Catalog

You can use the following form of the SELECT statement with the INCAT= and OUTCAT= options in the PROC DOWNLOAD statement:

SELECT list</ ENTRYTYPE=etype>;

When you use the SELECT statement to select catalog entries for downloading, each element of list has the form entry.type.

entry is the name of an entry in member to select for downloading.

.type is the type of the catalog entry. This part of the name is optional.

The ENTRYTYPE= option in the SELECT statement works like the ENTRYTYPE= option in the PROC DOWNLOAD statement. For a complete list of entry types and for detailed information about how to use the ENTRYTYPE= option, see Using the ENTRYTYPE= Option.

Note: The SELECT statement also enables you to maintain an ordering and grouping of catalog entries that contain graphics output, because entries are downloaded into the local SAS catalog in the order that you specify them in the SELECT statement.

See Using Data Transfer Services for examples that illustrate how to use the SELECT statement to maintain the order and grouping of catalog entries that contain graphics output. [cautionend]

Chapter Contents
Previous
Next
Top of Page

entry	is the name of an entry in member to select for downloading.
.type	is the type of the catalog entry. This part of the name is optional.