Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

conditional styling of noncomputed data in proc report

Status
Not open for further replies.

yuthika

Technical User
Nov 25, 2008
5
Hi all,

All my column names are dynamic and are obtained by using across option on one of the column in the dataset.
i need to style up the table box/row to differentiate it.

My code looks like below;
data drgfrqdat (keep = &bugbyvar algmic alg refmic ref catagree ea evaluable);
set drgfrqdat;
run;

proc report data = drgfrqdat nowd split ='\' ;
column alg ref,(N) algmic refmic c; define alg /group 'Algorithm MIC' order=data ;
define ref /across 'Reference MIC' order=data
style=[cellwidth=0.70 in just= center] ;
define algmic / noprint;
define refmic / noprint;
define c / noprint;
compute c;
if algmic = refmic then
call define('N','style','style=[background=gray foreground=black]');
if index(algmic,'=') < 0 and index(refmic,'=') < 0 then
call define(_row_,'style','style= [background=yellow foreground=black font_weight=bold]');
endcomp;
run;

Here C is my dummy value. i endup with error saying algmic and refmic are not initialized. i do get the table as output but with no styling to the values/box i specified.
algmic = refmic i meant the column name and row name to be same. please help;

thankyou
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top