|Date: ||Wed, 30 Jul 2008 20:06:05 -0400|
|Reply-To: ||"Michael W. Bates" <mwbates@HOTMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Michael W. Bates" <mwbates@HOTMAIL.COM>|
|Subject: ||setting up libname|
I have an ODBC connection to a database that I hit via MS Access. It is a
TCP/IP connection and I have the host IP address / port / username /
password / subsystem / prefix / filter / etc. options set up in the ODBC
connection. I would like to convert this to a SAS libname statement so I
can view and hit the tables straight from SAS.
I have other oracle libname statements that work the way I would like to
configure the ODBC connection. They go something like:
libname smartmart oracle path=cdev.world user=abd123 password=xyz789
Does anyone know how to configure a SAS libname statement to replace the
ODBC connection and MS Access use?
Michael W. Bates