topic Re: Proc Report- remove space between table and footnotes in SAS Programming

Proc Report- remove space between table and footnotes

jenim514 — Wed, 27 Dec 2023 18:59:16 GMT

Hi all,

I am trying to remove a space between footnotes and a table using PARSKIP and VSPACE. This worked for removing the space but it also removed the space between the header/ title and the table (which I don't want). Our footnotes are pulled in using a separate macro which I don't want to mess with. SO is there a way to update this code to affect the space after the table only?

Re: Proc Report- remove space between table and footnotes

Ksharp — Thu, 28 Dec 2023 02:22:48 GMT

You could mimic FOOTNOTE by LINE statement.

Here is an example:


title 'xxxxxxxxxx';
%let footnote=zzzzzzzz;

ods tagsets.rtf file='c:\temp\temp.rtf' style=journal;
proc report data=sashelp.class nowd style={outputwidth=100%};

compute after/style={bordertopcolor=black bordertopwidth=2px borderbottomcolor=white borderbottomwidth=2px just=l};
line "&footnote.";
endcomp;

run;
ods tagsets.rtf close;

Re: Proc Report- remove space between table and footnotes

jenim514 — Thu, 28 Dec 2023 18:11:22 GMT

Hi @Ksharp . Thank you for the example. This could possibly work, but is there a way to call a macro using %let? I need to call global macro %footnotes (as it contains all footnotes being pulled in from an excel file etc). I know %let footnote=%footnotes (global macro) does not work, but trying to think of some work around so I can use %footnotes in LINE without manipulating our %footnotes global macro.

Re: Proc Report- remove space between table and footnotes

Ksharp — Fri, 29 Dec 2023 01:05:42 GMT

Use %footnote in LINE statement ?

If there were multi-rows in %footnote , you need manipulate it on your own before LINE.

compute after/style={bordertopcolor=black bordertopwidth=2px borderbottomcolor=white borderbottomwidth=2px just=l};
line "%footnotes";
endcomp;

Re: Proc Report- remove space between table and footnotes

Tom — Fri, 29 Dec 2023 16:38:31 GMT

@jenim514 wrote:

Hi @Ksharp . Thank you for the example. This could possibly work, but is there a way to call a macro using %let? I need to call global macro %footnotes (as it contains all footnotes being pulled in from an excel file etc). I know %let footnote=%footnotes (global macro) does not work, but trying to think of some work around so I can use %footnotes in LINE without manipulating our %footnotes global macro.

To answer that you would have to explain what your FOOTNOTES macro generates. If it generates actual FOOTNOTE statements then it won't work. You would need to change the macro to generate LINE statements instead.