Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

This FAQ provides two methods of coloring every other row of a table.

PROC REPORT

For procedures that don't have templates, you can use PROC REPORT and the CALL DEFINE statement, and use _ROW_ as the variable to format. A counter is created with a temporary variable so that you have a number on each observation. Finally, use the MOD function to create the condition.

   data one;
     input age sex $ height weight;
   cards;
   11 M 66 142
   11 F 62 138
   11 M 55 169
   12 M 67 172
   12 F 66 188
   12 M 68 199
   13 M 62 132
   13 M 64 122
   14 F 62 133
   15 M 55 120
   ;
   run;

   ods html body='temp.html';

   proc report data=one nowd;
     column age sex height weight;
     define age / order;
     define sex / order;
     define height / sum;
     define weight / sum;
     compute age;
       count+1;
       if mod(count,2) then do;
         call define(_row_, "style", "style=[background=red]");
       end;
     endcomp;
   run;

   ods html close;

The DATA Step

For procedures that have templates, you can use the DATA step to highlight every other row. The below example uses the CELLSTYLE statement with the MOD function. The variable I controls the background color of the odd rows, and the TEST statement binds the data with the template.

  data temp;
   set sashelp.class ;
   i=_n_;
   run;

  proc template;
  define table x;
     column i name age sex height weight;
     define i; print=off; end;
     cellstyle mod(i,2) as {background=pink };
     use_name;
  end;

  ods html file="foo.htm";
  test data=temp;
  ods html close;
  run;

See also the full PROC TEMPLATE FAQ and Concepts.

Operating System and Release Information