SAS Certification Prep Guide, 4th Edition

Managing Custom Formats

Using FMTLIB with PROC FORMAT to Document Formats

When you have created a large number of permanent formats, it can be easy to forget the exact spelling of a specific format name or its range of values. Remember that adding the keyword FMTLIB to the PROC FORMAT statement displays a list of all the formats in the specified catalog, along with descriptions of their values.

libname myfmts 'c:\sas\newfmt';
proc format lib=myfmts fmtlib;
run;

You can also use the SELECT and EXCLUDE statements to process specific formats rather than an entire catalog.

General form, PROC FORMAT with FMTLIB and the SELECT and EXCLUDE statements: PROC FORMAT LIB=library FMTLIB; SELECT format-name; EXCLUDE format-name; RUN; Here is an ...