| 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
schema=smartmart;
Does anyone know how to configure a SAS libname statement to replace the
ODBC connection and MS Access use?
Thanks.
Michael W. Bates
mwbates@hotmail.com
| 
