We are looking to automate a piece of work that would have data exported to excel and then automatically emailed to suppliers. The problem is that the data needs to be password protected and currently there are no SAS procedures that allow you to add a password to an excel. Similarly we investigated adding a password to a zip file as a method of password protection and found no such feature.
Adding the ability to password protect data for consumption by third parties who do not have access to data tools (i.e. excel, csv) would allow for automation and integration.
We suggest that either a password option is added to proc export or creating a new procedure to password protect excel or zip files would be the ideal solution but any solution that achieved the end result would be acceptable.
