The SAS Output Delivery System and reporting techniques

ODS EXCEL AND HOW TO INSERT AN IMAGE

Reply
Regular Learner
Posts: 1

ODS EXCEL AND HOW TO INSERT AN IMAGE

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;

Occasional Contributor
Posts: 8

Re: ODS EXCEL AND HOW TO INSERT AN IMAGE

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). "
 
 
 
Amazigh.
Valued Guide
Posts: 505

Re: ODS EXCEL AND HOW TO INSERT AN IMAGE

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

Ask a Question
Discussion stats
  • 2 replies
  • 724 views
  • 1 like
  • 3 in conversation