12-20-2012 04:46 PM
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.
INFILE file1 dlm='09'x dsd termstr=CRLF;
INPUT COL1 : $CHAR20.
COL2 : $CHAR20.
COL3 : $CHAR20.
COL4 : $CHAR20.
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.
Need further help from the community? Please ask a new question.