Libname Locking File

[utrocketeng]

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.

[Kurt_Bremser · Accepted solution]

Do

libname xxxxx clear;

immediately after reading your Excel data.

[utrocketeng]

that currently is my plan...  thank you for the confirmation!

[Reeza]

You can also check the ACCESS=READONLY option:

libname census xlsx "path to file" access=readonly;

[utrocketeng]

I will try that tomorrow. Thank you.

[utrocketeng]

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!