Date: Fri, 2 Feb 2007 10:28:08 -0700
Reply-To: Alan Churchill <SASL001@SAVIAN.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Alan Churchill <SASL001@SAVIAN.NET>
Subject: Re: Integrate with Excel
In-Reply-To: <002c01c7463a$0e7b7d50$0403a8c0@zencos.com>
Content-Type: text/plain; charset="iso-8859-1"
Don,
Awhile back, I made a video demonstrating Excel communicating to a web
service and pulling down SAS data. That video is item #19 here:
http://www.savian.net/utilities.aspx
Setting it up was relatively easy and only took an hour or so. Others
mileage may vary.
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 Don
Henderson
Sent: Thursday, February 01, 2007 12:49 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Integrate with Excel
Sounds like a good idea.
I am guessing that it will be easier for Excel to consume the data using its
built-in support for web services vs. the older technique of web queries.
I guess it also depends on what software Mike has access to. So at this
point we should probably wait for his reply ;-).
Regards,
-don
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Alan
Churchill
Sent: Thursday, February 01, 2007 2:40 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Integrate with Excel
Don,
How about setting up SAS/IntrNet on the Unix box and surfacing the SAS data
via a web service? Then do the Excel pull from a Windows dll/exe and just
throw out spreadsheets at a blinding rate? You can achieve thousands and
thousands of sheets a minute performance if you approach this properly.
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 Don
Henderson
Sent: Thursday, February 01, 2007 7:33 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Integrate with Excel
Mike,
First, you really have two issues. One is integration with Excel as you
describe. The second issue is that you data is on a remote server that uses
a different OS. So you also need a mechanism to access the data remotely.
There are two options that I can think of off the top of my head to allow
you to access the data remotely. I am sure there are others, and the folks
on this list will likely offer others.
First, if you have the SAS9 BI or EBI platform, you might be able to use the
Add-In for Microsoft Office.
If you don't have the BI/EBI platform, you might be able to Excel's Web
Query facility combined with the SAS/IntrNet Application Dispatcher. The web
query you define to Excel would be for an Application Dispatcher program
that would return the appropriate data to you.
HTH,
-don h
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mike
Durbin
Sent: Thursday, February 01, 2007 8:59 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Integrate with Excel
I would like to integrate the SAS server(AIX) with MS Excel. Today we use
the excel tagsets to produce highly formatted spreadsheets but in some
instances we have to produce thousands of workbooks with url's to link them
together for drill down purposes. It would seem that if I could use VBA in
excel with making the SAS server available to Excel it would be a much
cleaner way of producing these workbooks without having to store them. Can
anyone tell me how best to accomplish this communication between Excel and
SAS?
Thanks,
Mike Durbin
