Chapter Contents


The DATASETS Procedure

EXCLUDE Statement

Excludes SAS files from copying.

Restriction: Must follow a COPY statement
Restriction: Cannot appear in the same COPY step with a SELECT statement
Featured in: Manipulating SAS Files

EXCLUDE SAS-file(s) </ MEMTYPE=mtype>;

Required Arguments

specifies one or more SAS files to exclude from the copy operation. All the SAS files you name in the EXCLUDE statement must be in the library that is specified in the IN= option in the COPY statement. If the SAS files are generation groups, the EXCLUDE statement allows only selection of the base names.


restricts processing to one member type (mtype).
Aliases: MTYPE=, MT=
Default: If you do not specify MEMTYPE= in the PROC DATASETS statement, the COPY statement, or in the EXCLUDE statement, the default is MEMTYPE=ALL.
See also: Restricting Member Types Available for Processing and Specifying Member Types When Copying or Moving SAS Files

Excluding Many Like-Named Files
You can use shortcuts for listing many SAS files in the EXCLUDE statement. For more information, see Shortcuts for Specifying Lists of Variable Names .

Chapter Contents



Top of Page

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