Date: Mon, 15 Nov 2004 12:44:38 -0500
Reply-To: Mike Rhoads <RHOADSM1@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mike Rhoads <RHOADSM1@WESTAT.COM>
Subject: Re: SQL Server, T-SQL & Linking
Interesting question. Although I haven't tried this, the answer is almost
certainly "Yes, but only up to a point."
Given SQL Server's ability to link to data in other formats, I can't see any
reason why it couldn't, for instance, retrieve data from a SAS data set. On
the other hand, SAS data sets inherently don't support commit and rollback,
and I don't see how processing them with SQL Server could add this
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of lebeau
Sent: Monday, November 15, 2004 10:42 AM
Subject: SQL Server, T-SQL & Linking
Is it possible to use SQL Server 2000 to work on PC sas datasets. I
would like to use T-SQL and stored procedures to insert and update
data on my sql server. I FTP data from a mainframe to a Windows PC.
I want sql server to handle all the processing (updates, inserts,
commits and rollbacks, etc.).
I have the SAS ODBC driver and am looking to create a linked server to
a sas dataset on a local machine.