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
... View more