topic Re: Add footnote to ods RTF in Sgpanel pages in ODS and Base Reporting

Add footnote to ods RTF in Sgpanel pages

amager — Tue, 17 Apr 2018 13:56:24 GMT

I have a problem with footnotes under the sgpanel pages of my RTF. Even if the footnotes appear in t he other pages :

i test many solutions , like footnote inside the proc report ..and footnotes before the proc sgpanel..

compute after _page_;
    line "footnote generated by compute after and line";
endcomp;

also the :

ODS tagsets.sasreport13(ID=EGSR) gtitle;

if someone know how to do it ?
Thanks in Advance .

Re: Add footnote to ods RTF in Sgpanel pages

Cynthia_sas — Tue, 17 Apr 2018 14:26:43 GMT

Hi:
Seeing ODS TAGSETS.SASREPORT13 makes me wonder if you are using Enterprise Guide. If you want to control the option like nogtitle and nogfootnote for RTF, you might consider taking full control of your output and putting an ODS "sandwich" around your code. Without getting into an example of a graph with PROC REPORT, the example below shows how you'd construct an ODS RTF statement to include the NOGTITLE and NOGFOOTNOTE options and also shows the impact of TITLE and FOOTNOTE statements along with the LINE statement in PROC REPORT.

As you can see, the COMPUTE BEFORE _PAGE_ text stays within the boundaries of the table and so does the COMPUTE AFTER _PAGE_. As a comparison, the SAS Footnote goes at the bottom of the physical page in RTF and PDF destinations.

Cynthia

Re: Add footnote to ods RTF in Sgpanel pages

amager — Tue, 17 Apr 2018 14:58:44 GMT

HI Cynthia,

Indeed, i need the option 'nogfootnote' to include footnote in my ODS.

Thanks for your reply , i was sure that your reply it will be helpful like everytime!

Many thanks

Re: Add footnote to ods RTF in Sgpanel pages

amager — Tue, 17 Apr 2018 15:19:12 GMT

I still have another problem that's if footnotes of sgpanel graphic its inserted. the footnote of the page does not appear??

How to fix that ??

Re: Add footnote to ods RTF in Sgpanel pages

Cynthia_sas — Tue, 17 Apr 2018 18:17:05 GMT

Hi:

Without your code or your data, it's hard to visualize what you're describing. This worked for me:

(I added the yellow highlight to the screen shot to illustrate the SAS title and SAS footnote on the page.)

Cynthia

Re: Add footnote to ods RTF in Sgpanel pages

amager — Thu, 19 Apr 2018 09:57:33 GMT

I can't it's a long and private code. i set the footenotes in each ouput of sgpanel graphic and report footnote in the others pages. Thanks to your reply.

Re: Add footnote to ods RTF in Sgpanel pages

Cynthia_sas — Thu, 19 Apr 2018 17:02:44 GMT

Hi:

I'm not sure what any remaining issues are except you may want to have a title and footnote INSIDE the graph image and then ALSO on the RTF page...that's not possible without doing some annotation. However, if you mean that you want to have a report and a graph in the same document and you want to turn the options for nogtitle, nogfootnote on and off between steps, here's how to do that:

1) Graph first, then report:

2) Report first, then graph:

Note how between the steps, an ODS RTF statement is issued, without a FILE=, but with the option that I want to change.

Hope this helps,

cynthia