topic One month back from today date in macro varaible in SAS Programming

One month back from today date in macro varaible

Ronein — Fri, 12 Apr 2019 15:15:02 GMT

Hello

Today is 13 April 2018

I want to get date one month back...(13 Mar 2018)

What is wrong in the code that the result is 01Mar2018

%let dts = "%sysfunc(today(),date9.)"d;
%put &dts;/*"12APR2019"d*/
%let w = "%sysfunc(intnx(MONTH,&dts,-1),date9.)"d;
%put &w;/*"01MAR2019"d*/

Re: One month back from today date in macro varaible

novinosrin — Fri, 12 Apr 2019 15:20:42 GMT

117  %let dts = %sysfunc(today());
118  %put &dts;/*"12APR2019"d*/
21651
119  %let w = %sysfunc(intnx(MONTH,&dts,-1,s),date9.);
120  %put &w;
12MAR2019

@Ronein

For calculations, plz keep the Date value as numbers and avoid formats or using string literals.

If you want, just format the final needed result as show above.

Plus you need s option to get the same value of the previous month

Re: One month back from today date in macro varaible

Tom — Fri, 12 Apr 2019 15:24:07 GMT

Nothing to do with macro.

You need set the last parameter for the INTNX() function to SAME. If you don't specify a value the default is to use BEGINNING.

%let w = "%sysfunc(intnx(MONTH,&dts,-1,s),date9.)"d;