Problem Note 16835: An error occurs when DBMS tables do not have unique column names and you try to reference a specific table in SAS® code
 |  |  |  |
An error occurs after you assign a libref to an SQL Server database, using the ODBC engine, and you try to reference a specific table in SAS code. The following error is generated:
ERROR: This DBMS table or view cannot be accessed by the SAS System because it contains column names that are not unique when a SAS normalized (uppercased) compare is performed. See "Naming Conventions" in the SAS/ACCESS documentation.
When the table has field names that are longer than 64 characters AND those names are identical through those 64 characters, SAS does not normalize the names properly.
As a workaround, create a DBMS view to these tables, renaming the longer field names in the view definition.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |||
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity) SAS Reference ==> LIBNAME Engines |
| Date Modified: | 2008-03-04 14:47:49 |
| Date Created: | 2006-01-11 16:08:19 |