@RW9 unfortunately I don't have the authority not to choose Excel or long sheet name. My responsibility is just to find solutions somwhow.
I also commented out the most SAS lines. I have only 2 command lines left in my SAS, and I still get the same error from batch.
%let Server=ServerPath;
libname mylib "&Server\ExcelFolder";
I also tried to do that do-loop and scan as you wrote below.
data parameters (drop=i);
array param{4} $ ("sasfilepath","sasfile","sasoutputpath","perdate");
do i=1 to count("&sysparm.","#");
parameter=param{i};
result=%scan("&sysparm.",i,"#");
However, I got an error for the "scan" line like:
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: i
ERROR: Argument 2 to macro function %SCAN is not a number.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string,
a numeric constant, a datetime constant, a missing value, INPUT, PUT.
Then I wrote %put instead of %scan, but it showed an output like:
("",i,"#")
@Kurt_Bremser and Kurt, like you said, I used
%put "&sysparm";
and the log shows only "", so there is nothing as sysparm according to SAS.
As a result, even if I removed almost everything from the SAS code, i still get the same batch error like "This window is unavailable in line-mode."
... View more