Chapter Contents


The CIMPORT Procedure

SELECT Statement

Specifies individual files or entries to import.

Tip: There is no limit to the number of SELECT statements you can use in one invocation of PROC CIMPORT.
Interaction: You can use either EXCLUDE statements or SELECT statements in a PROC CIMPORT step, but not both.
Featured in: Importing Individual Catalog Entries

SELECT SAS file(s) | catalog entry(s)</ MEMTYPE=mtype></ ENTRYTYPE=entry-type>;

Required Arguments

SAS file(s) | catalog entry(s)
specifies either the name(s) of one or more SAS files or the name(s) of one or more catalog entries to import. Specify SAS filenames if you import a data library; specify catalog entry names if you import an individual SAS catalog. Separate multiple filenames or entry names with a space. You can use shortcuts to list many like-named files in the SELECT statement. For more information, see Shortcuts for Specifying Lists of Variable Names .


specifies a single entry type for the catalog entry(s) listed in the SELECT statement. See SAS Language Reference: Concepts for a complete list of catalog entry types.
Restriction: ENTRYTYPE= is valid only when you import an individual SAS catalog.
Alias: ETYPE=, ET=

specifies a single member type for the SAS file(s) listed in the SELECT statement. Valid values are CATALOG or CAT, DATA, or ALL.

You can also specify the MEMTYPE= option, enclosed in parenthesis, immediately after the name of a file. In parenthesis, MEMTYPE= identifies the type of the file name that just precedes it. When you use this form of the option, it overrides the MEMTYPE= option that follows the slash in the SELECT statement, but it must match the MEMTYPE= option in the PROC CIMPORT statement.
Restriction: MEMTYPE= is valid only when you import a SAS data library.
Alias: MTYPE=, MT=
Default: ALL

Chapter Contents



Top of Page

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