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!
It could not be I think, You need remove these password by hand or vbs before importing .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.