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..
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.
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.
Thanks
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.