topic Re: ODS excelXP PROC REPORT in SAS Programming

ODS excelXP PROC REPORT

twildone — Tue, 25 Mar 2014 23:50:30 GMT

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.

Re: ODS excelXP PROC REPORT

Cynthia_sas — Wed, 26 Mar 2014 03:05:20 GMT

Hi:

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'

style=sasweb options(sheet_interval='none');

proc report data=sashelp.class(obs=3) nowd

style(header)=Header{background=gray};

columns name age sex height weight;

run;

proc report data=sashelp.cars(obs=3) nowd;

columns make model type msrp mpg_city;

run;

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.

cynthia

Re: ODS excelXP PROC REPORT

twildone — Wed, 26 Mar 2014 13:57:20 GMT

Hi Cynthia,

Thanks for your response and suggestion. I have update the original post to include a sample of the output.