This sample includes a downloadable custom add-in task that can be used in SAS Enterprise Guide 4.2. You can use the task to create reports with conditional highlighting, also known as trafficlighting. Click the Output tab to see an example report.

Additional Documentation

For more information about using SAS Enterprise Guide, see the SAS Enterprise Guide documentation page.

Problems or questions

To report any questions or problems regarding this sample, contact SAS Technical Support.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

The following shows sample code that was generated by the Conditional Highlighting custom add-in task.

This code will run "as is" on a machine with SAS 9.2 that includes the SASHELP library.

options nobyline;

title1 f= 'Times New Roman/B' h= 16 PT c= cx0000ff 'Highlight based on Age';
title2 f= 'Times New Roman/B' h= 16 PT c= cx0000ff '#byvar(Sex) = #byval(Sex)';

proc sort data=SASHELP.CLASS out=sorted;
by descending Sex descending Height ;
run;

proc report nowd data=sorted;
  column Name Sex Age Height Weight ;
  define Age / display;
  compute Age;
    if Age < 13 then call define (_col_,'style','style=[background=cxD06959 foreground=cx0000ff]');
    if Age = 13 then call define (_col_,'style','style=[background=cxF1DC63 foreground=cx0000ff]');
    if Age > 13 then call define (_col_,'style','style=[background=cx84AF5B foreground=cx0000ff]');
  endcomp;
by descending Sex ;
run;

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Here is a sample report generated by the Conditional Highlighting custom add-in task.

To install and use the custom add-in task in SAS Enterprise Guide 4.2, follow these steps:

1. Click the link and save the zip file to your SAS Enterprise Guide machine:
ConditionalHighlighting
2. Unzip the file to extract the ConditionalHighlighting.dll file.
3. Open SAS Enterprise Guide 4.2.
4. Select Tools ► Add-In ► Add-In Manager ► Browse.
5. Select and open the ConditionalHighlighting.dll file, and then click OK to close the Add-In Manager tool.
6. Open the Conditional Highlighting task by selecting Tools ► Add-In ► SAS Custom Examples ► Conditional Highlighting
7. You will be prompted to open some data if there is none in the Process Flow.
8. Assign one or more columns to Columns to list.
9. Assign a column to Column 1 to highlight.
10. Build a simple condition. For example, the condition might be If column_name = some_value.
11. Click Run to generate the report.

This display shows the Conditional Highlighting task interface.

Operating System and Release Information