BookmarkSubscribeRSS Feed
mdavidson
Quartz | Level 8
Is it possible to insert a logo into an excel file that is created via SAS?

I know you can insert a logo with proc report and ODS PDF with preimage=*, but I have not had any success with logos and excel files.

If it is not possible to insert a logo into an excel file, what is the generally accecpted workaround?
1 REPLY 1
Cynthia_sas
Diamond | Level 26
Hi:
If you are using ODS TAGSETS.EXCELXP it is not possible to insert a logo into a SAS-created file. For TAGSETS.EXCELXP it is because, by Microsoft design, Spreadsheet Markup Language does not support the inclusion of graphic images. For the TAGSETS.EXCELXP created file, you probably can insert an image after you open the file, but only if you save it as some file type other than XML.

With ODS methods, like ODS CSV, or ODS HTML or ODS TAGSETS.EXCELXP, you are just creating text files that Excel knows how to open and render.Your other alternative (to CSV or ExcelXP) is to use ODS HTML or ODS MSOFFICE2K and create an HTML file that Excel knows how to render. Excel may be more accepting of graphic images that are defined HTML <IMG> tags.

It really depends on how you are creating your file. The only part of SAS that creates a "true binary" .XLS file is PROC EXPORT (I'm not counting DDE methods here). Again, with a PROC EXPORT-created file, SAS would not even have the syntax to put an image into the Excel file because PROC EXPORT is all about getting the SAS data into Excel format.

cynthia

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1832 views
  • 0 likes
  • 2 in conversation