SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 50797: When the attributes for DBMS tables are defined in SAS® Management Console, new tables based on the existing tables might not have the same attributes

DetailsHotfixAboutRate It

Attributes defined in SAS Management Console on a database management system (DBMS) table might not be present in newly created SAS data sets when the following conditions exist:

  • You are accessing a DBMS table via a LIBNAME engine through the META engine
  • The query triggers implicit pass-through processing

The attributes that might not appear in the SAS data set are as follows:

  • FORMAT
  • INFORMAT
  • LABEL

To work around this issue, either pre-assign the library rather than using the META engine or add the appropriate column modifiers in the query.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASz/OS9.3 TS1M09.4 TS1M1
Z649.3 TS1M09.4 TS1M1
Microsoft® Windows® for x649.3 TS1M09.4 TS1M1
Microsoft Windows Server 2003 Datacenter Edition9.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.3 TS1M0
Microsoft Windows Server 2003 Standard Edition9.3 TS1M0
Microsoft Windows Server 2003 for x649.3 TS1M0
Microsoft Windows Server 20089.3 TS1M0
Microsoft Windows Server 2008 R29.3 TS1M09.4 TS1M1
Microsoft Windows Server 2008 for x649.3 TS1M09.4 TS1M1
Microsoft Windows XP Professional9.3 TS1M0
Windows 7 Enterprise 32 bit9.3 TS1M0
Windows 7 Enterprise x649.3 TS1M09.4 TS1M1
Windows 7 Home Premium 32 bit9.3 TS1M0
Windows 7 Home Premium x649.3 TS1M0
Windows 7 Professional 32 bit9.3 TS1M0
Windows 7 Professional x649.3 TS1M09.4 TS1M1
Windows 7 Ultimate 32 bit9.3 TS1M0
Windows 7 Ultimate x649.3 TS1M0
Windows Vista9.3 TS1M0
Windows Vista for x649.3 TS1M0
64-bit Enabled AIX9.3 TS1M09.4 TS1M1
64-bit Enabled HP-UX9.3 TS1M09.4 TS1M1
64-bit Enabled Solaris9.3 TS1M09.4 TS1M1
HP-UX IPF9.3 TS1M09.4 TS1M1
Linux9.3 TS1M09.4 TS1M1
Linux for x649.3 TS1M09.4 TS1M1
Solaris for x649.3 TS1M09.4 TS1M1
* 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.