CPORT Procedure

EXCLUDE Statement

Excludes specified files or entries from the transport file.

Interaction:	You can use either EXCLUDE statements or SELECT statements in a PROC CPORT step, but not both.
Tip:	There is no limit to the number of EXCLUDE statements that you can use in one invocation of PROC CPORT.

SAS file(s) | catalog entry(s): specifies one or more SAS files or one or more catalog entries to be excluded from the transport file. Specify SAS filenames when you export a SAS library; specify catalog entry names when you export an individual SAS catalog. Separate multiple filenames or entry names with a space. You can use shortcuts to list many like-named files in the EXCLUDE statement. For more information, see Shortcuts for Specifying Lists of Variable Names.

Tip
Refer to Names in the SAS Language in SAS Language Reference: Concepts for naming conventions that you can use for names and member names.

ENTRYTYPE=entry-type: specifies a single entry type for the catalog entries listed in the EXCLUDE statement. See SAS Language Reference: Concepts for a complete list of catalog entry types.

Alias:ETYPE=, ET=

Restriction:ENTRYTYPE= is valid only when you export an individual SAS catalog.

MEMTYPE=mtype: specifies a single member type for one or more SAS files listed in the EXCLUDE statement. Valid values are CATALOG or CAT, DATA, or ALL. If you do not specify the MEMTYPE= option in the EXCLUDE statement, then processing is restricted to those member types specified in the MEMTYPE= option in the PROC CPORT statement.

You can also specify the MEMTYPE= option, enclosed in parentheses, immediately after the name of a file. In parentheses, MEMTYPE= identifies the type of the filename that just precedes it. When you use this form of the option, it overrides the MEMTYPE= option that follows the slash in the EXCLUDE statement, but it must match the MEMTYPE= option in the PROC CPORT statement:

Alias:MTYPE=, MT=

Default:If you do not specify MEMTYPE= in the PROC CPORT statement or in the EXCLUDE statement, the default is MEMTYPE=ALL.

Restrictions:MEMTYPE= is valid only when you export a SAS library.

If you specify a member type for MEMTYPE= in the PROC CPORT statement, it must agree with the member type that you specify for MEMTYPE= in the EXCLUDE statement.