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

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

hhchenfx — Tue, 12 Sep 2017 17:58:52 GMT

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!

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

data final; set final _tempfile;run;

Reeza — Tue, 12 Sep 2017 18:11:53 GMT

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

hhchenfx — Tue, 12 Sep 2017 19:09:18 GMT

It works nicely.

Thank you.