topic Export to ZIP file in SAS Programming

Export to ZIP file

Ronein — Wed, 21 Aug 2019 10:16:56 GMT

Hello
I want to export a data set with 2 million rows.
I want that the file we create will be compressed (ZIP)
I see that there was created a folder called "test.zip" but there is no file inside

filename     _dataout    zip     "/path/test.zip";

proc export data=sashelp.cars
  outfile=_dataout
  dbms=csv replace;
run;

Re: Export to ZIP file

Kurt_Bremser — Wed, 21 Aug 2019 12:25:51 GMT

Please post the log of this code.

Re: Export to ZIP file

Tom — Wed, 21 Aug 2019 13:26:55 GMT

You didn't tell SAS what name to give the file. Just which directory (zip file) you wanted to write the file.

Either add the MEMNAME= option to the FILENAME statement

filename _dataout zip "/path/test.zip" memname='cars.csv';

or leave the fileref pointing to the directory and tell PROC EXPORT what name to use within the directory.

outfile=_dataout('cars.csv')

Re: Export to ZIP file

Kurt_Bremser — Wed, 21 Aug 2019 13:38:14 GMT

When testing the OP code on SAS 9.4M6 on AIX and copying the .zip file to Windows, I got a single member called "test" (no extension) in the zip file when opened with 7zip. Opening the .zip with just the Windows Explorer it looked empty.

Bottom line: never trust a Microsoft tool to get it right.