BookmarkSubscribeRSS Feed
DMoovendhan
Quartz | Level 8

HI,

 

I am using the below code to create multiple sheets of excel output.

But I am not able to get the image embed into the title.

 

 

ods tagsets.excelxp file = "&excelpath" style =printer
options(sheet_name = 'Cover Page' sheet_interval='proc' embedded_titles='yes');
ods escapechar='~';

Title5 justify=left bold "Study :" notbold "study name" '~S={postimage="/tlly2t/3rdparty/irserver/lilly.png" color=white} y';

/*--- sas statements ---*/

 

Ods options(sheet_name = 'parameters' sheet_interval='proc' embedded_titles='yes');

Title5 justify=left bold "Study :" notbold "study name" '~S={postimage="/tlly2t/3rdparty/irserver/lilly.png" color=white} y';

/*--- sas statements ---*/

 

ods _all_ close;

 

I have attached the screen shot of the sample requirement heading to this query.

Kindly help.

 

Regards,

Moovendhan Devaraj

7 REPLIES 7
Reeza
Super User

ODS TAGSETS does not support embedded images. Your code is not ODS EXCE, but ODS EXCEL does support multiple tabs/embedded images. However, it's not production until SAS 9.4 TS1M3

 

 

DMoovendhan
Quartz | Level 8

Thanks Reeza for looking into this.

 

I am using sas 9.4, and I am able to create multiple tabs with it, should I modify the code to get the image embedded.

Previously with tagset I was getting a link added to the excel but now not getting any of the info in output.

 

Please advise.

Reeza
Super User
Post the code your actually using then. There's a paper from Chevell Parker on lexjansen.com that has examples of how to embed images.
Vince_SAS
Rhodochrosite | Level 12

I don't think that the Excel destination supports PREIMAGE, either:

 

ods _all_ close;

ods escapechar='^';

*  Embed a JPG file;

title "^{style [preimage='path-to-image-file\image-file-name.jpg']}";

ods html  file='path-to-output-file\temp.htm';
ods pdf   file='path-to-output-file\temp.pdf';
ods Excel file='path-to-output-file\temp.xlsx';

proc print data=sashelp.class(obs=1); run; quit;

ods _all_ close;

 

The image is embedded in HTML and PDF, but not Excel.

 

Vince DelGobbo

SAS R&D

Reeza
Super User

 No, preimage isn’t supported but other methods are available. See the example starting on page 3 here

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

DMoovendhan
Quartz | Level 8

Thanks Reeza, this paper looks interesting, let me check it and will get back to you, thanks.

DMoovendhan
Quartz | Level 8

I tried it, 

 

But the code that I am executing is in Unix and I couldn't execute the .vbs file.

 

I am dropping an email to support@sas.com.

Please let know if you have any other thoughts.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 3144 views
  • 0 likes
  • 3 in conversation