I have a folder of password protected xlsx files. They all have one sheet, have the same data columns with clean data, but the specific names of each excel varies since these are manually saved. Is it possible to write a code to import all of the files in the folder and compile into one SAS dataset? They are all password protected with the same password. I have several folders like this that I would like to apply this to, and they are added to every week so having a more automated process would be greatly helpful. I've looked at some online articles regarding importing multiple unprotected files, and importing one password protected file, but I haven't been able to find a way to import all the password protected excel files in the folder. My understanding of SAS macros is still fairly beginner. I am using SAS 9.4 TS Level 1.3 Thank you for your help!
... View more