topic Choosing Months, but Exclude Non-Full Months in SAS Programming

Choosing Months, but Exclude Non-Full Months

BCNAV — Thu, 12 Sep 2019 15:34:24 GMT

I have the following filter:

WHERE t1.flightdate >= intnx('Month',today(),-&months_back)

so if &months_back is 3, I will get data from all of June, July, and August of this year.....but it will also include September. I do not want September...I only want the last number of FULL months as identified with the macro variable &months_back. What filter can I add to get rid of the partial month dates?

Re: Choosing Months, but Exclude Non-Full Months

Reeza — Thu, 12 Sep 2019 15:38:38 GMT

WHERE t1.flightdate >= intnx('Month',today(),-&months_back) and t1.flightdate < intnx('month', today(), 0, 'b');

Same idea, use INTNX() to get current months first day (interval = 0, aligment = b) and use BETWEEN or < for the date.

@BCNAV wrote:

I have the following filter:

WHERE t1.flightdate >= intnx('Month',today(),-&months_back)

so if &months_back is 3, I will get data from all of June, July, and August of this year.....but it will also include September. I do not want September...I only want the last number of FULL months as identified with the macro variable &months_back. What filter can I add to get rid of the partial month dates?

Re: Choosing Months, but Exclude Non-Full Months

ballardw — Thu, 12 Sep 2019 15:38:46 GMT

SAS supports structures like

Where value1 < value2 < value3

So add the other constraint

WHERE somevalue > t1.flightdate >= intnx('Month',today(),-&months_back)

perhaps

where intx('month',today(),0,'B') > t1.flightdate >= intnx('Month',today(),-&months_back)

if you only want dates prior to the beginning of the current month.

Re: Choosing Months, but Exclude Non-Full Months

novinosrin — Thu, 12 Sep 2019 16:10:48 GMT


where intnx('Month',today(),-3)<=date<=intnx('Month',today(),-1,'e');