Prev: Proc Tabulate
Next: Graph help
From: Ya Huang on 5 Mar 2010 18:23
Hi there,

For numeric var, we can define range in format to control the
cell background/foreground. What about character var?

data xx;
s='123523'; output;
s=' 234'; output;
s='Abc dd'; output;
run;

ods pdf file="c:\temp\junk.pdf" style=printer;

proc format;
value $msbg
low-high='white'
other='black'
;

options missing='';
proc print data=xx;
var s / style=[background=$msbg.];
run;

ods pdf close;

My goal is to make s black background, if s value includes any letter
other than numbers (0-9). For the above data, obs=3 has value 'Abc dd',
which is not all numnbers, therefore, this cell need to be black.

Maybe picture format?

Thanks

Ya
 | 
Pages: 1
Prev: Proc Tabulate
Next: Graph help