DATA Step, Macro, Functions and more

Read password protected excel file into SAS

Reply
Regular Contributor
Posts: 150

Read password protected excel file into SAS

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! 

Super User
Posts: 19,789

Re: Read password protected excel file into SAS

Posted in reply to rfarmenta

I think DDE is the only way. Another possibility may be using and ODBC connection method. Also seems complicated though. 

Super User
Posts: 5,426

Re: Read password protected excel file into SAS

Posted in reply to rfarmenta
The obvious (?) solution is not to use password protected files, it has quite a few cons.
Use file system authorization instead for file protection.
Data never sleeps
Regular Contributor
Posts: 150

Re: Read password protected excel file into SAS

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

Super User
Posts: 5,426

Re: Read password protected excel file into SAS

Posted in reply to rfarmenta
Password is not considered safe, it just hinders accidental viewing.
DDE is old technology and is not even supported by Microsoft. So i think that should be avoided in all applications whenever possible.
Sftp or similar method is safer.
Data never sleeps
Ask a Question
Discussion stats
  • 4 replies
  • 290 views
  • 0 likes
  • 3 in conversation