03-25-2014 07:50 PM
Hi...I am creating a report that has multiple tables on one worksheet. The problem that I am experiencing is that the PROC REPORT colors the cell immediately after the tables Grey in column A ( the color that I have specified for the header) and remaining cells in this row is the background color. Is there a way to suppress this or prevent this from happening so that the row separating each table is the same background color. Thanks in advance.
03-25-2014 11:05 PM
Without seeing your code (ALL your code, including ODS statements), it is nearly impossible to visualize what you mean when you say that "The problem that I am experiencing is that the PROC REPORT colors the cell immediately after the tables Grey in column A ( the color that I have specified for the header) and remaining cells in this row is the background color."
I don't know what you mean when you say "colors the cell immediately after the tables grey in column A). When I run a test with 2 tables on one sheet (one for SASHELP.CLASS and one for SASHELP.CARS) I see only the color change that I have coded headers in the first table are gray because I had this statement for the first PROC REPORT.
ods tagsets.excelxp file='c:\temp\multsheet.xml'
proc report data=sashelp.class(obs=3) nowd
columns name age sex height weight;
proc report data=sashelp.cars(obs=3) nowd;
columns make model type msrp mpg_city;
ods tagsets.excelxp close;
You might want to work with Tech Support on this. They can look at all your code and your output and try to replicate and then fix what you are experiencing.