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 (February 2011, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 16 Feb 2011 19:17:25 -0500
Reply-To:   Michael Raithel <michaelraithel@WESTAT.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Michael Raithel <michaelraithel@WESTAT.COM>
Subject:   Re: Getting SAS 9.2 on local PC to interact with MS SQL Server 2005
In-Reply-To:   <418542.4339.qm@web39408.mail.mud.yahoo.com>
Content-Type:   text/plain; charset="utf-8"

Dear SAS-L-ers,

Irin Later posted the following:

> Currently we have SAS 9.2 installed on my local machine and I am unable > to access corporate DW which is located on MS SQL Server 2005. > I am trying getting SAS 9.2 to interact with MS SQL Server 2005 through > ODBC connection. > SAS /ACCESS Interface to ODBC as well as SAS /ACCESS Interface to PC > files are part of our license. > So far my questions are the followings: > -How can I set up SAS driver (SAS /ACCESS Interface to ODBC)? > -Also I am not sure what the name of my SAS Server….Is there any SAS > proc with which I can get this name? > -How can I get SAS to interact with our DW through  'libname .. odbc? > What kind of setting are needed? > Irin, in addition to the great advice that you already received from Dan and Roy, I would like to bring your attention to this excellent paper by fellow Westatian, Mike Rhoads:

Avoiding Common Traps When Accessing RDBMS Data

http://support.sas.com/resources/papers/proceedings09/141-2009.pdf

It might just help you avoid some traps up-front as you wrestle with that SQL Server database!

Irin, best of luck in all your SAS endeavors!

I hope that this suggestion proves helpful now, and in the future!

Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel@westat.com

Author: Tuning SAS Applications in the MVS Environment

Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172

Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ The best measure of a man's honesty isn't his income tax return. It's the zero adjust on his bathroom scale. - Arthur C. Clarke +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu