Proc report options for ods xlsx

[SASdevAnneMarie]

Hello Experts,

I know the option for putting a name to proc report (ods xlsx like:

options(sheet_name='Products')

I would like to have the Product in white color and background in blue color.

Do you know, please, how I can write this options?

Thank you very much!

Best regards,

Marie

[PaigeMiller · Accepted solution]

Do you mean ODS EXCEL?

All the available options are here: https://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVe...

I'm pretty sure you can't change the color of the sheet_name or the background of the sheet_name via ODS EXCEL.

[SASdevAnneMarie]

Thank you,
I suppose that I can't, just need a confirmation 🙂

[Cynthia_sas]

Hi:
Changing the characteristics of the sheet name cannot be done with PROC REPORT. In addition, ODS EXCEL does not have any options or suboptions to change the sheet name font or color.
Hope this helps,
Cynthia

[SASdevAnneMarie]

Thank you, Cynthia!