topic Re: Reading Gzip Files in New SAS User

Reading Gzip Files

Jesusismygrace — Wed, 08 Feb 2023 18:22:15 GMT

Hi,

I am so sorry, I know that this has been discussed, but I just can't figure it out. I am using SAS EG 7 and I would like to read gzip files in my program, but I can get the example that I found to work.

My coding:

libname MY21det '/nfs/sasarch/MI/hedis/hedis_vendor/production/inovalon/MY2021/inovalon/data/';

%let Measure=COU;

filename MY21D GZIP '/nfs/sasarch/MI/hedis/hedis_vendor/production/inovalon/MY2021/inovalon/data/download/May_Prod_Run2/&Measure..sas7bdat.gz'

member="&Measure..sas7bdat";

data _null_;

infile MY21D;

input a $80.;

run;

Re: Reading Gzip Files

Reeza — Wed, 08 Feb 2023 18:41:56 GMT

What version of SAS do you have?

You can check with the following:

proc product_status;run;

Check the log for the results, should be something like:

SAS 9.4M5

GZIP is supported 9.4M5+

Re: Reading Gzip Files

Jesusismygrace — Wed, 08 Feb 2023 18:46:58 GMT

Thank you for getting back to me. Also, I am using EG 7.15 (7.100.5.5850) (32-bit)

For Base SAS Software ...
Custom version information: 9.4_M7
Image version information: 9.04.01M7P080520
For SAS/STAT ...
Custom version information: 15.2
For SAS/GRAPH ...
Custom version information: 9.4_M7
For SAS/ETS ...
Custom version information: 15.2
For SAS/ACCESS Interface to Netezza ...
Custom version information: 9.44
For SAS Integration Technologies ...
Custom version information: 9.4_M7
For SAS/Secure 168-bit ...
Custom version information: 9.41_M4
For High Performance Suite ...
Custom version information: 2.2_M8
For SAS/ACCESS Interface to Oracle ...
Custom version information: 9.44
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M7
For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.4_M7
For SAS/ACCESS Interface to Microsoft SQL Server ...
Custom version information: 9.45

Re: Reading Gzip Files

Kurt_Bremser — Wed, 08 Feb 2023 18:48:47 GMT

According to the documentation, the syntax should be

filename MY21D
  zip
  '/nfs/sasarch/MI/hedis/hedis_vendor/production/inovalon/MY2021/inovalon/data/download/May_Prod_Run2/&Measure..sas7bdat.gz'
  gzip
  member="&Measure..sas7bdat"
;

GZIP is a sub-option of FILENAME ZIP.

Re: Reading Gzip Files

Reeza — Wed, 08 Feb 2023 18:56:23 GMT

https://blogs.sas.com/content/sasdummy/2017/10/10/reading-writing-gzip-files-sas/

Re: Reading Gzip Files

Jesusismygrace — Wed, 08 Feb 2023 19:52:58 GMT

Thank you! It worked perfectly!

Re: Reading Gzip Files

Jesusismygrace — Wed, 08 Feb 2023 19:58:33 GMT

Thank you!