A Simple Write Up that Teaches All the Tricks of PROC FORMAT

Take a look at this write up. A very nice teaching notes which explains with simple examples how to use the full power of PROC FORMAT.

- http://www2.sas.com/proceedings/sugi31/249-31.pdf

This includes

- Table look up using Proc Format

- Using Proc Format for finding unexpected values

- Generating new variables with Proc Format

- Using 2-Dimensional table look up
More examples of 2-dimensional and 3-dimensional table lookups using PROC FORMAT can be found in SUGI31
paper by Perry Watts, "Using Database Principles to Optimize SAS® Format Construction from Tabular Data".

- Using PROC FORMAT to extract data

- Specifying ranges of values in PROC FORMAT

- Using PROC FORMAT for Data merges

- Creating Multilabel formats

- Saving formats