I have a function that selects a file from this month, how to change it so that it always selects from the previous one. for example now select file from september
%let thismonth=%sysfunc(putn(%sysfunc(today()),yymmn6.));
Instead of providing you with a command that uses %SYSFUNC() three times nested, I will provide what I feel is a simpler method.
data _null_;
call symputx('lastmonth',put(intnx('month',today(),-1),yymmn6.);
run;
Instead of providing you with a command that uses %SYSFUNC() three times nested, I will provide what I feel is a simpler method.
data _null_;
call symputx('lastmonth',put(intnx('month',today(),-1),yymmn6.);
run;
@Gieorgie wrote:
Thanks ! its working ! so just need put 'lastmonth' to select file_$lastmonth ?
&lastmonth
Just use INTNX in %SYSFUNC:
%let thismonth=%sysfunc(intnx(month,%sysfunc(today()),-1),yymmn6.);
Note that %SYSFUNC on its own enables the use of a format, so you do not need PUTN.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.