How to import several .csv files at once and then Append all of them

[subrat1]

Spoiler

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.

(All csv files columns are same)

[Kurt_Bremser]

You can use wildcards in the infile statement:

data want;
infile "path_to_files/*.csv" /* further options */;
input ........;
run;

[Reeza]

Get it working for one dataset then you can switch if to an automated version.  See one method detailed here. 

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