The SAS Output Delivery System and reporting techniques

How to only show table header in the first page on ODS RTF from Proc Report

Accepted Solution Solved
Reply
Contributor
Posts: 39
Accepted Solution

How to only show table header in the first page on ODS RTF from Proc Report

Hi,

I am using proc report and ODS RTF to report a table. When there are more than two pages, the table header on the pages except the first page can not be altered. I am wondering if there is any option to allow us to do that.

Example:

These codes will generate a RTF file with column " Smoking", the table header "Smoking" is shown on every page. I just want it appears only on the first page. Any idea?

ods rtf file="testRTF.rtf";

proc report data=sashelp.heart(obs=100) nowd

style(report) = {cellpadding = 1.25pt cellspacing = 2pt frame = hsides rules = groups just=center};

column smoking;

define smoking/ display order=data;

run;

ods rtf close;

thanks,

Z


Accepted Solutions
Solution
‎03-20-2014 01:24 PM
Contributor
Posts: 39

Re: How to only show table header in the first page on ODS RTF from Proc Report

Somehow if replace "ods rtf" with "ods tagsets.rtf" will solve the issue, but the report will be slightly differently with other functions, such as title or footnote.

thanks,

Zhengming

View solution in original post


All Replies
Super User
Posts: 10,552

Re: How to only show table header in the first page on ODS RTF from Proc Report

Unless you have a multitude of tables you need this for it may be easier to turn off the "Repeat Header Rows" in Word (currently buried in Table >Layout), or equivalent in other viewrs.

It may be possible to find the RTF codes for that but incorporating that code may be quite a chore.

Solution
‎03-20-2014 01:24 PM
Contributor
Posts: 39

Re: How to only show table header in the first page on ODS RTF from Proc Report

Somehow if replace "ods rtf" with "ods tagsets.rtf" will solve the issue, but the report will be slightly differently with other functions, such as title or footnote.

thanks,

Zhengming

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 701 views
  • 3 likes
  • 2 in conversation