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
Try adding one more option onto your infile statement, namely:
ignoredoseof
Try adding one more option onto your infile statement, namely:
ignoredoseof
Wow Arthur.. That option is working. I appreciate your help.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.