I don't know how to get rid of this ugly (it is the internal name) name.
But here an example how to get a SAS table from an excel file.
* --- use here your method to get a libname for the excel file ;
LIBNAME test CLEAR;
"FMAINVILLE" <email@example.com> schrieb im Newsbeitrag
> 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
> Proc sql;
> select * from mylib.sheet1$ ;
> SAS will complain about the $.
> Any way of fixing this ?
> Thanks in advance,
> F. Mainville
> Statistics Canada