BookmarkSubscribeRSS Feed
bobeng
Obsidian | Level 7

I am trying to create more than 10 footnotes in an ods excel using proc report. I used the code below which worked the first time, but now the footnotes will no longer print in excel, but but do appear in the sas output.

 

ods escapechar='~';
FOOTNOTE ' aaaaaaa ~n bbbbbbb ~n cccccccc ~n dddddddddd';
1 REPLY 1
Reeza
Super User
You can use ODS TEXT, or PROC ODSTEXT instead of FOOTNOTE. From the documentation SAS supports footnote1-footnote10.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatproc/n1ukd9sqgqiwwhn1mrx4c1rbse1j.htm

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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 1 reply
  • 770 views
  • 0 likes
  • 2 in conversation