Hi:
As @Tom explained, without data or code, it is hard to make a specific recommendation. However, using different data, such as SASHELP.SHOES, I can illustrate how you would get a separate table for every ACROSS item. In the PROC REPORT below, report 1 shows 4 Products (could be 4 treatments). Then underneath each PRODUCT, I have 2 variables -- SALES and RETURNS and with a regular ACROSS usage for PRODUCT, the result is 1 table with a set of columns for each unique value of PRODUCT, as shown below:
If I want to still get a separate table for each unique value of PRODUCT and still use PRODUCT as an ACROSS item, I need to pre-sort the data and use BY PRODUCT inside PROC REPORT. PROC REPORT with a BY will produce a separate table for every BY group (in this case, PRODUCT). So the PROC REPORT code with BY will now generate 1 table for each PRODUCT. The NOBYLINE option suppresses the BYLINE that would normally be underneath each title and on top of the table.
Using PAGE with ACROSS is not something I really recommend. BY group processing is more reliable.
Hope this helps,
Cynthia
... View more