topic Re: Table names exceed 32 characters in SAS Programming

Table names exceed 32 characters

deleted_user — Thu, 31 Jul 2008 15:17:39 GMT

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

Re: Table names exceed 32 characters

sbb — Thu, 31 Jul 2008 16:27:21 GMT

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

Re: Table names exceed 32 characters

LinusH — Mon, 04 Aug 2008 11:11:53 GMT

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

Re: Table names exceed 32 characters

deleted_user — Mon, 04 Aug 2008 15:45:49 GMT

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