Reading tab delimited file

DPraba79 — Thu, 20 Dec 2012 21:46:34 GMT

Hi All,

I have a tab delimited data file, When i try to read that file, its not reading until the end of the file. I found there is one junk value in my file. The program is reading up to that record and it says end of file reached. I guess, SAS thinks that junk character as end of file character. Do you guys know how to over come this situation.

DATA DATA1;

INFILE file1 dlm='09'x dsd termstr=CRLF;

INPUT COL1 : $CHAR20.

COL2 : $CHAR20.

COL3 : $CHAR20.

COL4 : $CHAR20.

;

RUN;

at 1071th record has that junk value in COL3 posistion. But this program read until 1071th obs COL1 & COL2 correctly but COL3 & COL4 say blanks. Kindly note, my file has almost 1Million records.

Thanks,

Prabakaran

Re: Reading tab delimited file

art297 — Thu, 20 Dec 2012 22:50:26 GMT

Try adding one more option onto your infile statement, namely:

ignoredoseof

Re: Reading tab delimited file

DPraba79 — Thu, 20 Dec 2012 23:13:48 GMT

Wow Arthur.. That option is working. I appreciate your help.

topic Re: Reading tab delimited file in SAS Programming

Reading tab delimited file

Re: Reading tab delimited file

Re: Reading tab delimited file