topic Re: Problem with column headings in PROC REPORT by using ods rtf text in ODS and Base Reporting

Problem with column headings in PROC REPORT by using ods rtf text

SASUserMD — Mon, 04 Feb 2019 16:09:21 GMT

Hello,

I use ods rtf text to set the TOCs for the table of contents. Now I got a problem with PROC REPORT when I use the ID statement and the page option to insert a page break. As you can see in the following example: For price 1 to 6 there is only a heading on the first page while price 7 to 12 and price 13 to 16 has a heading on each page. When you now delete the ods rtf text, there will be a heading on each page. Can you help me to fix this problem? Why has PROC REPORT a problem with ods rtf text?

ods rtf startpage=yes;

PROC TABULATE DATA=sashelp.pricedata;
	class regionName;
	table regionName , N;
RUN;

ods rtf startpage=now;
ods rtf text="\\TOC ...";

PROC REPORT DATA=sashelp.pricedata(obs=60);
	columns regionName price1 - price16;
	define regionName / display id;

	define price7 / page;
	define price13 / page;
RUN;

ods rtf close;

Thanks for your comments.

Re: Problem with column headings in PROC REPORT by using ods rtf text

VDD — Mon, 04 Feb 2019 16:15:10 GMT

@SASUserMD should this

define price7 / page;
define price13 / page;

be this

define price1 / page;
define price6 / page;

Re: Problem with column headings in PROC REPORT by using ods rtf text

SASUserMD — Tue, 05 Feb 2019 07:04:57 GMT

No, I want a page break before price 7 and 13. But the real problem is the heading. Why is there no heading on the second page after PROC REPORT only - see attachment.

Re: Problem with column headings in PROC REPORT by using ods rtf text

Cynthia_sas — Tue, 05 Feb 2019 17:52:14 GMT

Hi:
I suggest you review this paper https://support.sas.com/resources/papers/proceedings14/SAS038-2014.pdf especially the section titled "What if my Output is Too Wide" that starts on page 12 -- we have an example that shows the headers do not repeat on the "overflow" page. I believe you'll have to try some of the techniques we outline in the paper. Also, I recommend getting the page breaks and headers working as you want before worrying about the TOC. Also, between ODS PROCLABEL statement and CONTENTS= inside PROC REPORT, I don't typically find the need to use ODS TEXT to alter what appears in the TOC.

Cynthia