topic Re: Controlling style elements of part of a cell's value in ODS and Base Reporting

Controlling style elements of part of a cell's value

lbarwick — Mon, 26 Nov 2018 12:33:46 GMT

I have an HTML report with a column reporting data as XX (XXX) in a single cell, where XX represents one subset of my raw data set and (XXX) represents another subset. I am outputting this way to conserve space since it is a fairly large report. If possible I'd like XX to be one font color and (XXX) to be another to distinguish the two values a little better. Is it possible to do this via a compute/call define statement? I couldn't find anything in the documentation and my hunch says no, in which case I will separate the values into their own columns and control the font color that way.

Re: Controlling style elements of part of a cell's value

RW9 — Mon, 26 Nov 2018 12:40:50 GMT

Use odsescapahcar, and embed style elements in your data as:

data want;
  a="^s={color=red}34 (^s={color=blue}64)";
run;
ods escapechar="^";
proc report...;

You can set any attributes inline then - search keyword is inline formatting.

Re: Controlling style elements of part of a cell's value

lbarwick — Mon, 26 Nov 2018 14:47:36 GMT

Ah, didn't consider inline formatting. Worked perfectly, thanks!