https://communities.sas.com/t5/SAS-Procedures/Import-xls-from-a-zip-file/m-p/73682#M21365 Is it possible to import an xls file from a zip file similar to using proc import? Tue, 29 Sep 2009 23:00:04 GMT WAL83 2009-09-29T23:00:04Z https://communities.sas.com/t5/SAS-Procedures/Import-xls-from-a-zip-file/m-p/73682#M21365 Is it possible to import an xls file from a zip file similar to using proc import? Tue, 29 Sep 2009 23:00:04 GMT https://communities.sas.com/t5/SAS-Procedures/Import-xls-from-a-zip-file/m-p/73682#M21365 WAL83 2009-09-29T23:00:04Z https://communities.sas.com/t5/SAS-Procedures/Import-xls-from-a-zip-file/m-p/73683#M21366 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).<BR /> <BR /> Here a helpful paper on how to unzip within SAS:<BR /> <A href="http://www.lexjansen.com/phuse/2006/cc/cc01.pdf" target="_blank">http://www.lexjansen.com/phuse/2006/cc/cc01.pdf</A> <BR /> <BR /> HTH<BR /> Patrick Tue, 29 Sep 2009 23:13:36 GMT https://communities.sas.com/t5/SAS-Procedures/Import-xls-from-a-zip-file/m-p/73683#M21366 Patrick 2009-09-29T23:13:36Z https://communities.sas.com/t5/SAS-Procedures/Import-xls-from-a-zip-file/m-p/73684#M21367 This looks promising. Thanks! Wed, 30 Sep 2009 18:18:35 GMT https://communities.sas.com/t5/SAS-Procedures/Import-xls-from-a-zip-file/m-p/73684#M21367 WAL83 2009-09-30T18:18:35Z