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

[vedchd]

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.

[ballardw · Accepted solution]

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-Violatio...

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.