Proc Report- remove space between table and footnotes

[jenim514]

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?

[Ksharp]

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;

[jenim514]

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.

[Ksharp · Accepted solution]

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;

[Tom]

---

@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.