DATA Step, Macro, Functions and more

Table names exceed 32 characters

Reply
N/A
Posts: 0

Table names exceed 32 characters

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Table names exceed 32 characters

Posted in reply to deleted_user
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
Super User
Posts: 5,424

Re: Table names exceed 32 characters

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Table names exceed 32 characters

Posted in reply to 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
Ask a Question
Discussion stats
  • 3 replies
  • 136 views
  • 0 likes
  • 3 in conversation