topic Re: Proc report options for ods xlsx in ODS and Base Reporting

Proc report options for ods xlsx

SASdevAnneMarie — Sat, 25 Jul 2020 13:13:07 GMT

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

Re: Proc report options for ods xlsx

PaigeMiller — Sat, 25 Jul 2020 13:19:56 GMT

Do you mean ODS EXCEL?

All the available options are here: https://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVersion=9.4&locale=en#p0258wnlz15ubrn1vqfalp6l4hjz

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

Re: Proc report options for ods xlsx

SASdevAnneMarie — Sat, 25 Jul 2020 13:22:15 GMT

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

Re: Proc report options for ods xlsx

Cynthia_sas — Sat, 25 Jul 2020 13:27:07 GMT

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

Re: Proc report options for ods xlsx

SASdevAnneMarie — Sat, 25 Jul 2020 13:29:20 GMT

Thank you, Cynthia!