Hello community, I have a program that worked very well in SAS Unniversity edition, but now in SAS onDemand for academics it no longer works. I send some parameters to the macro and when the macro variables are concatenated to form the path of the file in some mysterious way a "//" is added to the path so the file cannot be found. I show you the code and the error of the log. Source %macro import_emitidas_xls(rfc,anio,mes);
FILENAME REFFILE "/home/u58941115/cont/pmfecu/entradas/&rfc._Emitidas_&anio._&mes..xlsx";
PROC IMPORT DATAFILE=REFFILE
DBMS=XLSX
OUT=WORK.&rfc._Emitidas_&anio._&mes ;
GETNAMES=YES;
SHEET="XML";
RUN;
%mend import_emitidas_xls;
%let rfc= XBG1311088L6;
%let anio=2021;
%let mes= 01;
%import_emitidas_xls(&rfc,&anio,&mes); Log ERROR: Physical file does not exist, /home/u58941115/cont/pmfecu/entradas//XBG1311088L6_Emitidas_2021_01.
NOTE: The SAS System stopped processing this step because of errors.
... View more