BookmarkSubscribeRSS Feed
BAdams
Calcite | Level 5

Hello,

I have created a bar chart in an excel file report using the  MSOffice2k_x tagset.  The problem is that two files are created, one is the excel file which has a link to the second file which is a png file. The excel file links to the png and shows the image when you open it, but it isn't actually embedded in the excel file.  I'd like to be able to send the output into excel instead of a png (or any other type file). Is it not possible to do this?

What I eventually hope to end up with is going to be several report files with multiple tabs and graphs, so copy pasting each image in each file or emailing dozens of pngs to end users is not really an option. (And of course they want excel and not a PDF.)  I tried just using 'file=' on in my code instead of 'file=' and 'path=', and that did create one file, but the graph was super tiny (1 cm by 1 cm) and I couldn't made it any larger.

Thanks for any tips anyone has on this.

1 REPLY 1
Cynthia_sas
SAS Super FREQ

Hi:

  For help with MSOFFICE2K_X destination output, you may want to work with Tech Support. It was my understanding that all HTML-based output (ODS HTML, ODS MSOFFICE2K, ODS MSOFFICE2K_X) were using graphics by rendering  the IMG tag that ODS puts in the HTML result file. This means that the PNG (or whatever format) image is external to the HTML file and is NOT embedded in Excel when Excel renders the file. The only destinations that truly embed images are PDF and RTF destinations.

  I cannot figure out what you mean by FILE= versus FILE= and PATH=. If you examine the HTML, using Notepad, you can find out how PATH= changes the file location used in the IMG tag.  Again, Tech Support can look at all your code and your data and help you figure out what is happening.

cynthia

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 1 reply
  • 908 views
  • 0 likes
  • 2 in conversation