Date:         Tue, 6 Sep 2005 15:41:15 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Can a SQL Server db used as source for SAS analytical module
Comments: To: buddha@gardener.com
Content-Type: text/plain; charset="US-ASCII"

Buddha:
Take a look at SAS/Access and the OLEdb engine (middleware). It requires
a separate license in many situations, but it provides the capability
that you need to read MS SQL Server tables as SAS tables. It will also
support creating MS SQL Server tables and inserts/updates in tables, as
well as bulk loading of data. SAS statistical processing will be done on
the platform with a SAS license and installation (probably not the
database server); nonetheless, subsetting of data and summarization can
take place on the database server to reduce traffic across a network.
Sig

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of buddha@gardener.com
Sent: Tuesday, September 06, 2005 2:16 PM
To: sas-l@uga.edu
Subject: Can a SQL Server db used as source for SAS analytical module


We are currently setting up a SQL Server database that we plan on being
the source for analysis being done using SAS Stat.

We would like to know if there is a way that all processing be done on
the sever instead of using a library on a pc.

 Probaly, I am not communicating very well because I am new to SAS. What
we want to know is if all input and output records be read from and
written to database tables and if all sql can be directed to the
database.

We would like to use SAS and at the same time not send a lot of data
accross our network.

MCB