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
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