topic Re: Read UNIX gz archive in PC SAS in SAS Programming

Read UNIX gz archive in PC SAS

markready — Tue, 01 Aug 2017 18:56:29 GMT

I am using 64-bit PC SAS 9.4 on Windows 10. I am trying to read a single member from a .gz archive that was created on a UNIX machine. The following SAS code

filename zipped ZIP 'E:/WISC_TAS_20060103.csv.gz';
data testin;
infile zipped(WISC_TAS_20060103.csv)
firstobs=2 dsd;
input RIC $ ;
run;

produces the error: ERROR: The file "E:\WISC_TAS_20060103.csv.gz" exists and is not a zip file. The output file
must be a zip file.

I used 7zip to extract the .csv file and then used 7zip to create a new archive. The following code reads that file just fine:

filename zipped ZIP 'E:/WISC_TAS_20060103.zip';
data testin;
infile zipped(WISC_TAS_20060103.csv)
firstobs=2 dsd;
input RIC $ ;

run;

Is there a way to get the ZIP utility to recognize the unix zip file?

Re: Read UNIX gz archive in PC SAS

ChrisHemedinger — Tue, 01 Aug 2017 19:06:51 GMT

FILENAME ZIP doesn't currently support .gz files, but that's coming. Support for reading/creating .gz files (gzip compatible) will be part of SAS 9.4 Maintenance 5.

Re: Read UNIX gz archive in PC SAS

Reeza — Tue, 01 Aug 2017 19:09:56 GMT

If you can use X command you can use 7zip to extract the file. Not optimal obviously.

Re: Read UNIX gz archive in PC SAS

markready — Tue, 01 Aug 2017 19:17:12 GMT

Thanks for the quick response. Any idea when maintenance release 5 will be out?

Re: Read UNIX gz archive in PC SAS

ChrisHemedinger — Tue, 01 Aug 2017 19:23:00 GMT

Look for it around the end of Sept 2017.