re-create excel color

gzr2mz39 — Mon, 27 Feb 2012 23:21:46 GMT

I would like to re-create the excel color with Hue=56, Sat=109, and Lum=185 (or Red=196, Green=215, and Blue=155).

I'm currently using tagsets.excelxp with style=journal.

Thank you.

Re: re-create excel color

Cynthia_sas — Tue, 28 Feb 2012 00:22:56 GMT

Hi:

The easiest way to specify a color is with hexadecimal values. So, if you convert the RGB color numbers to hex values, then the specification would be something like this:

ods tagsets.excelxp ... ;

proc report data=sashelp.class

style(header)={background=cxrrggbb};

...

run;

ods tagsets.excelxp close;

Code sample below. For example, where I have cxrrggbb, you would have cxc4d79b.

cynthia

2508 data _null_;

2509 Red=196;

2510 Green=215;

2511 Blue=155;

2512 put red= hex2. green= hex2. blue= hex2.;

2513 colorval = catt('cx',put(red,hex2.), put(green,hex2.), put(blue,hex2.))

2513! ;

2514 put 'colorval for ods is ' colorval=;

2515 run;

Red=C4 Green=D7 Blue=9B

colorval for ods is colorval=cxC4D79B

topic re-create excel color in ODS and Base Reporting

re-create excel color

Re: re-create excel color