topic Re: PROC Report footer in SAS Programming

PROC Report footer

JohnChen_TW — Tue, 29 Aug 2017 07:28:43 GMT

Hi everyone,

I'm using SAS 9.3. I'd like to add a 'Note' at the end of the report instead of the footer by PROC Report, how should I do

Re: PROC Report footer

andreas_lds — Tue, 29 Aug 2017 07:51:52 GMT

Several papers exists describing the more advanced uses of proc report:

http://www2.sas.com/proceedings/sugi24/Coders/p080-24.pdf

http://support.sas.com/resources/papers/proceedings10/215-2010.pdf

Re: PROC Report footer

Ksharp — Tue, 29 Aug 2017 12:46:24 GMT

try the following code:

compute after ;

line 'Note: xxxxxxxxxxx';

endcomp;

Re: PROC Report footer

JohnChen_TW — Wed, 30 Aug 2017 06:58:24 GMT

Thanks. It works, but how can I make the 'Note: xxxx' out of the line at the end report?

Re: PROC Report footer

JohnChen_TW — Wed, 30 Aug 2017 08:00:20 GMT

Besides, the 'Note:xxxxx' is the data out of table cells, how can I adjust its font-style by 'proc template; ....; replace fonts/ ...;'?

Re: PROC Report footer

Ksharp — Wed, 30 Aug 2017 12:16:54 GMT

You could try this:

compute after _page_;
line 'Note:xxxxx';
endcomp;


Change style , you could use escapechar:

ods escapechar='~';
.........
computer after ;
line " ~S={background=blue}  Note:xxxxxxx ";
endcomp;


If the above still can't work. I suggest you post your question at ODS forum. @Cynthia is there.
Maybe she has a better idea.

Re: PROC Report footer

JohnChen_TW — Thu, 31 Aug 2017 05:39:30 GMT

It works now!
Many thanks for your great help!!!

JC