SAS: Table name with too many characters -

sas has 32 character limit table- , column-names. have scenario want select table , join table b (where table b has name above 32 characters). if try write in proc sql, error saying table b has name exceeding 32 characters.

anyone know how can arround this?

assuming working non-sas dbms, sql server, should use passthrough sql process select, works rdbms's syntax , doesn't have 32 character limitation.

ie:

proc sql;   connect oledb (... init string ... );   create table work.mydata      select * connection oledb (       ... sql server or whatever syntax ...     ); quit; 

you ask dba construct view had < 32 character long name.