topic Proc tabulete - paint higher values background. in SAS Enterprise Guide

Proc tabulete - paint higher values background.

Matt3 — Fri, 21 Jul 2017 17:32:38 GMT

Hello,

Is there any way to paint background in eg. 10 percent (or just 10) of higher values in proc tabulate report?

I can use proc format when i know the values but I have a lot of large tables with different variables, thus I would like paint just higher values in each table. Appreciate any help.

Re: Proc tabulete - paint higher values background.

Reeza — Fri, 21 Jul 2017 17:34:27 GMT

You can't do it dynamically within the tabulate procedure, AFAIK, but you could probably dynamically generate your ranges and that would require pre summarizing your data, figuring out the boundaries, creating the custom format and then applying it with proc tabulate.