topic Re: Table of contents wrongly inserted into the table header (toc_data option) in ODS and Base Reporting

Table of contents wrongly inserted into the table header (toc_data option)

Chang — Sun, 12 Jun 2016 16:45:42 GMT

hi,

I would like to a RTF file with the table of contents, listing table titles, at page 1 and tables at the following pages. The table of contents inserts wrongly interted into the table body when the toc_data was specified, as can be seen in the following screenshot:

The wrongly displayed table of contents disappeared when the NOTOC_DATA option was specified instead of the TOC_DATA, as shown in this screenshot:

My questions:

how do I correctly insert table titles in the table of content page?
Is there an easy way to make the table autofit to content instead of manually specifying cell width of each column? Now I have specified cWide=25 pt (cellwidth) in the macro. An example of autofit to content:

My script files and data are attached:

NU_020_make_reports_master.sas is a master program where all the table files are excuted. To keep this example simple, I have just included one table.
NU_021_table01.sas is the file where a table is created. This file reads data into SAS
def_display[1].sas contains a macro that writes the DEFINE statement in the REPORT procedure. This macro is called in the file NU_021_table01.sas
NU_021_table01.txt is the data (Tab-delimited txt) to be imported in SAS. NU_021_table01.sas reads this data.
Logo_of_the_QIMR_small.png is the logo that is displayed on the top left of every page in the report RTF.

Thanks in advance!

Chang

Re: Table of contents wrongly inserted into the table header (toc_data option)

Cynthia_sas — Mon, 13 Jun 2016 00:13:43 GMT

Hi:

When I use this code in SAS 9.4, Windows,

Here's my code:

ods rtf file='c:\temp\maketoc.rtf' toc_data contents=yes;
proc print data=sashelp.class;
  title 'SASHELP.CLASS';
run;
  
proc freq data=sashelp.class;
  tables age sex;
run;
  
proc print data=sashelp.classfit;
  title 'SASHELP.CLASSFIT';
run;
  
proc freq data=sashelp.classfit;
  tables age sex;
run;
  
ods rtf close;
title;

And here are results. First, if I click on the "Show/Hide" symbol on the ribbon, I can see the section break at the end of the first page. SAS only puts the field codes into the RTF file, you must manually cause Word (or your word processor of choice) to build the TOC from the field codes. After I click Show/Hide, this is what I see:

Initially, when you look at the file after the Update Fields code, you will probably see the TOC and the field codes because the Show/Hide button is still active. But if you turn off the button, then the field codes are hidden again.

If you look closely at the first cell in the table, you can see that the whole field code is something like:

If you run my code and you DO get the same results that I show here, then there is something in your code that is causing the issue and you might want to open a track with Tech Support so they can look at your code and using your version of SAS and your operating system, see whether they can replicate the problem. If you run my code and you do NOT get the same results that I show here, then, that is also something that needs to be worked on with Tech Support. The Table of Contents in RTF has worked this way since SAS 9.2, so if my code does NOT work for you the same way that I illustrate in my screen shots, then something odd is happening.

cynthia

Re: Table of contents wrongly inserted into the table header (toc_data option)

Cynthia_sas — Mon, 13 Jun 2016 00:14:56 GMT

Oh, forgot your #2 question, I do not believe there is a way to cause RTF to "autofit" the columns to the width of the cell contents.

cynthia

Re: Table of contents wrongly inserted into the table header (toc_data option)

RW9 — Mon, 13 Jun 2016 08:52:41 GMT

I thikn you misunderstand what RTF is. RTF is a text markup language - quite an old one and not being developed any more. What you get out from your procedures is a text file which contains a whole set of control codes, and your text. This file is then opened in a renderer - from your example I assume your using Word. This renderer parses the text file and attempts to create an output representation based on the codes in the RTF. Generally speaking this works reasonably well, however if your doing things like contents pages and such like your going to have difficulties all round - Word's TOC function didn't even exist when RTF was made.

Can I ask wh you are building this in RTF? Almost all Study outputs I have seen are created in this way:

- Create an RTF output from SAS for each individual output

- Build a PDF for a compete section be that Tables, Listings, or Figures

- Document builder teams then incorperate those into the main CSR's or other documents

Re: Table of contents wrongly inserted into the table header (toc_data option)

Chang — Mon, 20 Jun 2016 11:21:27 GMT

hi RW9,

I am using a script file from someone else. Whatever can export TOC and tables to a WORD document would be good. For this purpose, which ODS do you recommend?