topic Re: %If %then %do in SAS Programming

%If %then %do

WilliamB — Thu, 18 May 2017 13:05:33 GMT

Hi,
In a more complex program, I need to set 2 conditions in my "if". I need to keep a macro. But the "&" and "and" do not work.

Do you have a solution thank you.

Here is a simple program:
data toto;
input u;
cards;
5
5
9
8
17
14
15
;
run;

%macro p (i);
%if i>5 and i<10 %then %do;
data titi;
set toto;
run;
proc print; run;
%end;
%mend;
%p (9)

Re: %If %then %do

RW9 — Thu, 18 May 2017 13:09:53 GMT

You haven't mentioned what is not running, I will take a punt and state it is because you are using a variable i, rather than the macro variable &i. So your code should look like this (note also I changed a few other bits for readability:

data toto;
  input u;
cards;
5
5
9
8
17
14
15
;
run;

%macro p (i);
  %if &i. > 5 and &i. < 10 %then %do;
    data titi;
      set toto;
    run;
    proc print; 
    run;
  %end;
%mend;
%p (9);

Re: %If %then %do

Ksharp — Thu, 18 May 2017 13:10:29 GMT

%if &i>5 and &i<10 %then %do;