topic Re: macro with if statement in SAS Enterprise Guide

macro with if statement

Pato485 — Thu, 10 Mar 2022 09:16:06 GMT

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

Re: macro with if statement

Kurt_Bremser — Thu, 10 Mar 2022 09:36:17 GMT

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

Re: macro with if statement

Pato485 — Thu, 10 Mar 2022 09:57:42 GMT

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.

Re: macro with if statement

PaigeMiller — Thu, 10 Mar 2022 11:09:45 GMT

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.

Re: macro with if statement

Pato485 — Thu, 10 Mar 2022 13:05:33 GMT

Thanks for solution.