Chapter Contents


The DATASETS Procedure

SELECT Statement

Selects SAS files for copying.

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

SELECT SAS-file(s)
</ <ALTER=alter-password>
<MEMTYPE= mtype>>;

Required Arguments

specifies one or more SAS files that you want to copy. All the SAS files you name must be in the data library that is referenced by the libref named in the IN= option in the COPY statement. If the SAS files are generation groups, the SELECT statement allows only selection of the base names.


provides the alter password for any alter-protected SAS files that you are moving from one data library to another. Because you are moving, and thus deleting, a SAS file from a SAS data library, you need alter access. You can use the ALTER= option in parentheses after the name of each SAS file or after a forward slash.
See also: Using Passwords with the DATASETS Procedure

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

Selecting Many Like-Named Files
You can use shortcuts for listing many SAS files in the SELECT 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.