connect ODBC (dsn) via libname function

[deleted_user]

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

[Cynthia_sas]

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