topic Re: Gather all csv files from a folder into a single sas table. in SAS Programming

Gather all csv files from a folder into a single sas table.

WilliamB — Mon, 27 Nov 2017 10:08:28 GMT

Hello,
i would like to import all these csv files from this folder into sas quickly.
Then concatenate all in one table.

Thanks for your help.

Re: Gather all csv files from a folder into a single sas table.

PeterClemmensen — Mon, 27 Nov 2017 10:11:39 GMT

Use this example from SAS Support

http://support.sas.com/kb/41/880.html

and stack them accordingly 🙂

Re: Gather all csv files from a folder into a single sas table.

RW9 — Mon, 27 Nov 2017 10:22:41 GMT

One of the most common questions on here. Please check the Search option at the top before posting. The simplest method if they are all the same structure (which if you want them all in one dataset seems likely) is to use a datastep with an infile ".../*.csv"; line.