cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
MilanVlcek
Calcite | Level 5 MilanVlcek
Calcite | Level 5

Create password protected Excel file

Posted 11-29-2019 03:27 AM (4267 views)

Hi. Is there a way how to create a password protected Excel file? I've wet through the PROC EXPORT documentation and didn't find anything useful. But maybe I'm missing something. Thank you for your help. Milan

0 Likes
Reply
1 REPLY 1
PeterClemmensen
Tourmaline | Level 20 PeterClemmensen
Tourmaline | Level 20

Re: Create password protected Excel file

Posted 11-29-2019 03:41 AM (4263 views)  |   In reply to MilanVlcek

@MilanVlcek Hi and welcome to the SAS Community.

 

I don't think this ability exists in either PROC EXPORT or the ODS Excel Destination. You can try to go with the example in Sample 31328: Creating password-protected Excel files with SAS® software, though I haven't tried it myself. Good luck 🙂

The DATA to DATA Step Macro
Blog: SASnrd
0 Likes
Reply

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Watch Mastering the WHERE Clause in PROC SQL on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎11-29-2019 03:27 AM
  • 4268 views
  • 0 likes
  • 2 in conversation