how to resolve dates file from a txt to sas format

[Rixile106]

Good expects.

i have the following txt files which are received in a weekly basis (every Monday).

i use the import statement to convert the file to sas data format ,however i need to hard code the date every time (every Monday) a new file gets generated, is there a way/ function used in sas that will enable me not to hard code the date 

PROC IMPORT 
     OUT= WORK.GLACNT_IMPORT
     DATAFILE= "/SAS/data/Text/data/GLACNT.20220523.TXT"
     DBMS=DLM REPLACE;
     DELIMITER='|'
     DSD
     LRCEL=12
    GETNAMES=YES;
     DATAROW=2;
RUN;

[PaigeMiller]

What is the question? You have text files, what do you want to do with them?

[Rixile106]

i want a function that will enables me to stop hard coding the date everytime a new files gets generated e.g &Yday.

[PaigeMiller]

You should explain more about how any code that is written would know what days/file names to look for. I'm not asking for SAS code, I am asking you to explain in words what the rules are that this code must follow so that the right files can be read in.

Or I could guess, but usually that's not as good an idea as you explaining.

[Tom · Accepted solution]

You can use a macro variable to build the filename.

So set the value into the macro variable and replace the date-like string in the name with a reference to macro variable.

Note the extra period.  The first period marks the end of the name of the macro variable. The second period is the one that becomes part of the filename.

%let today=20220523 ;
...
   DATAFILE= "/SAS/data/Text/data/GLACNT.&today..TXT"
...

So assuming that string represents a date in YYYYMMDD order you can generate such a string using the YYMMDDN format.

So if you just want today's date:

%let today=%sysfunc(date(),yymmddn8.);

If you want some other date then calculate that date instead.  For example if the want the most recent Monday you could use INTNX() with WEEK.2 interval.

%let monday=%sysfunc(intnx(week.2,%sysfunc(date()),0),yymmddn8.);

And then use &MONDAY in making the filename.

...
   DATAFILE= "/SAS/data/Text/data/GLACNT.&monday..TXT"
...

[ballardw]

If these files are supposed to be of the same structure you really should use  Data step code to read the files so that the variables have the same characteristics. Every time you run Proc Import it makes guesses as to the type and length of variables and that may change depending on the contents.