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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.