macro with if statement

[Pato485]

How can i use macro with if, else, end statement, if i want to just start sql if the condition is true.

I wanna just use if statement, so if today()= date column from my table, and if this is true, then run this sql:

create table work.filtered_data AS
select *
from xxx

[Kurt_Bremser]

So you have a date variable in a dataset. Will this variable contain only a single distinct value in all observations, or different dates?

[Pato485]

just one, it is just one exact date in every month (but not same every month) when i need to start macro. But it is just one value in dataset everytime.

[PaigeMiller · Accepted solution]

data _null_;
    set have;
    if date=today() then call symputx('start',1);
    else call symputx('start',0);
run;
%if &start=1 %then %do;
    proc sql;
         ...
    quit;
%end;

Works in SAS 9.4M5 and later.

[Pato485]

Thanks for solution.