Table names exceed 32 characters

[deleted_user]

Hi

I have about 75 sql tables to merge together but some are not visible in SAS due to their length.
So i have written a simple sql statement to create a new table merging them all.
Is there a way of either running that script within SAS, or any other way of doing it?

Thanks

Simon

[sbb]

Your computing OS and environment is unspecified. Consider the info in the SUGI/SGF paper below, on SAS/Connect, for remote or batch-script processing using SAS.

Scott Barry
SBBWorks, Inc.

http://www2.sas.com/proceedings/forum2007/241-2007.pdf

[LinusH]

My guess is that your data is stpored in an external RDBMS. To do this from SAS I would consider SQL pass-thru. See on-line doc for details on your RDBMS.

//Linus

[deleted_user]

Hi

Im running SAS v9.1.3 on Windows.
the sql statement i wrote was in mySQL.
so this statement will not run in SAS due to table lengths.

thanks