topic Re: How to select file with previous date in name file in SAS Programming

How to select file with previous date in name file

Gieorgie — Thu, 07 Oct 2021 10:29:37 GMT

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

Re: How to select file with previous date in name file

PaigeMiller — Thu, 07 Oct 2021 10:35:05 GMT

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;

Re: How to select file with previous date in name file

Gieorgie — Thu, 07 Oct 2021 10:48:21 GMT

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

Re: How to select file with previous date in name file

Kurt_Bremser — Thu, 07 Oct 2021 10:54:04 GMT

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.

Re: How to select file with previous date in name file

PaigeMiller — Thu, 07 Oct 2021 10:54:45 GMT

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

&lastmonth