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?
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
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.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M5)
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 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.