topic Re: Adding logo and picture using ods excel in SAS Programming

Adding logo and picture using ods excel

LRN — Wed, 24 Jun 2015 15:32:12 GMT

Hi Everyone,

Good Mornig.

Could some one help me with adding logos and pictures within excel report using ods excel.

Thanks

Re: Adding logo and picture using ods excel

Reeza — Wed, 24 Jun 2015 16:17:08 GMT

Have you tried the preimage option in proc report?

For example this would work in HTML:

ods html file="C:\_localdata\test.html" style=meadow;

proc report data=sashelp.class nowd style(report)=[preimage="http://www.aceds.org/wp-content/uploads/2014/07/six_sigma.jpg"];

title "";

column name age sex weight height;

run;

ods html close;

Re: Adding logo and picture using ods excel

LRN — Wed, 24 Jun 2015 17:29:18 GMT

Hi Reeza, It works with html. But I am working with multisheet excel sheet which has the company logo and a picture. Since, it is not possible with ods excel tagset, trying to see if ods excel would be a better option.

Re: Adding logo and picture using ods excel

Reeza — Wed, 24 Jun 2015 17:43:38 GMT

So if you replace ODS HTML with ODS Excel what happens?

Re: Adding logo and picture using ods excel

LRN — Wed, 24 Jun 2015 19:29:51 GMT

The pic is not getting printed in the excwel sheet

Re: Adding logo and picture using ods excel

Reeza — Wed, 24 Jun 2015 20:27:08 GMT

Check the header? Also, post this in the ODS reporting forum rather than general - you'll get more responses that way.