Because the maximum length of a SAS name is 32 characters, DBMS table names that are referenced with the LIBNAME engine must follow SAS naming rules. A DBMS table name that is longer than 32 characters cannot be referenced using the LIBNAME engine.

In this situation, you can do any of the following:

• From within the DBMS, rename the table name so that it follows SAS naming rules.
• From within the DBMS, you can create a view to this table, giving the view a name that follows SAS naming rules, and then the view will be available to the LIBNAME engine.
• Specify the longer name using PROC SQL pass-through. Here is an example (this example uses SAS/ACCESS^® Interface to ODBC):
   

  proc sql;
  connect to odbc(dsn=mydsn user=xxxx pwd=yyy);
  select * from connection to odbc
  (select * from my_table_with_a_very_Very_Very_Long_name);
  disconnect from odbc;
  quit;