LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page