I think there is a feature with the ExcelXP tagset with Proc Tabulate that makes nice reports but merges cells in a way that makes working with the data in Excel difficult.
The example from the paper "ODS MARKUP: The SAS® Reports You've Always Dreamed Of" by Eric A. Gebhart has a example that combines tables in one sheet, which is exactly what I wanted to do. I used this approack and created very nice reports, but when I tried to pass the data to Chart, the data in the first row was in in the header row.
This example illustrated my problem. (from page 14 in Eric's paper)
This is what the table looks like
Predicted Actual
Region Division Product Type
East Consumer Furniture cell 1,1 cell 1,2
Office cell 2,1 cell 2,2
These are the cells that contain the data,
Predicted Actual
Region Division Product Type cell 1,1 cell 1,2
East Consumer Furniture
Office cell 2,1 cell 2,2
The XML shows this for the rows in question (I added breaks to show the data)
Region |
Division |
Product type |
11081 |
12483 |
EAST |
CONSUMER |
FURNITURE |
Does anyone know if there is a way to stop merging the data cells?
Thanks
Ed