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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.