topic %include - if condition 1 to execute a sas code 1, else to execute a sas code 2 -- with errors in SAS Programming

%include - if condition 1 to execute a sas code 1, else to execute a sas code 2 -- with errors

GraceStehlin98 — Tue, 02 Jun 2020 17:37:15 GMT

if any value contains "no" then execute program_1.sas, else execute program_2.sas. the errors " error 180-322:statement is not valid or its is used out or proper order" and error " else statement is not valid or it is used out of proper order. the sample is attached.

Can someone help?

data _null_;

length comp_lst $20;

do until (eof);

set a (keep=verified ) end=eof;

comp_lst=catx(" ",comp_lst,verified);

end;

drop verified;

if index(comp_lst,"no")>0 then %include "\program_1.sas";

else if index(comp_lst, "no")<1 then %include "\program_2.sas";

run;

Thanks !

Re: %include - if condition 1 to execute a sas code 1, else to execute a sas code 2 -- with errors

VENKATAMAHESH — Tue, 02 Jun 2020 17:40:08 GMT

use call execute functionality when a certain condition is satisfied. it would work.

Re: %include - if condition 1 to execute a sas code 1, else to execute a sas code 2 -- with errors

GraceStehlin98 — Tue, 02 Jun 2020 17:50:58 GMT

if you have better idea to check a value "no" from the variable "verified", that will be great too!. I don't know why "%include" doesn't work .

Thanks !

Re: %include - if condition 1 to execute a sas code 1, else to execute a sas code 2 -- with errors

Reeza — Tue, 02 Jun 2020 17:52:51 GMT

I don't think %INCLUDE can be run conditionally. You need to use CALL EXECUTE() instead to call that program.

Something like this maybe:

if index(comp_lst,"no")>0 then call execute('%include "\program_1.sas"; ');

else if index(comp_lst, "no")<1 then call execute('%include "\program_2.sas" ;' );

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lestmtsglobal&docsetTarget=p1s3uhhqtscz2sn1otiatbovfn1t.htm&locale=en

Because %INCLUDE is a global statement and global statements are not executable, the %INCLUDE statement cannot be used in conditional logic.

Re: %include - if condition 1 to execute a sas code 1, else to execute a sas code 2 -- with errors

GraceStehlin98 — Tue, 02 Jun 2020 18:01:08 GMT

it works perfectly!

Thanks a lot!

Re: %include - if condition 1 to execute a sas code 1, else to execute a sas code 2 -- with errors

Shmuel — Tue, 02 Jun 2020 18:20:30 GMT

Alternative code using macro program:

data _NULL_;
   set a (keep=verified ) end=eof;
   comp_lst=catx(" ",comp_lst,verified);
   if eof then do;
      result = index(comp_lst,"no");
	  call symput('result', strip(result));
   end;
run;
%run_program(rc);
   %if &rc > 0 %then %include "\program_1.sas";
   %if &rc < 1 %then %include "\program_2.sas";
%mend run_program;
%run_program(&result);