Help using Base SAS procedures

PROC Report: Alternate shading for a group variable

Accepted Solution Solved
Reply
Contributor
Posts: 62
Accepted Solution

PROC Report: Alternate shading for a group variable

Hello Community,

Is there any way in PROC REPORT to apply alternate shading of ALL rows of a group variable in ODS RTF? Something like the attached table...

I'm using this mock dataset to illustrate....

ods rtf file='C:\******.rtf' startpage=never BODYTITLE style=journal;

data have;

  do month = 'Jan','Feb','Mar','Apr';

  do dept= 'Assistants','IT','Dev';

  do N= 1 to 10;output;

  do salary=ranuni(737346) * 100000;output;

  end;

  end;

  end;

  end;

run;

proc report data=have nowd headline;

  column month dept salary;

  define month/group width=7;

  define dept/group;

  define salary/ max;

run;

ods rtf close;


Accepted Solutions
Solution
‎10-02-2013 03:41 PM
Respected Advisor
Posts: 3,780

Re: PROC Report: Alternate shading for a group variable

This looks pretty close.

ods rtf file='~/altlightgrey.rtf' startpage=never BODYTITLE style=journal;
data have;
   do month = 'Jan','Feb','Mar','Apr';
     
do dept= 'Assistants','IT','Dev';
        
do N= 1 to 10;output;
           
do salary=ranuni(737346) * 100000;
              
output;
              
end;
           
end;
        
end;
     
end;
  
run;


proc report data=have nowd headline;
  
column month dept salary;
   define month/group width=7;
  
define dept/group;
  
define salary/ max;
  
compute before month;
      I + 1;
     
endcomp;
  
compute salary;
      if mod(i,2) eq 1
         then call define(_row_, "style", "STYLE=[background=lightgrey]");
      endcomp;
  
run;

ods rtf close;

View solution in original post


All Replies
Solution
‎10-02-2013 03:41 PM
Respected Advisor
Posts: 3,780

Re: PROC Report: Alternate shading for a group variable

This looks pretty close.

ods rtf file='~/altlightgrey.rtf' startpage=never BODYTITLE style=journal;
data have;
   do month = 'Jan','Feb','Mar','Apr';
     
do dept= 'Assistants','IT','Dev';
        
do N= 1 to 10;output;
           
do salary=ranuni(737346) * 100000;
              
output;
              
end;
           
end;
        
end;
     
end;
  
run;


proc report data=have nowd headline;
  
column month dept salary;
   define month/group width=7;
  
define dept/group;
  
define salary/ max;
  
compute before month;
      I + 1;
     
endcomp;
  
compute salary;
      if mod(i,2) eq 1
         then call define(_row_, "style", "STYLE=[background=lightgrey]");
      endcomp;
  
run;

ods rtf close;
Contributor
Posts: 62

Re: PROC Report: Alternate shading for a group variable

Fantastic! Thanks very much data_null_ !

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 227 views
  • 0 likes
  • 2 in conversation