Date:         Tue, 13 Oct 2009 22:49:09 -0700
Reply-To:     Anaconda <rune@FASTLANE.NO>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Anaconda <rune@FASTLANE.NO>
Organization: http://groups.google.com
Subject:      How to sofisticate ODS reports by using colors for rows and
              columns
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

/*
Below is an example code of wrting a simple
report using ODS.

How can I make the program so that I can mark the
records (both columns) with colour (yellow, for instance)
in those two cases where Col_02 = "wrong"?

And how can I make SAS colour the column Col_02
if I wanted?

Could this be a suitable task to be handled by a macro?
Does anyone know about the existence of a such one?

- Anaconda
*/


data test;
   attrib
      Col_01       length = $15
      Col_02      length = $5
   ;
   infile datalines truncover;
   input
      @01  Col_01       $15.
      @20  Col_02       $5.
   ;
   datalines;
record # 1         right
record # 2         wrong
record # 3         right
record # 4         right
record # 5         right
record # 6         wrong
record # 7         right
;
run;

%macro print;
   ods listing close;
   ods escapechar = '^';
   ods rtf file = "d:\temp\test.doc";
   proc print data = test noobs;
   run;
   ods rtf close;
%mend;
%print;