topic Re: How do I apply multiple Font Color in Same Cell through PROC report in SAS Programming

How do I apply multiple Font Color in Same Cell through PROC report

sb51469 — Mon, 03 Sep 2018 09:11:35 GMT

Hello,

I have been trying to create a Excel using PROC report. I am not attaching my actual code due to Non-disclosure. But let me try to explain using a demo.

Data new;

Text = "Income Multiples";

run;

Proc report data=new nowd noheader;

column text;

define text /display;

run;

I am using ODS tagsets Excelxp for this. My desired output in the excel should be something like this, "Income Multiple", which should appear in one Cell only. I am working on Version 9.2. I have no clue how to do this. I know I can apply style(column)={foreground=<color>}. But I have to present the same in 2 different colors. Need help on this.

Re: How do I apply multiple Font Color in Same Cell through PROC report

RW9 — Mon, 03 Sep 2018 09:28:52 GMT

There is something called "inline formatting" where with the use of an escapechar you add in formatting:

http://support.sas.com/resources/papers/proceedings09/222-2009.pdf

So maybe:

ods escapechar="^";

data new;
  text="^{style [foreground=red]}Income ^{style [foreground=blue]}Multiples";
run;

proc report...

Not tested.

Re: How do I apply multiple Font Color in Same Cell through PROC report

sb51469 — Tue, 04 Sep 2018 03:13:46 GMT

Hello RW9,

Tested this one yesterday, but it seems not enough, something else is probably also needed.

Anyways I am exploring the inline formatting thing you just specified I am looking into it.

I will post the solution if I get one.

thanks for giving me some direction.

Re: How do I apply multiple Font Color in Same Cell through PROC report

sb51469 — Tue, 04 Sep 2018 05:52:45 GMT

Hello @RW9, I found a solution. Albeit the concept is same, just the syntax is different. It should be something like this.

text="^S={foreground=red}Income^S={} ^S={foreground=blue}Multiples^S={}";

I found the solution in this paper by Mr. Derek Morgan, Washington University Medical School, St. Louis, MO. Here is the link.

http://www2.sas.com/proceedings/sugi31/051-31.pdf