LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2002, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 22 Aug 2002 16:53:31 -0700
Reply-To:     WCheng@ISISPH.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Wei Cheng <WCheng@ISISPH.COM>
Subject:      Re: macro code: How to check whether file is locked
Comments: To: Peter Crawford <peter.crawford@DB.COM>
Content-Type: multipart/alternative;

Does anyone know a Windows equivalent to find the user?

Thanks,

Wei

Peter Crawford <peter.crawford@DB.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 08/22/02 01:27 PM Please respond to Peter Crawford

To: SAS-L@LISTSERV.UGA.EDU cc: Subject: Re: macro code: How to check whether file is locked

on unix, you might discover with ( aix /Korn shell) system command fuser -u filename Here is an example generating the full path and low case table name filename inuse pipe "fuser -u %sysfunc(pathname(<libref>))/%lowcase(<memname>.sas7bdat" ; To check output from the command, try it first with a datastep like data; infile inuse ; input ; put _infile_ ; run; Output is like /path/filename: processID(userID) So you could try data; infile inuse ; put _infile_ ; input ; If scan( _infile_,2,':') ne ' ' then do; length locker P_id $16. locker = scan( _infile_, 2, '()' ); P_id = scan( _infile_, 2, ':(' ); Put "send rude messages to "he who holds the data' =" locker= p_id= ; output ; end; run;

And then you know who to speak to !

Good Luck Peter Crawford

Datum: 22/08/2002 17:34 An: SAS-L@LISTSERV.UGA.EDU

Antwort an: alte@uni-greifswald.de

Betreff: macro code: How to check whether file is locked Nachrichtentext:

Dear all,

having tried with open and sysmsg - but not successful.

How can I check before writing to a sas file (sas7bdat) in macro code, whether this file is locked by some other user?

TIA

-- ----------------------------------------------------------------- Dietrich Alte (Statistician, Dipl.-Stat.) University of Greifswald - Medical Faculty Institute of Epidemiology and Social Medicine Walther-Rathenau-Str. 48, D-17487 Greifswald, Germany Phone +49 (0) 3834 - 86 77 13, fax +49 (0) 3834 - 86 66 84 Email alte@uni-greifswald.de Institute http://www.medizin.uni-greifswald.de/epidem/ Study http://www.medizin.uni-greifswald.de/epidem/ship.htm -----------------------------------------------------------------

--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail

irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und

vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you

are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.


[text/html]


Back to: Top of message | Previous page | Main SAS-L page