Import all Excel files in a folder and add all to 1 final file

[hhchenfx]

Hello Everyone,

I have 1 folder with multiple Excel (xlsx) files with random name.

I want to import all of them and put to a final file.

Can anyone help me how to get it done?

My idea is below.

Many thanks!

HC

proc import datafile="C:\Users\document\*.xlsx"
out=_tempfile dbms=xlsx replace;
getnames=yes;
run;

data final; set final _tempfile;run;

[Reeza · Accepted solution]

Not a particular efficient solution, especially in terms of getting all the files but the rest is about the same. 

https://github.com/statgeek/SAS-Tutorials/blob/master/Import_all_files_one_type

[hhchenfx]

It works nicely.

Thank you.

HC