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
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
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.
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
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
Thanks Reeza, this paper looks interesting, let me check it and will get back to you, thanks.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.