The SAS Output Delivery System and reporting techniques

Passing Properties Parameters to Excel with ODS

Reply
Contributor
Posts: 20

Passing Properties Parameters to Excel with ODS

Can anyone tell me if it is possible with ODS to pass paramters for the properties tab in Excel, for example Subject, Author, Manager, etc.
SAS Super FREQ
Posts: 8,743

Re: Passing Properties Parameters to Excel with ODS

Hi:
Although the SUBJECT and AUTHOR and TITLE options exist for RTF and PDF, ODS HTML and ODS CSV and ODS TAGSETS.EXCELXP do not have options or suboptions that populate these Excel properties.

If there is HTML or XML, according to the Microsoft specification that would populate these properties, then you'd have to figure that out in the Microsoft documentation. But, by default, it looks like ODS does not have a direct way to impact these properties.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 121 views
  • 0 likes
  • 2 in conversation