topic Collecting existing files into a word document in a given order in ODS and Base Reporting

Collecting existing files into a word document in a given order

janpeter — Mon, 17 Feb 2020 12:04:21 GMT

my question is whether there is a way to collect existing files (txt, png, rtf etc) into a word document (docx) and create a TOC?

Building a docx file from scratch is a possibility but if SAS already has this functionality then it would be good to be aware of it.

The desired output (docx) should contain the files according to a pre defined order.

ex Table 1 ... Table 10, Graph1, Table11 - Table13, Graph2 - Graph5, ...

So running the programs in a given order using ODS is not practical as there can easily become hundreds of them.

BR
Jan

Re: Collecting existing files into a word document in a given order

Cynthia_sas — Mon, 17 Feb 2020 16:45:06 GMT

Hi:

If all the output is created by SAS and if you can run the programs and save the output objects in an ODS DOCUMENT store, then you can rearrange and replay the objects in the order/structure you make. See this paper https://support.sas.com/resources/papers/sgf09/318-2009.pdf and notice how, originally, the PROC TABULATE and the UNIVARIATE output is created and structured (on page 4, it shows all the TABULATE followed by all the UNIVARIATE).

But, in the paper, the desired output is to have the results organized by country and not by procedure. So after storing the objects in a document store, the objects are restructured and replayed as shown on page 7, Figure 11.

Alternately, you could write a SAS Macro program to control the creation of the results in the order you choose.

Hope this helps,

Cynthia

Re: Collecting existing files into a word document in a given order

ChrisNZ — Mon, 17 Feb 2020 21:31:31 GMT

DOCX output support is coming but not totally there yet:

The SAS® Output Delivery System (ODS) destination for Word enables customers to deliver
SAS® reports as native Microsoft Word documents. The ODS WORD statement generates
reports in the Office Open XML Document (.docx) format [8><] ODS WORD is preproduction in the
sixth maintenance release of SAS 9.4.

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3235-2019.pdf

Re: Collecting existing files into a word document in a given order

janpeter — Mon, 08 Jun 2020 14:43:19 GMT

Hi Cynthia,

sorry for the very late reply. Thank you for your answer. it looks promising.

I would guess that this also works for docx? currently i have it as preproduction in my SAS version but it will most likely be the standard to go with in the future.

jan

Re: Collecting existing files into a word document in a given order

janpeter — Mon, 08 Jun 2020 14:45:08 GMT

thanks Chris,
br
JP