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
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.
So you have a date variable in a dataset. Will this variable contain only a single distinct value in all observations, or different dates?
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.