I have the following:
data egtask.ovrfy_ind_curr_t1;
set ibs.overfy&cfyear;
where month(fltdate)<>&month_now and status_code="I";
MarketSubmarket = Market * 10 + SubMarket;
Month = month(fltdate);
run;
Now this works perfectly, except that I do not want the restriction:
where month(fltdate)<>&month_now
to be run in the month of September. So if the month the dataset is run is 9, then the where statement should be:
where status_code="I";
and all other months it should be:
where month(fltdate)<>&month_now and status_code="I";
I do have a global macro variable called month_now, but I am not sure it can be used. Is something like this possible..a conditional where?