Date: Mon, 26 Apr 2004 13:08:28 -0500
Reply-To: "Sudhakaran, Manju (MBNP ms)"
<Manju.Sudhakaran@US.MILLWARDBROWN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Sudhakaran, Manju (MBNP ms)"
<Manju.Sudhakaran@US.MILLWARDBROWN.COM>
Subject: Re: SQL Server reading SAS via OLE DB
Content-Type: multipart/mixed;
The following website is handy for those trying to access SAS from windows
platform Applications (Access, SQL server, excel etc) using ODBC.
http://www.hollandnumerics.co.uk/bcarda/BCARDA.HTM
Thanks & Regards,
Manju
Marketing Science
Millward Brown
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Dougherty, Kristine
Sent: Monday, April 26, 2004 9:29 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: SQL Server reading SAS via OLE DB
Our IT folks want to use SQL Server to read a SAS dataset. We don't license
SAS/Share currently, so my understanding is that they would have to use the
Local Data Provider in Base SAS 8.2. I've used Access to OLE DB to read SQL
Server, but never the reverse. What do they need to do in order to pull
from a Version 8 SAS dataset?
Kristine Dougherty
Bureau of Research & Data Analysis
Florida Dept. of Corrections
2601 Blair Stone Rd.
Tallahassee, FL 32399-2500
850-410-4487
dougherty.kristine@mail.dc.state.fl.us
====================================================
This email is confidential and intended solely for the use of the
individual or organisation to whom it is addressed. Any opinions or
advice presented are solely those of the author and do not necessarily
represent those of the Millward Brown Group of Companies. If you are
not the intended recipient of this email, you should not copy, modify,
distribute or take any action in reliance on it. If you have received
this email in error please notify the sender and delete this email
from your system. Although this email has been checked for viruses
and other defects, no responsibility can be accepted for any loss or
damage arising from its receipt or use.
====================================================
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
|