Is it possible to write a LIBNAME statement for an excel file in EG without locking it? i just want to read in contents of the excel file; not lock it for read/write purpose.
Proc Import is no longer an option as my environment is migrating from Windows to Linus. I've read several posts about LibName locking files excel files, but i had not seen anyone ask if there was a option in the Libname statement to prevent the lock in the first place.
Do
libname xxxxx clear;
immediately after reading your Excel data.
Do
libname xxxxx clear;
immediately after reading your Excel data.
that currently is my plan... thank you for the confirmation!
You can also check the ACCESS=READONLY option:
libname census xlsx "path to file" access=readonly;
Reeza, i tried the 'access=readonly'; and the excel file was still locked. i really do not care for excel. 😕
thank you again for the feedback!
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!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.