03-17-2015 10:32 AM
Simply put, No. There is not much you can do within SAS. You can though, access those tables (I assume this happens with other relational database, such as Oracle, SQL server etc) using explicit pass-thru.
03-17-2015 11:31 AM
The question is why? 32 characters is far and away enough for any dataset id, if you need further information put it in the dataset label.
data internal_id (label="This is a really long bit of information which describes the dataset called internal_id");
You don't want:
As that's not easy to work with.
03-17-2015 02:07 PM
SAS doesnt support table names longer than 32 characters.
Its an antiquated rule that my fingers are thankful for but that I hate in many cases.
03-18-2015 05:00 AM
In the mean time you could do one of the following:
As a best practice you could use the original full lenght table name in the meta data name, or in the description.
03-17-2015 02:41 PM
Several DBMSs support table names longer than 32 chars. If you create libraries of these in SAS they just won't display and your only option for reading them is SQL Passthru.
If you think it would be a good idea to support longer names then vote for this idea: https://communities.sas.com/ideas/3506