topic Re: reading file.tsv.gz in SAS in SAS Programming

reading file.tsv.gz in SAS

lillymaginta — Tue, 23 Jul 2019 15:20:24 GMT

I have a sas file that is in file.tsv.gz, any ideas how to open this file in SAS?

Thank you,

Re: reading file.tsv.gz in SAS

Tom — Tue, 23 Jul 2019 15:22:23 GMT

What is in the file?

Why not run a little SAS program to look at the beginning of the file.

data _null_;
  infile 'file.tsv.gz' zip gzip obs=10;
  input;
  list;
run;

Re: reading file.tsv.gz in SAS

Patrick — Tue, 23 Jul 2019 15:24:36 GMT

If you use "tsv.gz" as search term right here then you'll find a few discussions which might help you to proceed.

Re: reading file.tsv.gz in SAS

lillymaginta — Tue, 23 Jul 2019 15:28:02 GMT

Thank you for the prompt response. The file contain a very large data. I don't think the file is zipped but I might be wrong. Running the statement you provided resulted in the following error " ERROR 23-2: Invalid option name GZIP"

Re: reading file.tsv.gz in SAS

Reeza — Tue, 23 Jul 2019 15:36:50 GMT

What version of SAS do you have, the exact version. GZ does mean zipped, via GZIP, later versions of SAS support this format and you can read the text file directly from the zipped file. But I think it's literally the latest version, SAS 9.4M6. If you have an older version you need to uncompress the file to read it first.

Re: reading file.tsv.gz in SAS

Tom — Tue, 23 Jul 2019 15:58:30 GMT

You will need to use a more recent version of SAS to have the GZIP option.

You will need to unzip the file outside of SAS then. Use gunzip (or gzip -d option). Or some other tool that knows how to expand GZIP format.

If you can run operating system commands from within SAS you can do it on the fly if you want with the PIPE filename engine.

Is it easy on unix.

infile 'gzip -cd file.tsv.gz' pipe obs=10;