topic Re: Excel sensitivity label causing 'Segmentation Violation' in SAS Programming

Excel sensitivity label causing 'Segmentation Violation'

Jaskir — Tue, 05 Dec 2023 01:21:56 GMT

My company just started implementing a policy that all Excel documents are now required to have a sensitivity label assigned. The immediate result was these excel files would generate a violation for a simple LIBNAME filename XLSX statement. Any thoughts on how to get around the sensitivity label?

Re: Excel sensitivity label causing 'Segmentation Violation'

Tom — Tue, 05 Dec 2023 01:36:08 GMT

They must have done something wrong that messed up the validity of the XML files in the XLSX file.

The sensitivity labels my company makes us add to XLSX files does not cause trouble when reading the file with SAS.

NOTE: The SAS System stopped processing this step because of errors.

720  libname x xlsx 'c:\downloads\16digits.xlsx';
NOTE: Libref X was successfully assigned as follows:
      Engine:        XLSX
      Physical Name: c:\downloads\16digits.xlsx
721  proc copy inlib=x outlib=work; run;

NOTE: Copying X.XXX to WORK.XXX (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used.
NOTE: The import data set has 1 observations and 3 variables.
NOTE: There were 1 observations read from the data set X.XXX.
NOTE: The data set WORK.XXX has 1 observations and 3 variables.
NOTE: PROCEDURE COPY used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds

Re: Excel sensitivity label causing 'Segmentation Violation'

Jaskir — Tue, 05 Dec 2023 01:59:15 GMT

That is good to know. What version of SAS are you running on? I am running on 9.4 On Prem.

These files worked just fine before the sensitivity label as assigned. The label was "proactively" added to the workbooks with no other changes.

Re: Excel sensitivity label causing 'Segmentation Violation'

Tom — Tue, 05 Dec 2023 02:00:36 GMT

NOTE: SAS (r) Proprietary Software 9.4 (TS1M5)

Re: Excel sensitivity label causing 'Segmentation Violation'

ChrisHemedinger — Tue, 05 Dec 2023 15:28:08 GMT

I wonder if "proactively added" is code for "we wrote a Python script". Instead of "we automated Excel to open and alter the file in a supported way."

Re: Excel sensitivity label causing 'Segmentation Violation'

Sajid01 — Tue, 05 Dec 2023 15:51:09 GMT

Applying sensitivity label may cause encryption or restrictions in the use of excel files.
You can try to access the file from SAS bytreating the file as a password protected file. This paper lists some approaches https://www.mwsug.org/proceedings/2013/FS/MWSUG-2013-FS04.pdf