BookmarkSubscribeRSS Feed
veblen
Calcite | Level 5

I am looking to highlight significant values in a table of monthly values.

I have been successfull with ODS html to xls with Proc Tabulate and Proc Report and have been able to work with the formating, but I'm at a loss in adding the stats into the report and having them highlighted.  I have looked at a paper or two on Traffic Highlighting but they don't seem be getting through to my brain.

Possiby the solution resides with the method of obtaining the significance tests.

This is a task that I had other posts on, but have sidetracked in completing.    

Any help is appreciated. 

THANKS!!!

1 REPLY 1
andreas_lds
Jade | Level 19

What do you want to be highlighted, exactly? The whole row? A cell?

The example highlights the variable 'age':

proc format;

    value AgeBgFmt

        11 = 'Gold'

        16 = 'light green'

        other 'white'

    ;

run;

proc print data=sashelp.class;

    var Name Sex;

    var Age / style={background=AgeBgFmt.};

    var Height Weight;

run;

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1266 views
  • 0 likes
  • 2 in conversation