reading file.tsv.gz in SAS

[lillymaginta]

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

Thank you,

[Tom]

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;

[lillymaginta]

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"

[Reeza]

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.

[Tom]

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;

[Patrick]

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