Using SAS Output Delivery System (ODS) Markup to Generate Custom PivotTable and PivotChart Reports
One of Microsoft Excel's most powerful features is its ability to create PivotTable reports. A PivotTable report is an interactive table that enables one to summarize output as well as to change the view of the data dynamically by dragging and dropping the various table components. PivotTable reports are designed to be very flexible, and analysis is fast because the data is stored in a special cache. In the SAS System, the closest equivalent to a PivotTable report is what seasoned SAS users call banner reports, which are created with the TABULATE procedure. However, PROC TABULATE does not enable one to change the data view without re-running the analysis.