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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.