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."
Learn from the Experts! Check out the huge catalog of free sessions in the Ask the Expert webinar series.
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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 1351 views
  • 1 like
  • 4 in conversation