Solved
Contributor
Posts: 25

# Highlighting selected output in SurveyFreq

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;

Accepted Solutions
Solution
‎03-08-2017 03:46 PM
PROC Star
Posts: 311

## Re: Highlighting selected output in SurveyFreq

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

All Replies
Solution
‎03-08-2017 03:46 PM
PROC Star
Posts: 311

## Re: Highlighting selected output in SurveyFreq

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
• 1 reply
• 190 views
• 2 likes
• 2 in conversation