topic Re: ODS Excel - Insert png within a cell that's not a unicode in ODS and Base Reporting

ODS Excel - Insert png within a cell that's not a unicode

cbird — Mon, 24 Jun 2019 18:38:15 GMT

Need assistance with the following:

1. ODS Excel - in the output would like to utilize an image. I,E. IF Status = New then symbol = (put picture here).

I'm using sas Enterprise Guide 7.1.

Would like to perform a similar function as IF/ THEN using an picture as the THEN value.

Thank you for your help.

Re: ODS Excel - Insert png within a cell that's not a unicode

Reeza — Mon, 24 Jun 2019 18:39:23 GMT

Do you have some skeleton code we can play with?

Re: ODS Excel - Insert png within a cell that's not a unicode

cbird — Mon, 24 Jun 2019 18:49:21 GMT

I have been trying to get this to work but it's calling in a Unicode value. I would like for it to utilize a .png image. For example when Action Plan Implementation then the image would be (from the attached PNG)

Ods escapechar="^";

ods excel file="\\eagle.usaa.com\usaa\ceo\SecurityData\ISSUES_CONTROLS\ISSUES_REPORT.xls"

style=styles.sansprinter;

options(Sheet_Interval = 'none'

Sheet_Name = 'Issues Report'

embedded_titles = 'yes'

formulas = 'YES'

Autofilter='yes');

proc report WORK.Issues1;

/* (where=(country="GERMANY")) spanrows; */

column issue title status owner,( actual predict) indicator1 indicator2;

define year / across;

define actual / style(column)={tagattr="format:accounting" width=.8in};

define predict / style(column)={tagattr="format:accounting" width=.8in};

define country / group style(column)={tagattr="rotate:90" just=center vjust=middle color=blue};

define product / group;

define indicator1 / style(column)={tagattr=' formula:=IF(RC[-4] > RC[-3],"á","â")' fontfamily=wingdings just=center};

define indicator2 / style={just=center};

compute indicator2 / length=100 character;

if _c5_ > _c6_ then indicator2="^{style[color=blue]^{unicode 1F603}}";

else indicator2="^{style[color=green] ^{unicode 1F620}}";

endcomp;

rbreak after / summarize style(summary)={fontweight=bold borderstyle=solid bordertopwidth=5pt bordertopcolor=black};

run;

ods excel close;

Endrsubmit;

Signoff;

Re: ODS Excel - Insert png within a cell that's not a unicode

cbird — Mon, 24 Jun 2019 18:50:55 GMT

this code though it's calling a Unicode value. Would like for it to use a .png. For example if STATUS = Action Plan Implementation then the .png would be applied.