topic Re: Adding MS Word Styles in ODS RTF outputs for overall table of contents in ODS and Base Reporting

Adding MS Word Styles in ODS RTF outputs for overall table of contents

Tpham — Tue, 09 Nov 2021 00:11:48 GMT

I have a number of SAS programs that produce outputs (e.g. table1_1.SAS, Table2_1.SAS etc) using proc report that produce their respective tables (Table 1.1.RTF and Table 2.1.RTF etc.).

I am trying to merge all outputs (so multiple files produced) into one RTF file and have Microsoft word create a table of contents based on headers.

I've found an old paper on adding MS Word Headers into ODS RTF outputs that is based on SAS 8.2+. I'm sure it would work on the modern SAS 9, but I am wondering if there are more modern approaches.

Re: Adding MS Word Styles in ODS RTF outputs for overall table of contents

Reeza — Tue, 09 Nov 2021 01:08:43 GMT

See if ODS WORD can meet your needs though it's pre-production?

I would definitely redesign my process such that I didn't have to combine multiple RTF files though VBS will do it easily.

Re: Adding MS Word Styles in ODS RTF outputs for overall table of contents

Tpham — Tue, 09 Nov 2021 01:10:39 GMT

I'll explore ods word, but however, each code produce its independent table.

BUt yeah, the process I am thinking about is via VBA after adding headers via SAS

Re: Adding MS Word Styles in ODS RTF outputs for overall table of contents

Reeza — Tue, 09 Nov 2021 01:15:13 GMT

Why does it matter that each code produces a single table? You can nest them as long as you place the ODS RTF statements in the correct location and can control the page breaks the same way.

ods rtf file = '......' style = mystyles;

%include 'generateReport1.sas';
%include 'generateReport2.sas';
...

ods rtf close;

Re: Adding MS Word Styles in ODS RTF outputs for overall table of contents

Tpham — Tue, 09 Nov 2021 01:17:53 GMT

log and lst files needs to be saved for each respective program. so the include statement doesn't fully work because of that as I recall.

Re: Adding MS Word Styles in ODS RTF outputs for overall table of contents

Reeza — Tue, 09 Nov 2021 01:22:01 GMT

PROC PRINTTO at each program start should cover that but I'll leave it there.

Re: Adding MS Word Styles in ODS RTF outputs for overall table of contents

Jianmin — Wed, 10 Nov 2021 01:45:52 GMT

Hi @Tpham ,

The paper you cited is a privative way to answer your request, as @Reeza outlined in this response. You will also have to figure out a way for a cover page or top page to make the TOC visible, something like this:

this is for a large file with many sections which needs a TOC for each section title/header. See this file This is way beyond what SAS ODS RTF REPORT/DOCUMENT is currently doing. Another example for multiple listings/tables with a TOC.

Many Thanks

Jianmin Long