Date in macro

Aman4SAS — Thu, 13 Mar 2014 12:32:15 GMT

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..

Re: Date in macro

Amir — Thu, 13 Mar 2014 12:39:42 GMT

Hi,

Try removing the quotes around the 'S':

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

See the documentation on %sysfunc:

Regards,

Amir.

Aman4SAS — Thu, 13 Mar 2014 13:05:35 GMT

Thanks