No such file or directory.
I am not sure what else we can say on the matter, it is telling you there is not file named that, in the location you have provided. Only oyu have access to your systems to confirm this.
In terms of data import, CSV is far and away the better medium, being portable across systems, plain text, so readable without proprietary software etc. I would hihgly recommend to use CSV, or XML/Json/Html or one of those types. I would also highly recommend to avoid using proc import - this is a guessing procedure, which will guess what it thinks your data should look like. As you are the best person to know what your data should look like (and of course you will have an import agreement stating formats/lengths etc. wont you), you should input this information into a datastep (you can take the one generated by the proc import from the log and use that as a basis). That way every import of the data will conform to the same structure (or fail) and will be clean and repeatable.
... View more