Hosted on MSN

Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it

You've built a perfect Excel table, but the moment you try to use its headers in a drop-down menu, everything breaks. Excel's Data Validation is notoriously picky with tables, but there's a clever ...
Simon Fraser University

DEFINE TABLE Statement

Declare a symbol as a footer in the table and specify the order of the footers. FOOTER Declare a symbol as a header in the table and specify the order of the headers. HEADER Define a symbol that ...
Simon Fraser University

DEFINE HEADER Statement

Define a symbol that references a value that the data component supplies from the procedure or DATA step. DYNAMIC Define a symbol that references a macro variable. ODS will use the value of the ...