topic Re: coloured data in proc tabulate in SAS Programming

coloured data in proc tabulate

valentina71 — Thu, 13 Apr 2017 12:28:00 GMT

Hi everybody, i'm facing with a little sas-detail, but probably can solve me a lot of problems...
I'd like to focus my datas, outcoming from my proc tabulate, in some particular conditions (example: differences >10% and so on), but I would like to focus (for example in red) not from the background but from the data.

example: 8% in white, 18% in red (the number and the % character)...

Thank you if'll you kindly help / light me.

valentina from Italy.

Re: coloured data in proc tabulate

RW9 — Thu, 13 Apr 2017 12:39:04 GMT

Output the proc tabulate output to a dataset, then apply standar traffic lighting in a proc report:

https://communities.sas.com/t5/SAS-Procedures/Traffic-Lighting-with-Proc-Tabulate/td-p/83374

Re: coloured data in proc tabulate

valentina71 — Thu, 13 Apr 2017 12:46:14 GMT

I'm sorry but I read the post you tell me before to write mine...

it's not helpful, the traffic light is in the background non in the data.

thank you, valentina

Re: coloured data in proc tabulate

Criptic — Thu, 13 Apr 2017 12:50:58 GMT

You can try the following code snippet on your example - for more information look at this SAS note http://support.sas.com/kb/23/353.html

   proc report data=sashelp.class nowd;
     column name age sex height weight;
     define name / display;
     define age / order;
     define sex / order;
     define height / sum;
     define weight / sum;
     compute age;
       count+1;
       if count=5 then
          call define(_row_,"style","style={background=red}");
     endcomp;
   run;

Re: coloured data in proc tabulate

RW9 — Thu, 13 Apr 2017 12:53:37 GMT

Then just change the style call from background to foreground.

So from this:

style={background=pink}

To:

style={foreground=pink}

Re: coloured data in proc tabulate

valentina71 — Thu, 13 Apr 2017 13:11:44 GMT

thank u!!! it was simple!!!!

in italy we say: I lost myself in a glass of water ( as: It was all a storm in a teacup).

valentina

Re: coloured data in proc tabulate

valentina71 — Thu, 13 Apr 2017 13:12:26 GMT

this is not a proc tabulate.

Re: coloured data in proc tabulate

ballardw — Thu, 13 Apr 2017 14:21:33 GMT

And an example using the value of a statistic to change text color.

proc format library=work;
value colorpct
0 - 55 = 'blue'
55<-75 = 'green'
75<-high= 'red';
run;

proc tabulate data=sashelp.class;
   class age;
   class sex;
   table age,
         sex*rowpctn*[style={foreground=colorpct.}];
run;

coloured data in proc tabulate

valentina71 — Fri, 14 Apr 2017 06:28:23 GMT

thank youuuuuuu!!!