topic Re: Keep Titles with ODS Excel in SAS Enterprise Guide

Keep Titles with ODS Excel

DavidPhillips2 — Wed, 10 Jul 2019 14:35:14 GMT

When I use ODS PDF my titles show at the top of each proc report but not when I use ODS Excel. How do I keep my titles in ODS Excel?

PaigeMiller — Wed, 10 Jul 2019 15:01:46 GMT

ods excel file="abc.xlsx" options(embedded_titles='YES');

There are many options available for ODS Excel, you might want to peruse the documentation.

DavidPhillips2 — Wed, 10 Jul 2019 17:30:05 GMT

That works. Is there a way to have a banner? In ods pdf I used title1 '~S={preimage="/serverpath/EAAR_Yellow_(IRDS).jpg"}';

PaigeMiller — Wed, 10 Jul 2019 17:53:51 GMT

I don't know what you mean by "banner".

Show me the "banner" in the PDF file.

DavidPhillips2 — Wed, 10 Jul 2019 18:00:26 GMT

In a pdf file if you use the code i posted it creates an image in the title that functions as a banner in place of title1.

PaigeMiller — Wed, 10 Jul 2019 20:06:40 GMT

But you could still show me what it does.

DavidPhillips2 — Wed, 10 Jul 2019 20:09:36 GMT

DavidPhillips2 — Wed, 10 Jul 2019 20:09:58 GMT

Title1 is the image

Title2 is text.

PaigeMiller — Wed, 10 Jul 2019 20:15:57 GMT

I have to say, I don't know the answer, I have never tried to do this with ODS Excel.