topic How to identify prev month's year in SAS Programming

How to identify prev month's year

jayakumarmm — Fri, 02 Sep 2016 11:22:03 GMT

I want a sas logic to identify previous month's year. For example, 1. if current month year JAN 2016 then I need to retrieve 2015 2. if current month year FEB 2016 then I need to retrieve 2016

Re: How to identify prev month's year

Reeza — Fri, 02 Sep 2016 13:22:44 GMT

Is your variable a SAS date, ie numeric with a date format?

If so this should work, I split it up for clarity but you can nest your functions.

Prev_Month = INTNX('month', date_var, -1, 'B');
Prev_Year = year(Prev_Month);

Re: How to identify prev month's year

set_all__ — Fri, 02 Sep 2016 13:45:33 GMT

Using some of Reeza's code but adding 'Today' function:

Prev_months_year = year(INTNX('month', today(), -1, 'B'));