Only part of the SQL server tables showed in the SAS explore window

[haowang]

Dear there,

I am stuck by a simple problem. As I connect to my SQL Server through ODBC, I can see only part of the tables.

The following is the SAS code I used to connect to ODBC:

libname  mypega	 ODBC DSN  = 'PEGA'   schema=DecisionPoint;

SQL Server

SAS Explore Window

Anyone who have the same problem before?

Thanks a lot!

[haowang]

It seems that this is caused by the very long name of the SQL Server tables.

[Patrick]

@haowang 

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.

[Kurt_Bremser · Accepted solution]

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.