topic Re: Filter on 12 whole months in SAS Enterprise Guide

Filter on 12 whole months

Pontus_77 — Wed, 24 Feb 2021 14:00:02 GMT

I want to create a dynamic filter, which always gives me the previous 12 months from a date variable.

For example, if I run the query today, on the 24th of February 2021, I want data between the 1st of February 2020 to the 31st of January 2021.

I have tried the INTNX function, but I can't get it to do what I want.

How do I do this?

PaigeMiller — Wed, 24 Feb 2021 14:20:06 GMT

For your future benefit, saying "it didn't work" and not showing us what you did never helps. Show us what you did.

if intnx('month',today(),-12,'b')<=variable<=intnx('month',today(),-1,'e') then ...

Pontus_77 — Wed, 24 Feb 2021 14:58:41 GMT

OK. I will save my trials in the future, so I can display them here if needed.