topic Re: How to generate excel output with password protected in New SAS User

How to generate excel output with password protected

miss2223 — Wed, 29 Jun 2022 02:34:09 GMT

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;

Kurt_Bremser — Wed, 29 Jun 2022 12:13:21 GMT

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 — Thu, 30 Jun 2022 12:36:39 GMT

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

AlanC — Wed, 19 Feb 2025 15:23:04 GMT

An alternative is to have SAS run a command line using the X command. While there are much better ways, look at using PowerShell:

This unzips the xlsx file and then manipulates the XML. The library used here, EPPlus, is used by a lot of people.