Hello, I am running into problems working with DBMS column names that have a "/" in them. I noticed that when the library was defined in metadata and the table containing the column name with the "/" was registered, SAS changed the name of the DBMS column that had a "/" in it to an "_". However, when I run a proc means statment using this column as a classification variable, the SQL access driver is not able to interpret this variable and gives me a driver error "CLI describe error: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid column name 'Coated'. : [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid column name 'Insulated'. : [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Statement(s) could not be prepared." For context to the error above, the column name on the DBMS is "Coated/Insulated". When registering the table in metadata, SAS changed the variable name to "Coated_Insulated". The error above was thrown while executing the following statement: "PROC MEANS DATA=RS.tbldimProduct FW=12 PRINTALLTYPES CHARTYPE NWAY VARDEF=DF MEAN STD MIN MAX N ; VAR product_name_id; CLASS Coated_Insulated / ORDER=UNFORMATTED ASCENDING; RUN;" Is this error specific to the SAS/Access engine 9.4 and is there a workaround? Incidentally, I have set the VALIDVARNAME to v7.
... View more