Hi,
Appreciate if anyone can advise if it is possible to proc export data to excel and password protect the excel sheet? Thanks.
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
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
Thanks!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: