SAS/CONNECT User's Guide

Syntax for the EXCLUDE Statement

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

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

EXCLUDE list</ MEMTYPE=mtype>;

When you use the EXCLUDE statement to exclude members of a library from uploading, list specifies the members to exclude from uploading. 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 uploaded.
- (hyphen): specifies all member names that fall lexicographically between the names 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 EXCLUDE statement with the INCAT= and OUTCAT= options in the PROC UPLOAD statement:

EXCLUDE list</ ENTRYTYPE=etype>;

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

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

.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 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.

Chapter Contents
Previous
Next
Top of Page

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