Your SAS programs, embedded in web apps and elsewhere

connect ODBC (dsn) via libname function

Reply
N/A
Posts: 0

connect ODBC (dsn) via libname function

Hi All,
Just do me ur favor, anyone know 'any code' that we can use to connect ODBC (dsn) via libname function.
Thank
SAS Super FREQ
Posts: 8,864

Re: connect ODBC (dsn) via libname function

Posted in reply to deleted_user
Hi!
If you are using SAS in a Stored Process, remember that your library should be defined in the metadata. When you define your data libraries in the metadata, they do not have to be SAS libraries, there is a way to define ODBC libraries. You should contact Tech Support for help in setting up the metadata.

If you are NOT using SAS in a Stored Process, then this documentation on ODBC has an example of a LIBNAME statement on page 7:
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_odbc_7365.pdf

There is some setup that has to be done before you can just use the LIBNAME statement, however. So, again, Tech Support is your best bet for help with this setup.

Good luck!

cynthia

To contact Tech Support, refer to: http://support.sas.com/techsup/contact/index.html
Ask a Question
Discussion stats
  • 1 reply
  • 189 views
  • 0 likes
  • 2 in conversation