Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remote Libraries

Status
Not open for further replies.

nickdel

Programmer
May 11, 2006
367
GB
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...
 
Nevermind, got this one working using SQL passthrough:

Code:
  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...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top