Re: Table names exceed 32 characters

deleted_user · Posted 07-31-2008 11:17 AM

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 · Posted 07-31-2008 12:27 PM

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 · Posted 08-04-2008 07:11 AM

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

Data never sleeps

deleted_user · Posted 08-04-2008 11:45 AM

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

Table names exceed 32 characters