SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 49348: Creating RDBMS tables using PRESERVE_TAB_NAMES=YES might generate an error in SAS® Enterprise Guide®

DetailsHotfixAboutRate It

Creating RDBMS tables with the PRESERVE_TAB_NAMES=YES on the LIBNAME statement might generate the following error in SAS Enterprise Guide:

"table-name" does not exist. You will need to
refresh the task that created it before it can be opened. 

Typically, the error occurs the first time that you attempt to create the table if the table name is all lowercase. Subsequent attempts to create the same table are successful.

To resolve this issue, download the latest hot fix for SAS Enterprise Guide 5.1.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Enterprise GuideMicrosoft® Windows® for x645.16.19.2 TS2M0
Microsoft Windows 8 Pro5.1
Microsoft Windows 95/985.1
Microsoft Windows 2000 Advanced Server5.1
Microsoft Windows 2000 Datacenter Server5.1
Microsoft Windows 2000 Server5.1
Microsoft Windows 2000 Professional5.1
Microsoft Windows NT Workstation5.1
Microsoft Windows Server 2003 Datacenter Edition5.16.19.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition5.16.19.2 TS2M0
Microsoft Windows Server 2003 Standard Edition5.16.19.2 TS2M0
Microsoft Windows Server 2003 for x645.16.19.2 TS2M0
Microsoft Windows Server 20085.16.19.2 TS2M3
Microsoft Windows Server 2008 for x645.16.19.2 TS2M0
Microsoft Windows Server 20125.1
Microsoft Windows XP Professional5.16.19.2 TS2M0
Windows 7 Enterprise 32 bit5.16.19.2 TS2M3
Windows 7 Enterprise x645.16.19.2 TS2M3
Windows 7 Home Premium 32 bit5.16.19.2 TS2M3
Windows 7 Home Premium x645.16.19.2 TS2M3
Windows 7 Professional 32 bit5.16.19.2 TS2M3
Windows 7 Professional x645.16.19.2 TS2M3
Windows 7 Ultimate 32 bit5.16.19.2 TS2M3
Windows 7 Ultimate x645.16.19.2 TS2M3
Windows Millennium Edition (Me)5.1
Windows Vista5.16.19.2 TS2M0
Windows Vista for x645.16.19.2 TS2M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.