topic Re: PROC Report Heading horizontal line in SAS Programming

PROC Report Heading horizontal line

JohnChen_TW — Thu, 31 Aug 2017 06:14:32 GMT

Hi everyone,

I'm using SAS 9.3.

Does anyone have a suggestion to set a horizontal line in the heading like this?

Re: PROC Report Heading horizontal line

ChrisBrooks — Thu, 31 Aug 2017 09:37:50 GMT

I think Figure10 in this paper is pretty close to what you want https://support.sas.com/resources/papers/proceedings11/246-2011.pdf

Re: PROC Report Heading horizontal line

Ksharp — Thu, 31 Aug 2017 12:34:47 GMT

You are luck man. Here is:

ods escapechar="^";
proc report...;
  columns x ("^R'\brdrb\brdrs\brdrw15 'Powers" y z) ;

Re: PROC Report Heading horizontal line

JohnChen_TW — Fri, 01 Sep 2017 07:41:03 GMT

Yes, Figure 10 is what I want! Thank you very much!

Re: PROC Report Heading horizontal line

JohnChen_TW — Fri, 01 Sep 2017 09:44:03 GMT

Hi @Ksharp,

Thanks for your help, it works!

May I ask another question continued the previous post? (PROC Report footer).

Now, I could put "Note: xxx" at the end of the table and out of the bottom border line.

But, it cannot be presented on every page when the total page of the table is more than 1. (In some tables, it is only presented on the last page. Why?)

How should I do?

Here is my partial code:

proc template...;
...
replace Table from Output / frame=above;
...
end;
run;

And I put "Note: xxx" using:

compute after _page_/style={just=l font_face='Arial' font_size=10pt bordertopcolor=black bordertopwidth=0.25};
line "Note:";
line "The unit of age is year";
endcomp;

Re: PROC Report Heading horizontal line

Ksharp — Fri, 01 Sep 2017 12:19:11 GMT

Sorry. I have no idea about it.
I remember there is an option BODYTITLE for proc report, but I don't know if it is worked for FOOTNOTE.
I suggest you post it at ODS REPORT forum, @Cynthia is there, maybe she could give you answer.

Re: PROC Report Heading horizontal line

ballardw — Fri, 01 Sep 2017 15:39:19 GMT

Which ods destination are you using and what does the ODS destination like look like? Different destinations have different options for title and foot note appearance.

Re: PROC Report Heading horizontal line

JohnChen_TW — Mon, 04 Sep 2017 03:04:52 GMT

I'm using

PROC REPORT;
...
...
...
RUN;

ODS RTF file="xxxxx.rtf"  style=xxxxx ;  
ODS PRINTER PDF file="xxxxx.pdf"  style=xxxxx replay; run;
ODS PRINTER PDF PDF CLOSE;
ODS RTF CLOSE;