The PROC FREQ crosstab table (TABLES A*B) now has a table template to define it. This adds functionality for traffic lighting and format control much like what was available in previous releases with PROC TABULATE and PROC REPORT, and for one-way tables created by PROC FREQ (TABLES A B).

However, the underlying code for this table uses stacked columns which is not currently supported by the EXCELXP tagset. A crosstab table directed to Excel with the EXCELXP tagset will show the row and column headers, but no data.

To circumvent the problem, use the CROSSLIST option on the TABLES statement so that the crosstab tables come out as simple tables. For example:

TABLES A*B / CROSSLIST;

You can also create Excel files using the MSOFFICE2K tagset which can handle stacked tables.

Operating System and Release Information