BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

I know that table name have a maximum of 32 caracters but I want to know if there is a way to avoid this limitation.

My problem is that I need to import (with a libname) an access bd with table name of 37 caracters. Because the name is too long I cannot see the table in SAS. Here's an example of what I do :

libname tbAccess "Z:\2009\Fissuration1\dt85\KronosData\dt85.mdb";

/* Table name example : Fac_090801_0728_0001502135_2(1)_acgps */

Thanks.
1 REPLY 1
LinusH
Tourmaline | Level 20
Try to create a query with a shorter name which just does select * from original table, and use that in SAS instead.
/Linus
Data never sleeps

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 1 reply
  • 1080 views
  • 0 likes
  • 2 in conversation