02-03-2016 08:14 AM - edited 02-03-2016 08:16 AM
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.
Does anyone know why I might be getting this error?
the code i'm using came from someone who used this query last fall in SQL. These tables run fine in Hyperion.
It has nothing to do with the fields we select (we actually didn't select any from the problem table)
I've looked in the table and there are no duplicate fields.
This is happening on at least 2 tables in this DBMS. any insight is appreciated. Portico.Pp_Prac and Portico.PP_Prac_Loc tables (so length is not the issue)
Base SAS 9.2 / SAS Enterprise Guide 6.1 - it happens in both
02-03-2016 08:22 AM
First lets check the database. Do an sql describe table from within the database on those two tables giving you a problem:
Then post what the describe text is returned. It could be an incompatible character replacement, or mixed case etc. Can't tell without seein the database structure,
02-03-2016 08:57 AM
DBMS's allow the use of characters in names that are not valid in Base SAS.
IE DB/2 allows the use of the number sign.
Maybe someone added a new field in the database in the meantime that violates SAS rules.
Try to use pass-through SQL to eliminate or change such columns.
02-03-2016 09:15 AM
I will do a pass through and see if that works. Since it worked in sql - i'm hoping that does the trick. I didn't see any characters at all in the field names.
02-03-2016 11:02 AM - edited 02-03-2016 03:25 PM
Another potential issue is the length of SAS variable names, 32 characters, versus your DB. If you have very long variable names such as:
The two variables are identical for the first 32 characters and the usual SAS rules for transforming to a SAS variable would yield the same 32 character variable.
02-04-2016 02:32 AM - edited 02-04-2016 02:32 AM