Hi Oleg. I realize that this post is from a previous decade but here goes anyway. I am ultimately trying to read a lot of locked Excel data into a dataset. I am using EG 8.4 and have copied the files to the server. I tried DDE since the files are copied to the server using another one of your examples but the line filename cc dde 'Excel|System'; throws this error: ERROR: Invalid device type.ERROR: Error in the FILENAME statement.
So I was trying the VBA script option you mention, modified to read the file with password, unprotect it, and re-save without password. But I'm getting the error that it doesn't understand the C-shell command: /bin/bash: cscript: command not found
Any suggestions? If not, I am going to just work outside of SAS. It will just be slow...
DDE is only possible if you are running SAS on your PC and the Excel file is accessible from the PC. Sounds like your EG uses a remote Unix SAS server so it isn't going to work and VBA wont run on Unix.
The quick fix is to create an un-passworded version and upload that to your SAS server.
I appreciate this post is 12 years old, but my team finally 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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.