topic Re: TABULATE - Can I colour an entire row based on the label format (inherited style?) in New SAS User

TABULATE - Can I colour an entire row based on the label format (inherited style?)

Andrew_ — Tue, 13 Nov 2018 09:52:12 GMT

I recently found out how to colour specific classes in a table using format (please see this resource I found which introduced me to <parent> syntax! http://www2.sas.com/proceedings/sugi29/085-29.pdf

Anyway, I have a complex, highly dimensional table and I would like to colour any rows that belong to a specific label (i.e. the lowest level) so that my audience (who are specifically interested in one category) can see these quickly for each variable. I will report many variables and they will have a category which I would like to highlight in each.

So, this first image shows an example table where I've coloured the class (blue) and each of the individual labels in alternative colours to make it easier to read (using SAS) - so a good start. What I would like is shown in the second image.

In the second image, I would like all numeric values related to that label (with, say, an underlying value of 9) to have inherited the style from that label.

Is this possible?

Re: TABULATE - Can I colour an entire row based on the label format (inherited style?)

RW9 — Tue, 13 Nov 2018 09:58:20 GMT

Its called traffic lighting and there are tonnes of articles out there, for example:

http://www2.sas.com/proceedings/sugi31/142-31.pdf

Re: TABULATE - Can I colour an entire row based on the label format (inherited style?)

Andrew_ — Tue, 13 Nov 2018 10:01:26 GMT

Thank you very much for the quick response. I am aware of the 'traffic lighting', however, this seems to colour a cells based on the cells underlying value. I'm looking to colour an entire row, based on the lowest level of a classes value. The table could have 5 variables, each with a yes or no label. I'd like to highlight all 'yes' rows with the same colour.

Does this make sense?

Re: TABULATE - Can I colour an entire row based on the label format (inherited style?)

RW9 — Tue, 13 Nov 2018 10:56:21 GMT

In proc report you would use comp/endcomp blocks with cal style and stipulate row as the object. I am afraid I do not use tabulate, so I don't know the equivalent of compute blocks.

Re: TABULATE - Can I colour an entire row based on the label format (inherited style?)

Andrew_ — Tue, 13 Nov 2018 11:05:20 GMT

Thank you - I did wonder if PROC REPORT could do this from some of the references I saw online.

Thanks again.

Andrew