ODS report

Reply
Contributor
Posts: 71

ODS report

Hi,

I am using ods to ouput a proc print report to excel file. Wondering if there is a way to highlight specific row in certain color?

Below is my code..

ODS HTML BODY='C:\result.xls' style = MINIMAL RS=NONE

HEADTEXT="<STYLE> TD {MSO-NUMBER-FORMAT :\@} </STYLE>";

Proc print data = bal_100 noobs;

run;

ODS HTML CLOSE;

Super User
Posts: 17,831

Re: ODS report

Yes, but I think you generally need proc report or tabulate instead.

Here's a paper with a fairly simple example:

http://www2.sas.com/proceedings/forum2008/224-2008.pdf

If you have something more complex I recommend replying with more details. If you search on the forums there are a lot of examples.

SAS Super FREQ
Posts: 8,743

Re: ODS report

Hi, yes, you are correct. It is easier to traffic light an entire row using PROC REPORT. It can be done with TABULATE, but not in as straightforward a manner. That will be one of the examples in my SAS Global Forum paper this year (coming soon!)

cynthia

Contributor
Posts: 71

Re: ODS report

OK. I will give a try. Thanks!!

Ask a Question
Discussion stats
  • 3 replies
  • 218 views
  • 6 likes
  • 3 in conversation