Greetings to all,
In defining an ODBC Libref to Excel, the dataset name get represented as
I have spent the day toying with the various quoting functions with out
Converting to Ms Access solved the issue, but is there a way to handle the $
For example, in the following code
select * from mylib.sheet1$ ;
SAS will complain about the $.
Any way of fixing this ?
Thanks in advance,