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;
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
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
It works nicely.
Thank you.
HC
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.