topic Re: Year of privious month in New SAS User

Year of privious month

kazimir900 — Wed, 18 Sep 2019 19:39:47 GMT

Hey SAS Community,

i want to extract just the year of the privious month from the current date in SAS Enterprise Guide. But i can't figure out how to...

Thanks for your help!

Lars

PaigeMiller — Wed, 18 Sep 2019 19:41:16 GMT

In a data step

prev_year=year(intnx('month',today(),-1));

PeterClemmensen — Wed, 18 Sep 2019 19:41:49 GMT

@kazimir900 hi and welcome to the SAS Community!

You can do something like this

data _null_;
   yearofprevmonth=year(intnx('month', today(), -1, 'b'));
   put yearofprevmonth=;
run;

novinosrin — Wed, 18 Sep 2019 19:42:01 GMT

%let current_date=%sysfunc(today());

%let prev_month=%sysfunc(intnx(mon,&current_date,-1),monyy7.);

%put &=prev_month;

kazimir900 — Wed, 18 Sep 2019 19:49:20 GMT

Thanks for your quick help!

I've tried something like that before but some how my code didn't work...but yours does!