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