topic Re: Shades of color using Excelxp in ODS and Base Reporting

Shades of color using Excelxp

JasonNC — Thu, 06 Oct 2016 21:08:09 GMT

Hi,

I am using excel xp and proc report to generate my report.If i want to use different shades of color how to use it

For ex: If i want to use shade of blue instead of dark or light as we have options in excel how can i tell which shade of blue to use

Re: Shades of color using Excelxp

Cynthia_sas — Thu, 06 Oct 2016 22:41:58 GMT

Hi:

Typically, you use a STYLE(area)= override in the PROC REPORT syntax or else you change the style template. Here's an example of the using the override in the PROC REPORT syntax.

cynthia

Re: Shades of color using Excelxp

Reeza — Thu, 06 Oct 2016 22:44:33 GMT

If you feel like digging, Vince Del Gobbo's index is a great place to find the answers.

Find the topic in the first column and then it tells you what paper and page has the answer. There's usually code examples.

http://www.sas.com/events/cm/867226/ExcelXPPaperIndex.pdf

Re: Shades of color using Excelxp

ballardw — Thu, 06 Oct 2016 23:14:51 GMT

Be prepared to see fewer colors than expected if you use close shades. Excel has a habit of taking colors that are similar and only displaying one close its default list.