topic Re: Reading gzip files in SAS Programming

Reading gzip files

deleted_user — Wed, 07 May 2008 15:19:49 GMT

My turn to ask something.

Can SAS read a gzipped file directly?
I mean with an infile - input statement pair, not through the set command.

We have a number of text files that are zipped up that we need to be able to read.
The files used to go to a Unix server where cron'd shell scripts controlled the files being uncompressed and compressed, to expose the most recent two days.
Now, the files are being stored on a Windows server, controlled by different people and processes. So, it would be best for us to use SAS to grab the file directly, and read it from the compressed/gzipped form.

Humans are able to read the files directly through WinZIP, which acts as a intermediary between the zipped file and notepad or wordpad.

I'd ask tech support, but I'd rather not wait a week for someone to get back to me.

Re: Reading gzip files

deleted_user — Wed, 07 May 2008 16:32:08 GMT

read through a filename pipe.
See the sample I found among Support.sas.com, knowledge base, Samples and Notes
http://support.sas.com/kb/25/206.html
entitled
25206 - SAMPLE: Create/Read a Unix compressed file from SAS

Re: Reading gzip files

deleted_user — Wed, 07 May 2008 19:01:31 GMT

Ahh, piping.
Never used it before.
Now we have a reason to.
Thanks Pete.

I was hoping that SAS/ACCESS for PC files would allow
[pre]
FILENAME my_gzip ZIP ".... .gz";
[/pre]
so that we could then do something like
[pre]
infile my_gzip(zipped_file);
[/pre]

But no.
Oh well.

Dreaming ...

Re: Reading gzip files

paulkaefer — Wed, 25 Apr 2018 13:56:41 GMT

I see this is an old thread, but it appeared early in my search results. So I just wanted to share a 2017 blog post, Reading and writing GZIP files with SAS by @ChrisHemedinger that answers the question.

...and I want to respond to the jab at tech support taking a week: whenever I've submitted a track with SAS Tech Support, they've replied within 24 hours (not including weekends and holidays), as stated in their automated ticket email. I've been very happy with how responsive they've been, even if there's a little back-and-forth needed.