Hi Chris,

We receive gziped tab delimited txt file from Widows server over SFTP into Linux server where SAS is installed. We use SAS EG client on our pc which connects to the Linux server. I am able to unzip the file and use INFILE to read it into a SAS dataset. However when I read it directly from gziped file, it gets all row but rows are coming blank. Below is the code.

If I do INFILE from target it reads the rows with data, but if I do INFILE from fromzip it reads all rows but values coming up blank.

Any help would be much appreciated!

filename target "/mydata/inbox/unzipped/mytext.txt";
filename fromzip ZIP "/mydata/inbox/ mytext.txt.gz" GZIP termstr=crlf ;

infile fromzip
LRECL=32767 DLM='09'x MISSOVER DSD TERMSTR=CRLF;