Is there a way to read a password protected excel file into SAS? I have seen some code (DDE I believe) but it seems overly complicated. I was wondering if there were other ways to read in password protected files. Thank you!
I think DDE is the only way. Another possibility may be using and ODBC connection method. Also seems complicated though.
We actually did not have a choice as the file was sent to us as a password protected file due to the sensitive nature of the data. I am just using the DDE code to work with the files. Thank you
We added this feature to Data Controller today - just upload the excel, enter the password, approve the change, and your password-protected excel data is now in your target SAS table ready to process.
Works on ALL versions of SAS (Viya, EBI, Base) and is free for up to 5 users.
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.