topic Re: getting last month from year month date in SAS Programming

getting last month from year month date

kajal_30 — Fri, 03 Jun 2022 03:54:48 GMT

Hi All,

I have a date in the form of year month and I want the last month date from the code . for eg I have 202210 and I want the code to provide me 202209.

tried code below but didn't work.

%let yearmonth = 202210;

data one;
	call symputx('P_Month', month(intnx('month',&yearmonth,-1)));
run;

%put &P_Month;

Re: getting last month from year month date

PeterClemmensen — Fri, 03 Jun 2022 04:10:36 GMT

%let yearmonth = 202210;

data _null_;
   dt = input(put(&yearmonth., 6.), yymmn6.);
   call symputx('P_Month', put(intnx('month', dt, -1, 'b'), yymmn6.));
run;

%put &P_Month.;

Re: getting last month from year month date

Kurt_Bremser — Fri, 03 Jun 2022 04:21:11 GMT

SAS dates are counts of days, with 1960-01-01 being day zero.

So your INTNX function starts with a date that is 202,210 days after 1960-01-01, so quite far in the future.

As already indicated, you must convert your year/month string to a SAS date first by using the INPUT function with a proper informat.

Re: getting last month from year month date

Ksharp — Fri, 03 Jun 2022 08:13:56 GMT

%let yearmonth = 202210;

%let last_month=%sysfunc(intnx(month, %sysfunc(inputn(&yearmonth.,yymmn6.)) ,-1),yymmn6.) ;

%put &=last_month. ;

Re: getting last month from year month date

kajal_30 — Fri, 03 Jun 2022 14:34:45 GMT

Thank you so much team.