Previous Page | Next Page

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-1 <...SAS-file-n>
</ <ALTER=alter-password>
<MEMTYPE= mtype>>;


Required Arguments

SAS-file-1 <...SAS-file-n>

specifies one or more SAS files that you want to copy. All of the SAS files that 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 have generation groups, the SELECT statement allows only selection of the base versions.


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 library, you need alter access. You can use the option either in parentheses after the name of each SAS file or after a forward slash.

See also: Using Passwords with the DATASETS Procedure
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.

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

Restricting Member Types 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.

Previous Page | Next Page | Top of Page