topic Re: Identify who has a dataset open in SAS Procedures

Identify who has a dataset open

Karolus — Fri, 30 Apr 2010 08:20:47 GMT

Dear all,

I work in a network, with both Base SAS 9.2, Data Integration Studio 3.4 (DIS).
I have a problem when my macro is trying to access and edit a dataset that either someone else has open, or someone else's macro is processing.
My question is, there is way to know which user has locked the dataset? The log of SAS only says the dataset is in use by someone else, but I'd like to see "by who" as part of the log.

Regards
Karl

Re: Identify who has a dataset open

deleted_user — Fri, 30 Apr 2010 15:25:25 GMT

Hi Karl,

I have had few time to deal with this myself. I did not arrive at a solution but found a work around to lock the datasets and directories for my use before starting the process/running my codes.

Refer this document, I loved it.
http://www.lexjansen.com/pharmasug/2005/posters/po33.pdf

Hope it helps

Regards
Surya

Re: Identify who has a dataset open

ChrisNZ — Mon, 03 May 2010 21:36:27 GMT

You might also want to consider using sas/share.

Re: Identify who has a dataset open

Karolus — Fri, 07 May 2010 11:37:32 GMT

Thanks man! it's a good work around

Re: Identify who has a dataset open

Kurt_Bremser — Thu, 27 Feb 2014 07:01:45 GMT

If your SAS is installed on a UNIX, the error message will include the process number of the locking process. ps -fp processnumber will give you the user's ID.

Re: Identify who has a dataset open

MarkRoosen — Thu, 27 Feb 2014 09:10:31 GMT

Hi,

on linux I use following syntax:

ps -ef | grep 1234

... where 1234 is the process ID that is locking your process

kind regards,

Mark