Is there a way to set the excel sensitivity label by a SAS proc export query.

vedchd — Thu, 25 Jan 2024 10:12:08 GMT

If I export a SAS dataset to excel, after opening, I have to select label => Public/Internal/ Confidential/ Strictly Confidential. It would be handy to write a line of query which sets it to "Internal" for example.

Re: Is there a way to set the excel sensitivity label by a SAS proc export query.

ballardw — Thu, 25 Jan 2024 15:29:39 GMT

You might find the discussions in these two thread informational if not a solution:

https://communities.sas.com/t5/SAS-Programming/Excel-sensitivity-label-causing-Segmentation-Violation/m-p/906159#M357832

https://communities.sas.com/t5/SAS-Programming/ODS-Sensitivity-Label/m-p/902188#M356508

The upshot on part of this is it involves local to your organization Microsoft settings that are not implemented everywhere and may be that a solution that works in some organization may not actually be very portable.

Strongly suggest contacting SAS Tech Support as you may need to share information to develop a solution that doesn't belong in a public forum.

topic Re: Is there a way to set the excel sensitivity label by a SAS proc export query. in SAS Studio

Is there a way to set the excel sensitivity label by a SAS proc export query.

Re: Is there a way to set the excel sensitivity label by a SAS proc export query.