Solved: Re: Import more than one file and merge to one dataset - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Quartz | Level 8

Quartz | Level 8

Import more than one file and merge to one dataset

Posted 10-19-2018 10:11 AM (1001 views)

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
Comments 2018-10-19.csv.
Comments 2018-10-18.csv
Comments 2018-10-17.csv
Comments 2018-10-16.csv

How do i import files an merge it to one ? Thanks for help

1 ACCEPTED SOLUTION

Accepted Solutions

Diamond | Level 26

Diamond | Level 26

Re: Import more than one file and merge to one dataset

Posted 10-19-2018 10:23 AM (992 views) | In reply to Gil_

There are many posts on here about this topic. Simplest method is to use a datastep, with an infile and wildcard:

https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-tex...

View solution in original post

1 REPLY 1

Diamond | Level 26

Diamond | Level 26

Re: Import more than one file and merge to one dataset

Posted 10-19-2018 10:23 AM (993 views) | In reply to Gil_

There are many posts on here about this topic. Simplest method is to use a datastep, with an infile and wildcard:

https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-tex...