https://communities.sas.com/t5/SAS-Programming/Import-more-than-one-file-and-merge-to-one-dataset/m-p/505940#M135550 <P>There are many posts on here about this topic.&nbsp; Simplest method is to use a datastep, with an infile and wildcard:</P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627</A></P> Fri, 19 Oct 2018 14:23:04 GMT RW9 2018-10-19T14:23:04Z https://communities.sas.com/t5/SAS-Programming/Import-more-than-one-file-and-merge-to-one-dataset/m-p/505932#M135545 I have a request to create a report based on daily files . I need to import last 7 files all formatted the same and same number of columns.. the name of file<BR />Comments 2018-10-19.csv.<BR />Comments 2018-10-18.csv<BR />Comments 2018-10-17.csv<BR />Comments 2018-10-16.csv<BR /><BR />How do i import files an merge it to one ? Thanks for help Fri, 19 Oct 2018 14:11:58 GMT https://communities.sas.com/t5/SAS-Programming/Import-more-than-one-file-and-merge-to-one-dataset/m-p/505932#M135545 Gil_ 2018-10-19T14:11:58Z https://communities.sas.com/t5/SAS-Programming/Import-more-than-one-file-and-merge-to-one-dataset/m-p/505940#M135550 <P>There are many posts on here about this topic.&nbsp; Simplest method is to use a datastep, with an infile and wildcard:</P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627</A></P> Fri, 19 Oct 2018 14:23:04 GMT https://communities.sas.com/t5/SAS-Programming/Import-more-than-one-file-and-merge-to-one-dataset/m-p/505940#M135550 RW9 2018-10-19T14:23:04Z