The CIMPORT Procedure

EXCLUDE Statement

Excludes specified files or entries from the import process.

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

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 import process. Specify SAS filenames if you import a library; specify catalog entry names if you import 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 one or more catalog entries that are 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 import an individual SAS catalog.

MEMTYPE=mtype

specifies a single member type for one or more SAS files listed in the EXCLUDE statement. Values for mtype can be

ALL: both catalogs and data sets
CATALOG: catalogs
DATA: SAS data sets.

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

Alias:	MTYPE=, MT=
Default:	ALL
Restriction:	MEMTYPE= is valid only when you import a SAS library.

Top of Page