The 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 you can use in one invocation of PROC CPORT.

EXCLUDE SAS file(s) | catalog entry(s)</ MEMTYPE=mtype></ ENTRYTYPE=entry-type>;

Required Arguments

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.

Options

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.
Restriction:	MEMTYPE= is valid only when you export a SAS library.
Restriction:	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.

Top of Page