DATA Step, Macro, Functions and more

%If %then %do

Reply
Occasional Contributor
Posts: 5

%If %then %do

 

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)

Super User
Super User
Posts: 7,401

Re: %If %then %do

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);

 

Super User
Posts: 9,681

Re: %If %then %do

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

Ask a Question
Discussion stats
  • 2 replies
  • 106 views
  • 0 likes
  • 3 in conversation