BookmarkSubscribeRSS Feed
jp
Fluorite | Level 6 jp
Fluorite | Level 6

Hi, I wasn't sure if this belongs here or in the SAS EG forum which is what the majority of my team uses.

I'm responsible for updating a library of commonly used datasets, however I can't update a premium table due to one team member having it open which is causing a Lock. This team member has gone on holiday for a week, which means I can't update the table until she gets back, unless I reset her computer which wouldn't be ideal.

I was wondering if there is a way to specify a "NOLOCK" option in the libname (similar to the passthrough option used in PROC SQL) or something similar to prevent this from occurring in the future. I've tested the "ACCESS = READONLY" libname functionality but that doesn't seem to stop a lock on the data when one member is viewing the data.

Cheers for any help

6 REPLIES 6
Peter_C
Rhodochrosite | Level 12

can you use theoperating system to copy the xxxx.sas7bdat file into another folder?

SASKiwi
PROC Star

If I am correct in assuming that you are using EG connected to SAS BI server, then your team member must have a SAS process still running on the server.

What you can do is talk to one of your IT administrators and ask them to view all active processes on the SAS server by username and ask them to kill any processes under your team member's username. This should clear the locking problem.

Unfortunately SAS relies on the operating system it runs on for file locking so there is no reliable way to avoid SAS dataset locking problems unless you use SAS's SAS/SHARE product.

If you search the SAS forum on file / dataset locking you will find a lot of users have similar problems. I live in hope that SAS will improve in this area in the future....    

jp
Fluorite | Level 6 jp
Fluorite | Level 6

Unfortunately we aren't using a SAS BI Server (as far as I know). Interesting point about the operating system, I had a quick glance at some solution based around editing the registry.. I ruled this out based purely on the IT headache it would likely create.

SASKiwi
PROC Star

So what is EG connecting to? It has to be either a local SAS session on your PC, if you have SAS as well as EG installed, or a remote SAS server - this is generically called SAS BI Server although you may know it by a different name.

jp
Fluorite | Level 6 jp
Fluorite | Level 6

I believe we use a local SAS Session (which I've understood to be the usual alternative to a "SAS Sever"), but I do have Base SAS + EG installed though I've never heard it described as a BI Server. I don't believe we have the functionality to request processes to be killed on the/a SAS Server.

PS: Hi from NZ

SASKiwi
PROC Star

OK. So your local PC SAS session(s) - controlled from EG - must be locking SAS datasets stored on a central file server somewhere - is this correct? So apart from rebooting your team member's PC the only solution I can think of is to get an IT suport person to remote into the PC and do an "end task" on the SAS session.

PS: Hi from Windy Wellington!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 5542 views
  • 0 likes
  • 3 in conversation