As a first step, did you confirm that if you just run the PROC import step (no macro code) it works?
proc import datafile="/SHARED/MCL_Team/MCL_1117/MCL-AAAA.xlsx" dbms=xlsx out=AAAA replace;
range="Sheet1$A1:H518";
sheet='Sheet1';
getnames=yes;
run;
Looks like you're on linux, so case sensitivity of file names/path names is always a potential problem.
Would also be interesting to see if you find an extra / in the log just submitting that code. If so, it might just be a PROC IMPORT oddity. PROC IMPORT sometimes shows odd statements in the log, like that:
MPRINT(FILEINPUT): RXLX;
you see in the log before the RANGE statement. So it's possible it's adding the slash.
In general, my understanding is linux will ignore a // in the middle of a path, and treat it the same as /. So the extra slash in the log could be a "red herring".
... View more