topic Re: Move xlsx files into a zip file using SAS in SAS Programming

Move xlsx files into a zip file using SAS

wbsjd — Thu, 22 Jun 2023 00:33:01 GMT

Hello Everyone,

I need to read external xlsx file into SAS, and then put the processed xlsx file into an archive zip file. Previously, we do this using X command, but this option is not available now. Is there any other ways to put xlsx file into zip file without using X command and requiring XCMD privileges?

Thanks a lot for answering my question.

Re: Move xlsx files into a zip file using SAS

Tom — Thu, 22 Jun 2023 02:16:18 GMT

Did you try using the FCOPY() function?

filename xfile "&path/class.xlsx" recfm=n;
filename zfile zip "&path/example.zip" member="class.xlsx" recfm=n;
data _null_;
  rc=fcopy('xfile','zfile');
  put rc=;
run;

Re: Move xlsx files into a zip file using SAS

wbsjd — Thu, 22 Jun 2023 16:07:56 GMT

Hi Tom,

The code works perfectly, thank you so much~~

Re: Move xlsx files into a zip file using SAS

sbxkoenk — Thu, 22 Jun 2023 16:45:35 GMT

Add files to a ZIP archive with FILENAME ZIP
By Chris Hemedinger on The SAS Dummy March 4, 2016
https://blogs.sas.com/content/sasdummy/2016/03/04/add-files-to-a-zip-archive-with-filename-zip/

BR,

Koen