topic Re: footnote question in SAS Programming

footnote question

Niugg2010 — Sat, 08 May 2021 14:19:50 GMT

Hello,

I have a footnote question.

In my real listing report I have over 10 footnotes, so I tried to concatenate some footnotes together then output. But some concatenated footnote text length is too long, so they are truncated, like the below example.

In this example ls=135 and can not be changed, and footnote text length is over 135, so the footnote text "BBBBBBB" was truncated in output. I know, if output is rtf or pdf, we have no this issue. But for listing, I have not figured out a method to deal with it. Can someone help me out? Thanks

%let ft=%sysfunc(repeat(A, 135))BBBBBBBBBB;
%put &ft.;
proc printto print="xxxxxx\ft.lst" new; run;

proc report data=sashelp.cars (obs=10) ps=48 ls=135 split='|';
column make Model;
run;
footnote1 "&ft.";
proc printto print=print; run;

Re: footnote question

sbxkoenk — Sat, 08 May 2021 17:17:16 GMT

Hello,

Why are you displaying output as listing? Why not the standard HTML?

ods html;
footnote height=5pt 'little footnote';
proc print data=sashelp.class;
run;
/* end of program */

I do not think height= will work in 'ODS LISTING;'. You don't get an error but it will have no effect.

I come back to you on ODS LISTING after the weekend.

Might be that for ODS LISTING everything will become little (also the body of the report).

Will see.

Koen

Re: footnote question

Tom — Sat, 08 May 2021 18:05:09 GMT

Change the LS (aka LINESIZE) setting if you want longer lines.

Re: footnote question

Niugg2010 — Sat, 08 May 2021 19:37:23 GMT

Thank you for your suggestion. For some reason, we will transfer listing output as PDF in the next step. So we can not output HTML and we have to set LS around 135 in order to fit PDF output.

Re: footnote question

Tom — Sat, 08 May 2021 21:07:14 GMT

Are the footnotes static? just use a text editor to fit the content into 10*135 character limit.

Are all of your reports using PROC REPORT? If so why not move the footnotes into the body of the report instead. Then you would not have a limit of 10 footnotes.

Are the footnotes short? I have a macro from Tom Hoffman from 1997 that collapses multiple short strings into footnotes or titles.

223  options mprint;
224  %align
225  (A: this is the first footnote
226  \B: this is the second footnote
227  \C: this is the third footnote which is longest
228  \D: this is the fourth footnote
229  ,tn=1
230  ,ft=f
231  )
MPRINT(ALIGN):   footnote1 "A: this is the first footnote                   B: this is the second footnote                  C: this is the thirdfootnote which is longest ";
MPRINT(ALIGN):   footnote2 "D: this is the fourth footnote                     ";

Re: footnote question

ghosh — Sun, 09 May 2021 17:58:20 GMT

The pdf output works fine, even after playing with various margins, page orientation, and footnote lengths. The font specification is optional, I was testing with large font sizes.


%let fnt=%str('Helvetica', 8pt);
ods _all_ close; 
ods escapechar='^'; 
options nonumber nodate nocenter orientation=portrait papersize=letter 
	leftmargin=1.5cm rightmargin=1.5cm topmargin=1.5cm bottommargin=1.5cm;;
ods pdf file="&path./test.pdf" dpi=300 notoc; 
proc report data=sashelp.cars (obs=10) ps=48 ls=135 split='|';
column make Model;
run;
footnote1 "^S={}^S={font=(&fnt)} &ft.";
ods pdf close;

Re: footnote question

Niugg2010 — Mon, 10 May 2021 12:20:18 GMT

Ghosh and Tom, Thank you very much.

Yes. For PDF or rtf we do not need to worry about the footnote length.

I can put part of footnote into body through compute block in proc report.

However, I cooperate with others and their method has limitations and I have to put footnote in footnote statement and output as lst file first. At beginning, I thought maybe we have options to set footnote output in listing and let footnote turn over if it is too long, like RTF or PDF. I guess we have no that option for listing currently. Do not mind. Thanks again

George