We're doing a mix of approaches here. Most of the SAS reports we present on the website are generated in real-time by SAS with the html page fed back via the site. In these cases clicking the link just fires off the SAS process which then queries our SQL server for live data. In a couple of cases where we know the data won't be updated but once per day, a SAS dataset is cached on the SAS server rather than hitting SQL for each request. And in another case I use a CF Scheduled Task to fire off a SAS report that populates a SQL table with data for email reports.
As we move into some more intensive analysis we'll likely be firing off SAS processes to run overnight with html reports dropped out onto the CF server and cfincluded where appropriate. Ken -----Original Message----- From: Deeds, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:05 PM To: CF-Talk Subject: RE: Advanced Statistical Analysis You can use SAS on the desktop. They could save SAS datasets to a location accessible by the web server or on a db server, and if you have the ODBC option the sas dataset can be queried like any db. An other option, depending on how good your sas guys are, is that sas can write its output to a db server, I write sas data to a SQL-2000 server table. That table is then accessed by cf running on one of our intranet servers and the sas data is feed up to the web. Our data is only updated monthly, it is done by the sas guys. We have not explored ways of having a web user kick off sas and retrieve the results, but I am pretty sure it could be done. Dave > -----Original Message----- > From: Deanna Schneider [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 10:12 AM > To: CF-Talk > Subject: Re: Advanced Statistical Analysis > > > I don't really know much about SAS or SPSS, but my > understanding was that > folks are using a desktop version to do their crunching. Is that even > possible, or does a server have to exist somewhere that I > could potentially > tap into? (If there is a server, it's not one of "ours." It > would belong to > the campus computing.) > > -d > > > > Deanna Schneider > Interactive Media Developer > [EMAIL PROTECTED] > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
