Date in macro

[Aman4SAS]

When using it :

%let bdt = 20050513;

%let nbdt= %sysfunc(inputn(&bdt,yymmdd10.));

%let wbdt=%sysfunc(putn(&nbdt,date9.));

%let npdt=%sysfunc(intnx(month,&nbdt,-1));

%let wpdt=%sysfunc(putn(&npdt,date9.));

%put &bdt &nbdt &wbdt &npdt &wpdt;

Working fine, But use below one creating problem,

%let bdt = 20050513;

%let nbdt= %sysfunc(inputn(&bdt,yymmdd10.));

%let wbdt=%sysfunc(putn(&nbdt,date9.));

%let npdt=%sysfunc(intnx(month,&nbdt,-1,'S')); - Error Point - Using 'S' is creating problem , its a part of intnx function

%let wpdt=%sysfunc(putn(&npdt,date9.));

%put &bdt &nbdt &wbdt &npdt &wpdt;

Can any one please guide me on this .

I want same day for prev month..

[Amir · Accepted solution]

Hi,

Try removing the quotes around the 'S':

%let npdt=%sysfunc(intnx(month,&nbdt,-1,S));

See the documentation on %sysfunc:

SAS(R) 9.4 Macro Language: Reference

Regards,

Amir.

[Aman4SAS]

Thanks