Colour scalling bassed on values in ODS Excel

krishnareddy1 — Fri, 01 Feb 2019 03:32:26 GMT

HI all,

I am trying to fill background with colours of columns based on their ranks or values . i want colour scalling like excel . can you plesse guyz help me.

note: the values in column will change even though auto fill colours like colour scalling like excel.

thank you,

regards,

krishna reddy

Re: Colour scalling bassed on values in ODS Excel

Reeza — Fri, 01 Feb 2019 04:08:25 GMT

You can use PROC REPORT for this.

Here's an example:

http://support.sas.com/kb/54/675.html

ODS Excel documentation has an example of custom colouring as well:

https://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVersion=9.4&locale=en#p1hoqu3lkmdf6wn1stuwbyt7yyua

If you need further help, please provide more details about what you're trying to do and what issues you're having.

@krishnareddy1 wrote:

HI all,

I am trying to fill background with colours of columns based on their ranks or values . i want colour scalling like excel . can you plesse guyz help me.

note: the values in column will change even though auto fill colours like colour scalling like excel.

thank you,

regards,

krishna reddy

topic Colour scalling bassed on values in ODS Excel in SAS Programming

Colour scalling bassed on values in ODS Excel

Re: Colour scalling bassed on values in ODS Excel