Chapter Contents


The FORMAT Procedure

SELECT Statement

Selects entries from processing by the FMTLIB and CNTLOUT= options.

Restriction: Only one SELECT statement can appear in a PROC FORMAT step.
Restriction: You cannot use a SELECT statement and an EXCLUDE statement within the same PROC FORMAT step.
Featured in: Printing the Description of Informats and Formats .

SELECT entry(s);

Required Arguments

specifies one or more catalog entries for processing. Catalog entry names are the same as the name of the informat or format that they store. Because informats and formats can have the same name, and because character and numeric informats or formats can have the same name, you must use certain prefixes when specifying informats and formats in the SELECT statement. Follow these rules when specifying entries in the SELECT statement:

Shortcuts to Specifying Names
You can use the colon (:) and hyphen (-) wildcard characters to select entries. For example, the following SELECT statement selects all formats or informats that begin with the letter a.

select a:;

In addition, the following SELECT statement selects all formats or informats that occur alphabetically between apple and pear, inclusive:

select apple-pear;

If you use the SELECT statement without either FMTLIB or CNTLOUT= in the PROC FORMAT statement, the procedure invokes FMTLIB.

Chapter Contents



Top of Page

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