I am trying to import an excel file which resides in a Linux sever. I am using the following code (running SAS 9.4) options symbolgen; %let Datafile=%str(pippo3.xlsx); %let raw=/sasdata/Projects/share/AGSourcingExcelTool/Superuser; %let separator = %str(/); %let aa= %sysfunc(catx(&separator,%nrstr(%superq(raw)),%nrstr(%superq(Datafile)))); filename foo "&aa"; PROC IMPORT DATAFILE=foo OUT=Desti replace dbms=xlsx; *SHEET=Destination; /* (Note use “Sheet 1$”n if spaces in the name) */ RANGE="Destination$A5:Z25000"; GETNAMES=Yes ;/* (Note use No and SAS will assign Var0, Var1 etc) */ RUN; I get the following error ERROR: XLSX file does not exist -> /sasdata/Projects/share/AGSourcingExcelTool/Superuser//pippo3.xlsx As you can see (highlighted in larger red characters) I have an extra "/" coming out in the path which produces the error. Why is the extra "/" occurring? (Note if I do %put &aa; I do not see any extra "/"). Thank you very much.
... View more