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 that you can use in one invocation of PROC CIMPORT. |
Syntax
Required Argument
- 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.TipRefer to Names in the SAS Language in SAS Language Reference: Concepts for naming conventions that you can use for names and member names.
Optional Arguments
- 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:ALLRestriction:MEMTYPE= is valid only when you import a SAS library.