topic Re: Append two Word Documents in SAS in SAS Enterprise Guide

Append two Word Documents in SAS

Abinaya — Wed, 05 Dec 2018 11:08:30 GMT

Hi..

I got new requirement to append two Word Documents for example :One is Standard Business Requirement Document and the other being the one which will be result of SAS Code.

I have used ODS Command to create Document using SAS and now stuck while appending this document with existing Business Document.

Any leads on this ?

TIA..

Regards,

Abi

Re: Append two Word Documents in SAS

Kurt_Bremser — Wed, 05 Dec 2018 12:05:53 GMT

Maxim 14: Use the Right Tool. For MS Office, this is VBA.

You can also use the Add-In for Microsoft Office from within Word to embed results from SAS (eg the output of a stored process).

SAS does not provide mechanisms to manipulate Word Files, you can only create them. And that part (ODS WORD) is still marked as "Pre-Production", as the method used up to now is ODS RTF.

Re: Append two Word Documents in SAS

Abinaya — Wed, 05 Dec 2018 16:53:18 GMT

Thanks for your reply..

But what is the right tool??Can you please explain in detail?..Client has provided with SAS Enterprise Guide and also with only Server access..(not on Local Host Access).

with this Pre-defined SAS Setup,will I be able to achieve Word Document Manipulation using SAS?

Any insghts on alternative approach.I will deep dive into it

Thanks!

Abi

Re: Append two Word Documents in SAS

Kurt_Bremser — Wed, 05 Dec 2018 18:16:35 GMT

As I already told you: the proper tool for MS Office automation is Visual Basic for Applications (VBA). Once you have a VBA script that does it, you might contemplate to run it from SAS as an external command.