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?
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.
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.
Thanks for the quick response. Any idea when maintenance release 5 will be out?
Look for it around the end of Sept 2017.
If you can use X command you can use 7zip to extract the file. Not optimal obviously.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.