Append two Word Documents in SAS

[Abinaya]

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

[Kurt_Bremser]

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.

[Abinaya]

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

[Kurt_Bremser]

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.