Reading tab delimited file

[DPraba79]

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

[art297 · Accepted solution]

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

  ignoredoseof

[DPraba79]

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