topic Re: highlighting significant values in ODS and Base Reporting

highlighting significant values

veblen — Wed, 20 Jul 2011 18:40:40 GMT

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!!!

Re: highlighting significant values

andreas_lds — Fri, 22 Jul 2011 14:03:15 GMT

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;