You can use libname engine to define a excel book as a SAS data library. Then you can treat them as SAS data sets.

Here is an example,


libname S EXCEL 'c:\temp\book1.xlsx';

proc sql noprint;
  select catt(trim(libname),'.',quote(trim(memname)),'n') into: namelist separated by ' '
  from dictionary.tables
  where libname in ('S');
  quit;

%put &namelist;

proc contents data=s._all_;
run;

libname s clear;

学习了

嗯，非常有效，感谢了。

再问下，如何知道一个文件夹下面所有excel文件的名称，即搜索出某个文件夹下面的所有excel文件？

哈哈，解决了，https://bbs.pinggu.org/thread-1111573-1-1.html

非常感谢pinggu这个的这个平台，真心解决我好多问题。。。