topic Re: Proc report+ highlight a row only in SAS Programming

Proc report+ highlight a row only

tommy81 — Mon, 18 Oct 2010 05:37:32 GMT

Hi ,

I have a dataset with a couple of colums

Unfortunately i need to highligh only one row based on the value of the first colum.

Please could somebody suggets a code to do it.

Something like if firstcolum=sales , then highlight the entire row using colors or bold

help would be deeply apprecited

Re: Proc report+ highlight a row only

polingjw — Mon, 18 Oct 2010 10:54:22 GMT

You need to use a call define statement with the _row_ argument within a compute block. For example:

If _c1_ = ‘sales’ then call define (_row_, ‘style’, ‘style={background=yellow}’);

Re: Proc report+ highlight a row only

SASPhile — Mon, 18 Oct 2010 14:45:58 GMT

Try this:
DATA TEST;
LENGTH ID $ 5 NAME $ 10 ADDRESS $ 15;
INPUT ID $ NAME $ ADDRESS $ QTY;
DATALINES;
SALES John Philadephia 25
BUY Adams Tampa 30
SALES Adams Orlando 30
BUY Mark Austin 30
;
RUN;

/* CREATE MACRO VARIABLE WITH ALL DUPLICATE PHYID VALUES */
DATA TEST1;
SET TEST;
IF ID='SALES' THEN FLAG='1';
ELSE FLAG='0';
RUN;

ODS LISTING CLOSE;
ODS HTML FILE='C:\Documents and Settings\Desktop\test.xls';

PROC REPORT DATA=TEST1 NOWINDOWS;
COLUMNS ID NAME ADDRESS QTY FLAG;
DEFINE FLAG/NOPRINT;
COMPUTE flag;
IF FLAG='1' THEN CALL DEFINE(_ROW_, "STYLE", "STYLE=[BACKGROUND=blue]");
ENDCOMP;
RUN;
ODS HTML CLOSE;
ODS LISTING;