Hello
Let's say that in specific path there are multiple txt files with name structure: RevenueYYYYMMDD
(For example: Revenue20200912, Revenue20200917,Revenue20200802 and so on)
The task is to tell SAS to create a data set with one column called date_Revenue_File.
In this column there will be dates from names of the files date.
For example:
If there are 3 files:
Revenue20200912
Revenue20200917
Revenue20200802
Then in the column "date" there will be 3 values:
20200912
20200917
20200802
thank you