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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.