LOCK (Retrieve SYSUSERID instead of JOB_ID) - how to

[Krohn]

ERROR: Lock held by process 346

I'd like to know directly who is using the Dataset and not the JOB_ID

Is it possible to retrieve like: "Lock held by user 1234" (that &SYSUSERID macro variable)??

• SAS Enterprise Guide 6.1
• X command unabled

Thanks!

[LinusH]

With the pid you can look up the user by using OS tools/commands.
What is the underlying requirement?
There have been numerous threads discussing this is, sugest that you browse these.
Bottom line: if you have frequent problems with locking switch to a multi user data store, or implement a script that kills all SAS processes prior to batch processing.

[Kurt_Bremser]

You will need to use OS tools enabled to do this.

To do it manually, log on to the server with ssh and use something like ps -ef|grep processnumber

To do it automatically in SAS, you MUST have XCMD enabled.

My preferred method to avoid this is to physically delete the target dataset file using OS commands (works on UNIX like a charm) before writing it.