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:
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.
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.