ODS excelXP PROC REPORT

Reply
Regular Contributor
Posts: 229

ODS excelXP PROC REPORT

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.

Attachment
SAS Super FREQ
Posts: 8,861

Re: ODS excelXP PROC REPORT


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


mult_rept_one_sheet.png
Regular Contributor
Posts: 229

Re: ODS excelXP PROC REPORT

Posted in reply to Cynthia_sas

Hi Cynthia,

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

Ask a Question
Discussion stats
  • 2 replies
  • 205 views
  • 3 likes
  • 2 in conversation