|
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 ;
%getODBCLibref (DBMS=MSEXCEL,libref=test,DBQ=c:\temp\test.xls);
OPTIONS VALIDVARNAME=any;
DATA sheet1;
SET test.'sheet1$'n;
RUN;
LIBNAME test CLEAR;
OPTIONS VALIDVARNAME=V7;
"FMAINVILLE" <fmr@magma.ca.nospam> schrieb im Newsbeitrag
news:zTIt8.25735$Hl2.877702@wagner.videotron.net...
> 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
>
|
