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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.