DATA Step, Macro, Functions and more

Reading tab delimited file

Accepted Solution Solved
Reply
Contributor
Posts: 34
Accepted Solution

Reading tab delimited file

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


Accepted Solutions
Solution
‎12-20-2012 05:50 PM
PROC Star
Posts: 7,363

Re: Reading tab delimited file

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

  ignoredoseof

View solution in original post


All Replies
Solution
‎12-20-2012 05:50 PM
PROC Star
Posts: 7,363

Re: Reading tab delimited file

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

  ignoredoseof

Contributor
Posts: 34

Re: Reading tab delimited file

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 181 views
  • 0 likes
  • 2 in conversation