SAS/CONNECT User's Guide

Syntax for the SELECT Statement

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

The SELECT statement enables you to select for uploading 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 UPLOAD step, but you can specify multiple SELECT statements.

The SELECT statement can have two forms, which are discussed in detail in the next two sections.

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 UPLOAD statement:

SELECT list</ MEMTYPE=mtype>;

When you use the SELECT statement to select members of a library for uploading, list specifies the members to select for uploading. 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 that are on either side of the hyphen. You can use this wild-card 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 UPLOAD statement:

SELECT list</ ENTRYTYPE=etype>;

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

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

.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 UPLOAD 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 uploaded into the remote SAS catalog in the order that you specify them in the SELECT statement.

See Using Data Transfer Services for an example that illustrates 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 uploading.
.type	is the type of the catalog entry. This part of the name is optional.