topic Re: Proc Export and Password Protect it in SAS Programming

Proc Export and Password Protect it

gnetnaw — Sat, 15 Sep 2018 11:22:17 GMT

Hi,

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

Re: Proc Export and Password Protect it

bobpep212 — Sat, 15 Sep 2018 12:14:42 GMT

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

Re: Proc Export and Password Protect it

gnetnaw — Sun, 16 Sep 2018 15:36:01 GMT

Thanks!