topic Re: ODS EXCEL AND HOW TO INSERT AN IMAGE in ODS and Base Reporting

ODS EXCEL AND HOW TO INSERT AN IMAGE

SørenJessen — Thu, 04 Aug 2016 11:55:52 GMT

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-leadership-series-2015/_jcr_content/par/styledcontainer_6/par/image_0.img.png/1432909272473.png'

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;

Re: ODS EXCEL AND HOW TO INSERT AN IMAGE

Amazigh — Thu, 04 Aug 2016 13:28:52 GMT

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.

Re: ODS EXCEL AND HOW TO INSERT AN IMAGE

rogerjdeangelis — Thu, 04 Aug 2016 21:58:34 GMT

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

Re: ODS EXCEL AND HOW TO INSERT AN IMAGE

RJB_NZ — Wed, 21 Jul 2021 00:00:59 GMT

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...)