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
You may want to ask. SAS used to offer attractively priced bundles to
>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!
>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:
>>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