One month back from today date in macro varaible

[Ronein]

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*/

[novinosrin · Accepted solution]

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

[Tom]

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;