Trying to exit code

Citrine10 — Mon, 31 Jan 2022 08:57:00 GMT

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:

Re: Trying to exit code

Patrick — Mon, 31 Jan 2022 09:28:48 GMT

The %goto command is only valid within a SAS macro and not as open code.

Just "wrap" a macro around your code and things should start to work.

topic Trying to exit code in SAS Procedures

Trying to exit code

Re: Trying to exit code