Remote Libraries

[nickdel]

Hi, using SAS version 8. If I set up a remote library to a SQL Server, any tables on that SQL server with names longer than 32 characters do not show in the library. Is there a setting somewhere to just have SAS truncate the name so it is visible?

Cheers

Nick

where would we be without rhetorical questions...

 

[nickdel]

Nevermind, got this one working using SQL passthrough:

  proc sql; 
   connect to odbc(dsn=sqlsrv user=user pwd=pwd); 
   create table new as select * from connection to odbc 
   (select * from ReallyReallyReallyReallyReallyLongTableName); 
   quit;

Nick

where would we be without rhetorical questions...