Date: Tue, 19 Sep 2006 11:09:50 -0600
Reply-To: Alan Churchill <SASL001@SAVIAN.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Alan Churchill <SASL001@SAVIAN.NET>
Subject: Re: anyone try SAS add-in for MS Office?
Content-Type: text/plain; charset="iso-8859-1"
SAS Add-In for Office allows you to submit SAS code from a MS app and get
the output into the particular MS Office product. It is cool but is designed
for a very specific need: a user wants to fire SAS from Excel, say, and get
the results into Excel.
There are numerous ways to get SAS data into Excel (including export, excel
libname, ods, xml, blah, blah, blah). The absolute fastest and the method
providing the most control is described by me in a paper on my website
called How to generate 10,000 Excel spreadsheets. You can find it at the
bottom of the page here:
Insofar as SAS output is concerned, if you run a proc report and need that
in Excel, welcome to the SAS Add-In developer's world. That's what they did.
If that is the case, I would purchase the product or else get really good at
parsing the text. You can do it using SAS Integration Technologies for code
submission and output management.
Savian "Bridging SAS and Microsoft Technologies"
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Merlin
Sent: Tuesday, September 19, 2006 10:50 AM
Subject: anyone try SAS add-in for MS Office?
I ran across a note about SAS add-in for MS Office, and read the ad for it
on the SAS website. Does anyone have this and is it very useful? Is it
worth the amount SAS wants for its licensing?
I've been asked to create SAS programs to populate Excel tables with SAS
output for a researcher. I've followed along with some of the discussion on
this listserv about automating SAS to Excel, and it mostly sounds like a big
pain to get it set up right. I have yet to try doing this, nor do I know
about forms, reports and so on, so this is going to be a steep learning
curve for me. If this add-in is easy and not too costly, I might try
talking my organization into purchasing it (if we don't have it already - I
can't be the only one here doing this sort of thing.)
Thank you kindly,
On loan to Center for Human Resource Research Ohio State University Columbus