BookmarkSubscribeRSS Feed
Jaskir
Calcite | Level 5

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?

5 REPLIES 5
Tom
Super User Tom
Super User

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
Jaskir
Calcite | Level 5

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. 

 

Tom
Super User Tom
Super User

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

ChrisHemedinger
Community Manager
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."
SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
Sajid01
Meteorite | Level 14

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 2220 views
  • 1 like
  • 4 in conversation