Hi I would like to highlight rows in a table output using proc tabulate but only get this error messages "ERROR: Format references are not allowed:" This is how I programmed my test: 1. at first create format for specific colors proc format lib=work; value temp 1=red 2=purple 3=orange 4=pink 6=yellow other=blue; run; 2. then apply this format in ODS/proc tabulate statement : ods excel file=....; proc tabulate data=_input_data order=data S=[foreground=black]; class x / style={background=temp.}; class y/ style=<parent>; var _some_variable; table x*y,_some_variable; run; ods excel close; x-variable contains values such as 1,2,3,4 y-variable contains classification values such as '01','02',.....'05.4.3' 3. Now I'm expecting to get x and y highlighted based on the values in x No success, only above mentioned error-message.
... View more