topic Re: Gzip Readin in SAS Programming

Gzip Readin

Konakanchi — Fri, 25 May 2018 10:42:14 GMT

I am trying to read a pipe delimited file from gzip into SAS. I have used the below code.

x "cd C:\Program Files (x86)\GnuWin32\bin"; /* to enable to run gzip command*/

FILENAME READER PIPE "gzip -cd &PATH.\Rawdata\File.gz";

DATA &LIB..&DSN. (COMPRESS=YES) ;
INFILE READER DELIMITER = '|' TRUNCOVER DSD LRECL=32767 FIRSTOBS=1 OBS=10;

There is a command prompt window showing up and unless i close it, the program isn't running further. Is there any way to close the cmd windows closes automatically or is there any way to stop this window coming up?

Re: Gzip Readin

RW9 — Fri, 25 May 2018 10:53:34 GMT

options noxwait:

http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#n0xwt90ik8vxdrn13708w6n3nm4o.htm

Do please avoid coding all in shouting case, it makes code hard to read, and you can use the code window - its the {i} above post are - so that essential code formatting is retained.

Re: Gzip Readin

Konakanchi — Fri, 25 May 2018 11:19:31 GMT

I have used Options Noxwait; in the beginning of the program and don't see any changes.

Re: Gzip Readin

RW9 — Fri, 25 May 2018 12:15:58 GMT

I would unzip the file before assigning it to a read. So something like:

/* Send command to expand files */
x "C:\Program Files (x86)\GnuWin32\bin\gzip.exe -cd -f "c:\somewhere\Rawdata\File.gz";

/* Now read in the extracted files */
data want;
  infile "c:\somewhere\Rawdata\thefile.txt" dlm="|" truncover dsd lrecl=32767;
  input ...;
run;

Your code seems to be reading the command line rather than actually expanding the data then reading a file, which may also be the root of your problem. I.e. you don't push piped command line strings directly into a read, infile expects a file, not an action.

Re: Gzip Readin

Kurt_Bremser — Fri, 25 May 2018 13:23:32 GMT

After you close the window, do you get the contents in your data step?