ODS EXCEL AND HOW TO INSERT AN IMAGE

[SørenJessen]

Hi

I'm changing from ODS MARKUP to ODS EXCEL because I need to produce a native XLSX file.

I'm now trying to insert an image and a title on the right side of the image in my report, but I can only get the title directly on the image or below the image.

Does anyone have an alternative solution to insert an image (and the title on the right side of the image) when you use ODS EXCEL?

Best regards Søren (using SAS 9.4 M3)

goptions reset=all device=PNG;

ods _all_ close;

ods excel file='c:\temp\ODS EXCEL and images.xlsx'

options(sheet_interval='none'

embedded_titles="yes");

goptions imagestyle=fit

iback='http://www.sas.com/content/sascom/en_us/events/premier-business-leadership-series/premier-business-l...'

xmax=5in ymax=1.5in name='text';

proc gslide;

title 'Title from proc gslide';

run; quit;

title 'Title after proc gslide';

proc print data=sashelp.class;

run;

ods _all_ close;

[Amazigh]

Hi,

According to Chevel Parker, you cannot insert an image directly with ODS EXCEL. You have to post process.

" Currently, the destination enables you to add an image only to the background of the

worksheet. It does not support images on a per cell basis (as is possible using the PREIMAGE= and

POSTIMAGE= attributes in other ODS destinations). "

http://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf

Amazigh.

[rogerjdeangelis]

OT: Off topic because it uses a combination of R and SAS and requires 'full' SAS(SAS command pipe)

see

https://listserv.uga.edu/cgi-bin/wa?A2=SAS-L;d17d6f92.1608a

[RJB_NZ]

 I would like to see the combination of R and SAS solution, but the link doesn't work, and there's not enough information about how to find it on the Georgia University website (if it's still there...)