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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.