Date:         Wed, 20 Sep 2006 22:50:31 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: anyone try SAS add-in for MS Office?

On Wed, 20 Sep 2006 15:58:59 -0400, Merlin Marshall <marshall.11@OSU.EDU> wrote:

>Thanks to both Alan and Tom Salwasser who contacted me offline.  Looks like
>there are existing ways to get SAS output into Excel that would work for me
>that don't require the Business Intelligence suite which OSU probably does
>not license.

You may want to ask. SAS used to offer attractively priced bundles to
academic sites.

>Alan's paper sounds pretty nifty and Tom made it look not so
>scarey as well.  I'm still messing around with my Korean labels, so it will
>be a bit before I delve into SAS to Excel.
>
>Thanks again guys, SAS-L folks are the best!
>
>Merlin
>
>On Tue, 19 Sep 2006 11:09:50 -0600, Alan Churchill <SASL001@SAVIAN.NET> wrote:
>
>>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:
>>
>>http://www.savian.net/utilities.aspx
>>
>>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.
>>
>>Alan
>>
>>Alan Churchill
>>Savian "Bridging SAS and Microsoft Technologies"
>>www.savian.net
>>
>>
>>
>>-----Original Message-----
>>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Merlin
>>Marshall
>>Sent: Tuesday, September 19, 2006 10:50 AM
>>To: SAS-L@LISTSERV.UGA.EDU
>>Subject: anyone try SAS add-in for MS Office?
>>
>>Greetings SAS-L!
>>
>>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,
>>Merlin Marshall
>>Data Wrangler
>>Population Research
>>On loan to Center for Human Resource Research Ohio State University Columbus
>>Ohio