https://communities.sas.com/t5/SAS-Programming/Create-data-set-with-information-of-dates-in-txt-files-names/m-p/684928#M207659 <P>Read the very first pinned article, about how to read file names in a directory.</P> Fri, 18 Sep 2020 10:44:48 GMT ChrisNZ 2020-09-18T10:44:48Z https://communities.sas.com/t5/SAS-Programming/Create-data-set-with-information-of-dates-in-txt-files-names/m-p/684926#M207657 <P>Hello</P> <P>Let's say that in specific path there are multiple txt files with name structure: RevenueYYYYMMDD</P> <P>(For example: Revenue20200912,&nbsp;Revenue20200917,Revenue20200802&nbsp; and so on)</P> <P>The task is to tell SAS to create a data set with one column called date_Revenue_File.</P> <P>In this column there will be dates from names of the files&nbsp;date.</P> <P>For example:</P> <P>If there are 3 files:</P> <P>Revenue20200912</P> <P>Revenue20200917</P> <P>Revenue20200802&nbsp;</P> <P>&nbsp;</P> <P>Then in the column "date" there will be 3 values:</P> <P>20200912</P> <P>20200917</P> <P>20200802&nbsp;</P> <P>&nbsp;</P> <P>thank you</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 18 Sep 2020 10:29:29 GMT https://communities.sas.com/t5/SAS-Programming/Create-data-set-with-information-of-dates-in-txt-files-names/m-p/684926#M207657 Ronein 2020-09-18T10:29:29Z https://communities.sas.com/t5/SAS-Programming/Create-data-set-with-information-of-dates-in-txt-files-names/m-p/684928#M207659 <P>Read the very first pinned article, about how to read file names in a directory.</P> Fri, 18 Sep 2020 10:44:48 GMT https://communities.sas.com/t5/SAS-Programming/Create-data-set-with-information-of-dates-in-txt-files-names/m-p/684928#M207659 ChrisNZ 2020-09-18T10:44:48Z