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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.