Date:         Mon, 29 Jan 2001 08:38:26 -0500
Reply-To:     "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>
Organization: Duke Clinical Research Institute
Subject:      Re: SAS communication with MS Word
Content-Type: text/plain; charset=us-ascii

VB WILL be useful (not might), for anything but the most simple formatting.  We do
it with C++ (and function sets that we have purchased); it ain't pretty.  It also
puts you at more dependence on MicroSoft.  Every time they update Word, you have
to go through all your VB code and update it.

There are some SAS Macros that will output Word documents (with a lot of data
steps and put statements) -- they were in a SUGI proceeding and are on some of the
SAS archives.  They do not rely on VB, but do limit the kinds of things that you
can do.  We have used them to generate large tabular reports.

Doc
--------------
ZPAN wrote:

> I want to write a SAS program which can create a MS Word macro and, if
> possible, invoke this macro.
>
> Different SAS programs produce different SAS outputs, and the SAS outputs need
> to be converted into MS Word files using different MS Word macros. It is easy
> to record those macros within MS Word application, but I do not know how to do
> it using SAS statements. I guess VB might be helpful.
>
> Can anybody help me out?
>
> Thanks, Ziqing

--
Lawrence H. ('Doc') Muhlbaier           muhlb001@mc.duke.edu
Assistant Research Professor
Duke University Medical Center          919-668-8774 (office)
DUMC 3865                               919-383-0595 (home)
Durham, NC 27710-7510                   919-668-7057 (FAX)