topic Re: proc report-conditional color of entire rows based on value in 2 columns in SAS Programming

proc report-conditional color of entire rows based on value in 2 columns

Ronein — Wed, 26 Sep 2018 06:32:48 GMT

Hello

I am using proc report.

I want to color entire rows based on values in 2 columns.

I understand that "compute age Sex" is wrong but what is the way to solve it?

     proc report data=sashelp.class nowd;
     column name age sex height weight;
     define name / display;
     define age / display;
     define sex / order;
     define height / sum;
     define weight / sum;

compute age Sex;
     if age  <= 12 AND Sex='M' then
        call define(_row_,"style","style={background=blue}");

     else if 12< AND Sex='F' then
          call define(_row_,"style","style={background=red}");

   endcomp;

   run;

Re: proc report-conditional color of entire rows based on value in 2 columns

andreas_lds — Wed, 26 Sep 2018 07:23:24 GMT

You have to change "order" to "display" and use variable "Sex" to get the desired output:

proc report data=sashelp.class;
   column name age sex height weight;
   define name / display;
   define age / display;
   define sex / display;
   define height / sum;
   define weight / sum;

   compute Sex;
      if Age <= 12 AND Sex = 'M' then do;
         call define(_row_,"style","style={background=blue}");
      end;
      else do;
         if 12 < Age AND Sex='F' then do;
            call define(_row_,"style","style={background=red}");
         end;
      end;
   endcomp;
run;