topic Re: Libname Locking File in SAS Enterprise Guide

Libname Locking File

utrocketeng — Wed, 17 Jan 2018 18:10:54 GMT

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.

Re: Libname Locking File

Kurt_Bremser — Wed, 17 Jan 2018 18:35:50 GMT

libname xxxxx clear;

immediately after reading your Excel data.

Re: Libname Locking File

utrocketeng — Wed, 17 Jan 2018 19:45:19 GMT

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

Re: Libname Locking File

Reeza — Wed, 17 Jan 2018 21:51:21 GMT

You can also check the ACCESS=READONLY option:

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

Re: Libname Locking File

utrocketeng — Wed, 17 Jan 2018 22:23:43 GMT

I will try that tomorrow. Thank you.

Re: Libname Locking File

utrocketeng — Thu, 18 Jan 2018 14:10:44 GMT

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!