Import xls from a zip file

[WAL83]

Is it possible to import an xls file from a zip file similar to using proc import?

[Patrick]

I would try to first unzip the file using a filename pipe and then do whatever you would do normally with an excel file (whether this is proc import or a libname with the xls engine).

Here a helpful paper on how to unzip within SAS:
http://www.lexjansen.com/phuse/2006/cc/cc01.pdf

HTH
Patrick

[WAL83]

This looks promising. Thanks!