10-02-2012 04:09 PM
I am trying to pull a file from unix. It was emailed to me in a .dat format. I saved it to a drive, then ftp'd it to unix and am not using the attached code. I'll also attach the log, you can see at the end of the log that it is reading a very large file but my results only show 1 field. I'm not sure why it sees the entire file but only pulls in one row. There are 140 variables that seem to be loading correctly for that one record.
Any help will be appreciated.
10-02-2012 04:29 PM
It looks like the data is using hex code 0A to mark the end of each line of data, but your operating system treats 0A as text. I suspect this has to be fixed earlier in the process, not after the fact. SAS could correct a few lines of data in this format, but your final line length will be far longer than anything SAS could handle at this point.
10-02-2012 04:34 PM
I suspected it had something to do with the length, or end of the row, the length will be whatever I set the lrecl as, I understand the problem but not the solution, does this have to be fixed in the file itself? What can I do to fix the issue, if anything?
Need further help from the community? Please ask a new question.