Help using Base SAS procedures

Highlighting selected output in SurveyFreq

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

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: 307

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

 

 

View solution in original post


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

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
  • 148 views
  • 2 likes
  • 2 in conversation