Dataset Where Command with a Resitrction

BCNAV — Thu, 10 Sep 2020 20:48:12 GMT

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?

Re: Dataset Where Command with a Resitrction

Kurt_Bremser — Thu, 10 Sep 2020 21:01:53 GMT

Try this:

where (month(fltdate) ne &month_now or &month_now = 9) and status_code="I";

topic Re: Dataset Where Command with a Resitrction in SAS Programming

Dataset Where Command with a Resitrction

Re: Dataset Where Command with a Resitrction