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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.