Hi there, getting the below error: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 0 < &countjobs. ERROR: Skipping to next %END statement. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 0 >= &countjobs. ERROR: Skipping to next %END statement.   The file "C:/Jobs.xlsx" contains a value '3' which is identified as numeric. I think the error has to do with the &countjobs variable. When I use a normal digit for example a 3 then it works.    I am comparing the value in the file verse the count of files in the directory in the if conditions. %include "C:/list.sas"; %let path_in= C:/FileCheck; %lfiles("C:/File",txt) %let filecount = 0; %if %sysfunc(exist(tables)) %then %do; proc sql; create table filecount as select count(name) into: filecount from tables; quit; %end; proc import out=Jobcount replace datafile = "C:/Jobs.xlsx" dbms = xlsx; getnames=yes; run; proc sql; create table countjobs as select Countjobs into: countjobs from Jobcount; quit; %if &filecount. < &countjobs. %then %do; put("less than"); %end; %if &filecount. >= &countjobs. %then %do; put("ge"); %end; ... View more

Hi there, I am trying to exit my code when the count is greater than 3 but i get the error:ERROR 180-322: Statement is not valid or it is used out of proper order.   %include "C:/list.sas"; /*file paths*/ %let path_in= C:/FileCheck; /*List of files*/ %list_files("C:/File",txt) %let filecount = 0; %if %sysfunc(exist(tables)) %then %do; proc sql; create table filecount as select count(name) into: filecount from tables; quit; %end; %if &filecount. >= 3 %then %do; %goto exitc; %end; %exitc:   ... View more