Excludes
entries from processing by the FMTLIB and CNTLOUT= options.
| Restriction: |
Only one EXCLUDE 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.
|
- entry(s)
- specifies one or more catalog entries to exclude from 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 EXCLUDE
statement. Follow these rules when specifying entries in the EXCLUDE statement:
- Precede names of entries that contain character formats with a
dollar sign ($).
- Precede names of entries that contain numeric informats with an
at sign (@).
- Precede names of entries that contain character informats with
an at sign and a dollar sign (for example, @$entry-name).
You can use the colon (:) and
hyphen (-) wildcard characters
to exclude entries. For example, the following EXCLUDE statement excludes
all formats or informats that begin with the letter a.
exclude a:;
In addition, the following EXCLUDE statement excludes all formats or
informats that occur alphabetically between apple
and pear, inclusive:
exclude apple-pear;
If you use the EXCLUDE statement without either FMTLIB
or CNTLOUT=
in the PROC FORMAT statement, the procedure invokes FMTLIB.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
