BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
hk2013
Fluorite | Level 6

how do i hide footnote from showing up in excel attachment.  

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

So you want a footer but not displayed?

If you don't want it, use the following to clear the footnote entirely.

 

footnote;

Otherwise, you can try the following in your ODS TAGSETS.EXCELXP option which will place it in the footer, so not visible when you open the file, but will be included on prints. This should be the default. 

 

embedded_footnotes='No'

Or you can use Hidden_Columns by specifying the range to hide, or set row_heights to a really low value so it appears hidden. Both of those last options require you to know where the footer will end up in the final report. 

 

I can't think of another approach at the moment.

 

View solution in original post

3 REPLIES 3
Reeza
Super User

Are you trying to hide the cell, or have it embedded in the footer?

hk2013
Fluorite | Level 6

Im trying to hide it so it  doesn't show in the excel file 

Reeza
Super User

So you want a footer but not displayed?

If you don't want it, use the following to clear the footnote entirely.

 

footnote;

Otherwise, you can try the following in your ODS TAGSETS.EXCELXP option which will place it in the footer, so not visible when you open the file, but will be included on prints. This should be the default. 

 

embedded_footnotes='No'

Or you can use Hidden_Columns by specifying the range to hide, or set row_heights to a really low value so it appears hidden. Both of those last options require you to know where the footer will end up in the final report. 

 

I can't think of another approach at the moment.

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 3 replies
  • 684 views
  • 0 likes
  • 2 in conversation