Hi guys, Not sure if this is a relatively simple one but it is something I haven't come across before. I have done some searching online and haven't come up with anything yet. I am trying to read in some Oracle system performance data using ODBC and submitting the following code: LIBNAME ORACLE ODBC DSN=ORC_DAT uid=user pwd=pwd SCHEMA=schema; %let setorc = 'ORACLE.MGMT$METRIC_CURRENT'; data ORC_DATA; set &setorc; run; I have managed to get the code working on a different table with no $ symbol. The database guy has also tried to rename the table or create a view to no avail. Finally I have also tried a lot of combinations of quotes as well. The error I am getting for the code above is as follows: ERROR: The physical file name "ORACLE.MGMT$METRIC_CURRENT" is too long I guess my question is how can I read in the table and get SAS to ignore the $ symbol, as I assume this is the error. Many Thanks
... View more