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: 17,952

Re: Read password protected excel file into SAS

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

Super User
Posts: 5,260

Re: Read password protected excel file into SAS

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,260

Re: Read password protected excel file into SAS

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
  • 255 views
  • 0 likes
  • 3 in conversation