How to select file with previous date in name file

[Gieorgie]

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

[PaigeMiller · Accepted solution]

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]

Thanks ! its working ! so just need put 'lastmonth' to select file_$lastmonth ?

[PaigeMiller]

---

@Gieorgie wrote:
Thanks ! its working ! so just need put 'lastmonth' to select file_$lastmonth ?

---

&lastmonth

[Kurt_Bremser]

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.