The SAS Output Delivery System and reporting techniques

Embedded Footnotes

Reply
Occasional Contributor J_C
Occasional Contributor
Posts: 18

Embedded Footnotes

Hi,

I am currently using ods excelxp to create an excel workbook, but I only want footnotes on the sheets where I actually define footnotes. below is an example of two sheets.

ODS TAGSETS.EXCELXP

OPTIONS ( Orientation = 'portrait'

FitToPage = 'yes'

sheet_interval = 'none'

sheet_name = 'Sheet X'

Embedded_Titles = 'yes' Embedded_Footnotes = 'yes'

autofit_height = 'yes'

Absolute_Column_Width = '12,15,9,9,9,9'

);

ODS TAGSETS.EXCELXP

OPTIONS ( Orientation = 'portrait'

FitToPage = 'yes'

sheet_interval = 'none'

sheet_name = 'Sheet Y'

Embedded_Titles = 'yes'

Embedded_Footnotes = 'off'

autofit_height = 'yes'

Absolute_Column_Width = '10,10,30,5,9,9,9,9,9,9'

);

In Sheet X, I define footnotes 1-7. In Sheet Y, i don't define any footnotes yet they still appear when I try to print may workbook in Excel. I turned off the embedded_footnotes option but it doesn't seem to work.

It doesn't bother me that much, but when I open Excel, it gives me an error "Problems During Load" and when I follow the directory to see the warning, it tells me:

XML Spreadsheet Warning in Worksheet Setting

REASON: String too long

ACTION: Truncating string

FILE: XXX

GROUP: PageSetup

TAG: Footer

ATTRIB: Data

VALUE: YYYYYYYYYYYYY.

Therefore, I think the warning is caused by footnotes and that is why I am trying to remove footnotes when unnecessary.

This code has been working fine for months, only now do I get the "Problem During Load" warning.

Thanks

Super User
Posts: 19,131

Re: Embedded Footnotes

In SAS titles and footnotes persist until you reassign or clear them explicitly.

You can clear them via:

title;

footnote;

Regarding the embedded_footnotes - check if you have the latest version of the tagsets.

Occasional Contributor J_C
Occasional Contributor
Posts: 18

Re: Embedded Footnotes

Thank you, I will clear them explicitly.


Ask a Question
Discussion stats
  • 2 replies
  • 490 views
  • 0 likes
  • 2 in conversation