BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
miss2223
Fluorite | Level 6

I would like to generate an excel output with password protected it. Is there a way to do that in SAS step?

 

My code:

proc export data=final
outfile="C:\Users\ai\Desktop\test.xls"
dbms=xlsx replace;
run;

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

Setting a password has to be done in Excel or other spreadsheet software that can do it.

How you get the external software to do it (if possible at all) depends on your environment (is SAS installed on Windows or UNIX, is XCMD enabled).

DDE is deprecated by Microsoft and should no longer be used (the note referred to by @SAS_Cares is from 2008!)

View solution in original post

2 REPLIES 2
Kurt_Bremser
Super User

Setting a password has to be done in Excel or other spreadsheet software that can do it.

How you get the external software to do it (if possible at all) depends on your environment (is SAS installed on Windows or UNIX, is XCMD enabled).

DDE is deprecated by Microsoft and should no longer be used (the note referred to by @SAS_Cares is from 2008!)

SAS_Cares
SAS Employee

Noted! You are absolutely right, removing! And this is why we rely on our Super Users 😉 thanks for spotting it!

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1878 views
  • 2 likes
  • 3 in conversation