Chapter Contents


The CIMPORT Procedure

EXCLUDE Statement

Excludes specified files or entries from the import process.

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

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

Required Arguments

SAS file(s) | catalog entry(s)
specifies either the name(s) of one or more SAS files or the name(s) of one or more catalog entries to be excluded from the import process. Specify SAS file names if you import a data library; specify catalog entry names if you import an individual SAS catalog. Separate multiple file names 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 .


specifies a single entry type for the catalog entry(s) listed in the EXCLUDE statement. See SAS Language Reference: Concepts for a complete list of catalog entry types.
Restriction: ENTRYTYPE= is valid only when you import an individual SAS catalog.
Alias: ETYPE=, ET=

specifies a single member type for the SAS file(s) listed in the EXCLUDE statement. Values for mtype can be

both catalogs and data sets


SAS data sets.

You can also specify the MEMTYPE= option, enclosed in parenthesis, immediately after the name of a file. In parenthesis, 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.
Restriction: MEMTYPE= is valid only when you import a SAS data library.
Alias: MTYPE=, MT=
Default: ALL

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.