Proc Export and Password Protect it

[gnetnaw]

Hi,

Appreciate if anyone can advise if it is possible to proc export data to excel and password protect the excel sheet? Thanks.

[bobpep212 · Accepted solution]

I've had success using the x command to open excel through SAS, then run VBA, which you could use to open the file you just exported, add the password protection, resave and close. Below is the link to the SAS paper explaining how to open excel and run a simple macro - that first bit of code should be all you need (plus the code for the VBA, which should be fairly simple). 

https://support.sas.com/resources/papers/proceedings16/7120-2016.pdf

[gnetnaw]

Thanks!