Highlighting selected output in SurveyFreq

[Batman]

Can I shade or color select rows or columns in Proc SurveyFreq output.

For example, could I add a certain color to all the rows with the table value of x=2 in this sample code?

data a;

do i=1 to 10;

weight=1000+ranuni(1234)*1000;

x=1+round(ranuni(2345)*1,1);

y=1+round(ranuni(3456)*2,1);

output;

end;

run;

proc surveyfreq data=a;

tables x*y;

weight weight;

run;

[collinelliot · Accepted solution]

By the time I post this, some other clown on here will probably give you a working example, but just in case they don't, here's my advice.

I think you'd have to output the table data into a data set and then use proc report.

Here's how you'd output the table data:

ods output CrossTabs = tblData;

proc surveyfreq data=a;
tables x*y;
weight weight;
run;

ods output close;

Here's a good paper on traffic lighting: http://support.sas.com/resources/papers/proceedings11/290-2011.pdf