topic Conditional executions in SAS Programming

Conditional executions

Ronein — Tue, 17 May 2022 19:03:33 GMT

Hello,

Let's say that the following situation :

User define 2 macro variables : business and private (using %let statement ).

I want to create conditions as following:

If macro variable business>=1 then need to do some actions (see the code below).....

If macro variable private>=1 then need to do some actions (see the code below).....

What is the way to do it please?

Is there is another way or just the way I wrote?

%let business=2;
%let private=0;

%macro RRR;
%IF &business.>=1 %then %do;
proc sql;
create table tbl1 as
select make,
       sum(invoice) as  invoice
from  sashelp.cars
where type='Sports'
group by make
;
quit;

proc sql;
create table class_M as
select *
from sashelp.class
where sex='M'
;
quit;
%End;


%IF &private.>=1 %then %do;
proc sql;
create table class_F as
select *
from sashelp.class
where sex='F' and weight>=80
;
quit;

proc sql;
create table class_age_le12 as
select *
from sashelp.class
where age<=12
;
quit;
%End;
%mend RRR;
%RRR;

Re: Conditional executions

PaigeMiller — Tue, 17 May 2022 19:01:23 GMT

The first line under %MACRO RRR;

IF &business>=1 then do;

IF statements can only be in a DATA step. This is not in a DATA step and won't work.

However, this does not have to be in a DATA step

%if &business>=1 %then %do;

and it needs to end with %END; and not END;

So you need to change this throughout your code.

Re: Conditional executions

Tom — Tue, 17 May 2022 19:11:49 GMT

If you are running a current version of SAS you can have the simple %IF/%THEN/%DO/%END blocks you have in open code without the need to define and call a macro.