Is your SAS server OS Windows or Unix/Linux?  Right now you're using a Windows DIR command with a Unix path.... Your log shows that macro variable &fn1 doesn't exist and because you're using it as part of a path the path won't be valid even after you fix the rest of the path. Not sure why you're creating all these macro variables &fn<n> given that you later on only try to use &fn1 ...which obviously doesn't get created. If you really need all these macro variables then replace this incomplete list of IF statements with code like below. ....but first you need to get your logic right.   ... View more

I realize I ran the code today and it worked, so this 3 year old post provided a helpful solution... And now I'm wasting time replying to a snarky comment:/ Are you trying to be some kind of SAS-troll?   ... View more

If the result is as they desire do they need to know what you may have done in the middle?   They don't. So you suggest making an xls file and then convert it to xlsx? How do I do that? ... View more

Changed it to libname xlsx excel "&out_dir\test.xlsx" which still gives the same error.   Making it libname xlsx excel test.xlsx Gives me ERROR: You need to specify a data source or prompt for it. ERROR: Error in the LIBNAME statement. I want to use the first one, because it needs to be written to that folder. ... View more

The fact that the previous workaround worked was probably coincidence, because it doesn't anymore at the moment 🙂   I was completely wrong. It has nothing to do with the amount of lines or the last columns. I have received new files (with a low number of lines) which have the same problem. The solution is very simple: remove all formatting. That's it.   For some reason SAS cannot handle the formatting that is being used in the excel sheets... ... View more