topic Macro Variable to Conditionally Make a Dataset in SAS Programming

Macro Variable to Conditionally Make a Dataset

BCNAV — Wed, 03 Apr 2019 14:44:05 GMT

I have a macro variable declared earlier as (it will be manually changed as needed):

%let monthly_update = 1;

Later on I would like to conditionally make a dataset as (not sure of the code but you will get the picture):

if &monthly_update = 1 then

data final;

set predata;

monthlyupdate = 1;

run;

else

data final;

set predata;

run;

end

thanks in advance!!

-Bill

Re: Macro Variable to Conditionally Make a Dataset

PaigeMiller — Wed, 03 Apr 2019 14:50:24 GMT

%macro dothis;
%if &monthly_update = 1 %then %do;
     data final;
          set predata;
          monthlyupdate = 1;
    run;
%end;
%else %do;
     data final;
           set predata;
    run;
%end;
%mend;


%let monthly_update=1;
%dothis

or even simpler:

%macro dothis;

     data final;
          set predata;
          %if &monthly_update=1 %then monthlyupdate = 1%str(;);
    run;

%mend;


%let monthly_update=1;
%dothis

If you have SAS 9.4 TS1M5 or later, you don't even need a macro, the %if %then %else in the first example can be used in open code.

Re: Macro Variable to Conditionally Make a Dataset

BCNAV — Wed, 03 Apr 2019 18:08:52 GMT

thanks!