Who comes up with such crazy table names? We're a VERY large insurance company, and not one table in our production database has a name in excess of 32 characters. Simply because no earnest developer wants to waste time typing (and fixing the typos of) such elaborate constructs.
If people want to write high literature, they should not go into computing.
Since, in your case, the horse is already out of the barn, you can only define views within the database that fit into SAS specifications lengthwise. Given those idiotic table names, I suspect that you will also have to deal with idiotic column names.
Yes, that's a known challenge. SAS table names can currently only be 32 characters max.
You can always use explicit pass-through SQL to work with longer DB table names but if you just want them to become accessible in SAS then you need to create views which comply with the SAS naming standards.
Who comes up with such crazy table names? We're a VERY large insurance company, and not one table in our production database has a name in excess of 32 characters. Simply because no earnest developer wants to waste time typing (and fixing the typos of) such elaborate constructs.
If people want to write high literature, they should not go into computing.
Since, in your case, the horse is already out of the barn, you can only define views within the database that fit into SAS specifications lengthwise. Given those idiotic table names, I suspect that you will also have to deal with idiotic column names.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.