SAS/CONNECT User's Guide

Syntax for the EXCLUDE Statement

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

The EXCLUDE statement enables you to exclude from 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 EXCLUDE statements.

The EXCLUDE 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 EXCLUDE statement with the INLIB= and OUTLIB= options in the PROC DOWNLOAD statement:

EXCLUDE list</ MEMTYPE=mtype>;

When you use the EXCLUDE statement to exclude members of a library from downloading, list specifies the members to exclude from downloading. You can explicitly name all members to exclude 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:, none of the members that begin with the letters TEST are downloaded.
- (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 EXCLUDE statement with the INCAT= and OUTCAT= options in the PROC DOWNLOAD statement:

EXCLUDE list</ ENTRYTYPE=etype>;

When you use the EXCLUDE statement to exclude catalog entries from downloading, each element of list has the form entry.type.

entry is the name of an entry in the catalog to exclude from downloading.

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

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

Chapter Contents
Previous
Next
Top of Page

entry	is the name of an entry in the catalog to exclude from downloading.
.type	is the type of the catalog entry. This part of the name is optional.