PROC TABULATE by Example, Second Edition

Create Footnote References in Table Cells - II

The previous example showed how to add footnote references to explain a particular row, column, or cell in the data. Another way that you can use footnotes is to identify a particular range of values. For example, you might want to identify all cells where income is less than $20,000 or greater than $100,000.

To assign a footnote reference to a range of values, you can use a PICTURE format. In this first example, all values of $20,000 or more are formatted as integers. The integers are given a width of 10 so that the columns will be wide enough to fit the headings. But values under $20,000 are displayed as an asterisk, referencing the footnote "<$20,000".

PROC FORMAT; PICTURE LOWNOTE LOW-<20000='*' ...