Return to Snippet

Revision: 60317
at November 2, 2012 02:33 by webonomic


Initial Code
proc report data=sashelp.prdsale;
where region = "&REGION." and Country = "&COUNTRY";
column Country Region Division ProdType Product Year Quarter Predict Actual;
define Predict / analysis mean 'Predicted Sales (Avg)';
define Actual / analysis mean 'Actual Sales (Avg)';
/* begin row alternating code */
compute Country;
	count+1;
		if (mod(count,2)) then do;
			"STYLE=[BACKGROUND=#EEE8DC /* FOREGROUND=WHITE */
			FONT_Weight=BOLD]");
		end;
endcomp;
run;

Initial URL
http://www.bi-notes.com/2012/10/stored-process-using-alternating-background-color-with-proc-report/

Initial Description
Adding alternating row of color to make proc report output easier to read.

Initial Title
Using Alternating Background Color with PROC REPORT

Initial Tags
background, color

Initial Language
SAS