DATASETS Procedure
- Syntax
Procedure SyntaxPROC DATASETS StatementAGE StatementAPPEND StatementATTRIB StatementAUDIT StatementCHANGE StatementCONTENTS StatementCOPY StatementDELETE StatementEXCHANGE StatementEXCLUDE StatementFORMAT StatementIC CREATE StatementIC DELETE StatementIC REACTIVATE StatementINDEX CENTILES StatementINDEX CREATE StatementINDEX DELETE StatementINFORMAT StatementLABEL StatementMODIFY StatementREBUILD StatementRENAME StatementREPAIR StatementSAVE StatementSELECT Statement - Overview
- Concepts
- Results
- Examples Removing All Labels and Formats in a Data SetManipulating SAS FilesSaving SAS Files from DeletionModifying SAS Data SetsDescribing a SAS Data SetConcatenating Two SAS Data SetsAging SAS Data SetsODS Output Getting Sort Indicator InformationUsing the ORDER= Option with the CONTENTS StatementInitiating an Audit File
EXCLUDE Statement
Excludes SAS files from copying.
| Restrictions: | Must follow a COPY statement
Cannot appear in the same COPY step with a SELECT statement |
| Example: | Manipulating SAS Files |
Syntax
Required Argument
- SAS-file-1 <...SAS-file-n>
-
specifies one or more SAS files to exclude from the copy operation. All 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 versions.
Optional Argument
- MEMTYPE=mtype
-
restricts processing to one member type. You can use the option either in parentheses after the name of each SAS file or after a forward slash.Alias: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.