Help using Base SAS procedures

Import xls from a zip file

Reply
Contributor
Posts: 41

Import xls from a zip file

Is it possible to import an xls file from a zip file similar to using proc import?
Respected Advisor
Posts: 4,173

Re: Import xls from a zip file

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
Contributor
Posts: 41

Re: Import xls from a zip file

This looks promising. Thanks!
Ask a Question
Discussion stats
  • 2 replies
  • 268 views
  • 0 likes
  • 2 in conversation