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)
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);
%if &i>5 and &i<10 %then %do;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.