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

SAS-file(s): 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.

Options

ALTER=alter-password

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.

MEMTYPE=mtype

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
Previous
Next
Top of Page

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