RTF reports

[ellouho1]

Dear users,

I am trying to generate a table of contents using this statement before each PROC REPORT:

ods rtf text="^S={outputwidth=100% just=l fontsize=1} {\tc\fs0\cf8 Title1}";

The table of contents was successfully created but the Headers of each table (generated by PROC REPORT) are not repeated in each page if the table is long.

Next page:

Without using the RTF TEXT, the highlighted header is repeated in each page.

Could anyone provide a solution?

Thanks

[andreas_lds]

Does this help: https://support.sas.com/kb/24/032.html

EDIT: No this won't help ... sorry.

[Reeza]

I don't believe ODS statements are repeated but titles are repeated. What happens if you use a TITLE statement instead?

---

@ellouho1 wrote:

Dear users,

I am trying to generate a table of contents using this statement before each PROC REPORT:

ods rtf text="^S={outputwidth=100% just=l fontsize=1} {\tc\fs0\cf8 Title1}";

The table of contents was successfully created but the Headers of each table (generated by PROC REPORT) are not repeated in each page if the table is long.

Next page:

Without using the RTF TEXT, the highlighted header is repeated in each page.

Could anyone provide a solution?

Thanks

---

[ellouho1]

I was not talking about repeating titles. I am trying to repeat headers of each column in the next page once the table is long.

The statement below doesn't show any title, It is just linking the title to be displayed in the first page of table of contents:

ods rtf text="^S={outputwidth=100% just=l fontsize=1} {\tc\fs0\cf8 Title1}";

[Reeza]

Ok, can you post the full code, using demo data to reproduce the problem.You're using ODS RFT, can you also include your version of SAS, ie SAS 9.4 TS1M5

[ellouho1]

Thanks,

SAS version: SAS 9.4 TS1M3

You can check the code below:

Try once by running this code, will find that headers of Table 2 are not repeated. 

Then you can put in comment the statement ODS RTF TEXT, you will find that the header is repeated in every page but it is not displayed in table of contents.

ODS ESCAPECHAR="^";
option orientation=landscape;
ods rtf file = "E:\USER10\Test1.doc"
STYLE = SasDocPrinter
nogtitle
nogfootnote
startpage=yes
nobodytitle
notoc_data contents=yes;

title1 "Table 1" j=l;
ods rtf text="^S={outputwidth=100% just=l fontsize=1} {\tc\fs0\cf8 Table 1}";
proc report data = sashelp.class headline headskip nowd split = "@" missing
style(report)=[rules = all
background = white
bordercolor = gray
width=100%
borderwidth = .1 pt
just=center]
style(header)=[frame = box
background = white
bordercolor=gray fontsize=8pt]
style(column)=[fontsize=8pt]
style(lines)=[fontsize=8pt];
column name sex height age weight;

define name / " " left width=110 style(column)={cellwidth=400} group;

run;

ods rtf startpage=now;

title1 "Table 2" j=l;
ods rtf text="^S={outputwidth=100% just=l fontsize=1} {\tc\fs0\cf8 Table 2}";

proc report data = sashelp.demographics headline headskip nowd split = "@" missing
style(report)=[rules = all
background = white
/*cellspacing = 0*/
bordercolor = gray
width=100%
borderwidth = .1 pt
just=center]
style(header)=[frame = box
background = white
bordercolor=gray fontsize=8pt]
style(column)=[fontsize=8pt]
style(lines)=[fontsize=8pt];
column name region pop totalfr gni MaleSchoolpct;
define name / " " left width=110 style(column)={cellwidth=400} group;

run;

ods rtf close;

[Reeza]

Not super helpful, I tried it with all variations and none had repeating headers - using SAS 9.4 TS1M6

[andreas_lds]

If you want to repeat column-headers you should follow the link I posted.

[ellouho1]

Using Uniform option, I was not able to create the table of contents:

26 ods rtf file = "E:\USER10\Test1.doc"
27 STYLE = SasDocPrinter
28 nogtitle
29 nogfootnote
30 startpage=yes
31 nobodytitle
32 notoc_data contents=yes uniform;
                                               -------
                                               22
                                               202
ERROR 22-322: Syntax error, expecting one of the following: ;, ANCHOR, AUTHOR, BASE, BODY, BOOKMARK, BOX_SIZING, CHARSET, CLOSE,
COLUMNS, CONTENTS, CSSSTYLE, DATAPANEL, DOM, DPI, ENCODING, FILE, FONTSCALE, GFOOTNOTE, GTITLE, HOST, IMAGE_DPI,
KEEPN, LSTPIPE, NEWFILE, NOCONTENTS, NOGFOOTNOTE, NOGTITLE, NOKEEPN, NOLSTPIPE, NOOUTLINE, OPERATOR, OUTLINE,
PACKAGE, PATH, RECORD_SEPARATOR, SAS, SASDATE, SGE, STARTPAGE, STYLE, TEXT, TITLE, TRANTAB.

ERROR 202-322: The option or parameter is not recognized and will be ignored.

[andreas_lds]

You have to change

ods rtf

to

ods tagsets.rtf

See the linked article.

But using

ods rtf file="&STUDIOPARENTDIR/odsrtf.rtf" ;
title "This is a title";

data class;
    set sashelp.class;

    do i=0 to 1 by .1;
        age=age+i;
        output;
    end;
run;

proc tabulate data=class missing;
    class sex age;
    var height weight;
    table sex*(age*all) all , weight height*f=comma8.;
    keylabel all='Total' sum=' ';
run;

ods rtf close;

column-headers are repeated.

[ellouho1]

Yes I tried with both rtf and tagsets.rtf but I got the  same error:

[ballardw]

NOTOC_DATA is not listed as an option for  ODS tagsets.rtf.

Just as Uniform is not an option for ODS RTF.

Yes it is frustrating that two similar outputs have some options in common but not others.

[ellouho1]

Yes that's true, as tagsets.rtf does not accept notoc_data as option so I could not provide the table of contents