topic Re: How to infile .gz files in SAS Data Management

How to infile .gz files

Aman4SAS — Wed, 28 Jun 2017 15:23:44 GMT

Hi every one .... please help me to use .gz file attached along with this.

i need to use it by infile and i am working on windows

please help me

my code is

filename hhh pipe "zcat filepath\test.txt.gz";
  
  data test;
    infile hhh firstobs = 2 expandtabs truncover;
    input @1    dd1 yymmdd10.
          @17   dd2 yymmdd10.
          @33   act $1.
          @41   udu 1.
          @49   LC $5.
          @57   cs $3.
          @65   sc $3.
          @73   div 1.
          @81   vol;
    format dd1 dateto date9.;
    area=trim(left(lc));
    if lc=' ' then error 'NO AREA LISTED';
    
  run;

Log window:

Stderr output:
'zcat' is not recognized as an internal or external command,
operable program or batch file.
NOTE: 0 records were read from the infile HHH.
NOTE: The data set WORK.TEST has 0 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.04 seconds

Re: How to infile .gz files

MohammadFayaz — Mon, 25 Nov 2013 11:53:52 GMT

Hello,

In filename, you can use PIPE to handle it.

Re: How to infile .gz files

Patrick — Mon, 25 Nov 2013 11:59:01 GMT

Is gzip installed on your Windows machine? Or any other zipping tool like 7zip?

Whatever you're using I doubt that you just can call the tool using "zcat". In order for Windows to find it you must provide a path (absolute or relative) - or 'cd' to the directory where the executable "lives".

May be below links will help:

https://communities.sas.com/message/114760#114760

https://communities.sas.com/message/169460#169460