I have a sas file that is in file.tsv.gz, any ideas how to open this file in SAS?
Thank you,
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;
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"
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;
If you use "tsv.gz" as search term right here then you'll find a few discussions which might help you to proceed.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.