Move xlsx files into a zip file using SAS

[wbsjd]

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.

[Tom · Accepted solution]

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;

[wbsjd]

Hi Tom,

The code works perfectly, thank you so much~~

[sbxkoenk]

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