topic Re: How to import several .csv files at once and then Append all of them in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-import-several-csv-files-at-once-and-then-Append-all-of/m-p/362692#M85702 <P>Get it working for one dataset then you can switch if to an automated version. &nbsp;See one method detailed here.&nbsp;</P> <P>&nbsp;</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> Tue, 30 May 2017 12:33:19 GMT Reeza 2017-05-30T12:33:19Z How to import several .csv files at once and then Append all of them https://communities.sas.com/t5/SAS-Programming/How-to-import-several-csv-files-at-once-and-then-Append-all-of/m-p/362684#M85699 <LI-SPOILER>&nbsp;</LI-SPOILER><P>I have several csv file in a folder, I want to import all of them into sas and then append all of them in one table.</P><P>&nbsp;</P><P>(All csv files columns are same)</P> Tue, 30 May 2017 12:06:42 GMT https://communities.sas.com/t5/SAS-Programming/How-to-import-several-csv-files-at-once-and-then-Append-all-of/m-p/362684#M85699 subrat1 2017-05-30T12:06:42Z Re: How to import several .csv files at once and then Append all of them https://communities.sas.com/t5/SAS-Programming/How-to-import-several-csv-files-at-once-and-then-Append-all-of/m-p/362686#M85700 <P>You can use wildcards in the infile statement:</P> <PRE><CODE class=" language-sas">data want; infile "path_to_files/*.csv" /* further options */; input ........; run;</CODE></PRE> Tue, 30 May 2017 12:13:34 GMT https://communities.sas.com/t5/SAS-Programming/How-to-import-several-csv-files-at-once-and-then-Append-all-of/m-p/362686#M85700 Kurt_Bremser 2017-05-30T12:13:34Z Re: How to import several .csv files at once and then Append all of them https://communities.sas.com/t5/SAS-Programming/How-to-import-several-csv-files-at-once-and-then-Append-all-of/m-p/362692#M85702 <P>Get it working for one dataset then you can switch if to an automated version. &nbsp;See one method detailed here.&nbsp;</P> <P>&nbsp;</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> Tue, 30 May 2017 12:33:19 GMT https://communities.sas.com/t5/SAS-Programming/How-to-import-several-csv-files-at-once-and-then-Append-all-of/m-p/362692#M85702 Reeza 2017-05-30T12:33:19Z