topic Re: Only part of the SQL server tables showed in the SAS explore window in New SAS User

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

haowang — Fri, 17 May 2019 03:29:05 GMT

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!

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

haowang — Fri, 17 May 2019 05:35:55 GMT

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

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

Patrick — Fri, 17 May 2019 08:03:24 GMT

@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.

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

Kurt_Bremser — Mon, 03 Feb 2025 21:46:48 GMT

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.

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.