DATA Step, Macro, Functions and more

Checking using an external file in use

Reply
Super Contributor
Posts: 371

Checking using an external file in use

Hello Experts,

In action 1 : I  zip a file  toto in  toto.zip

In action 2: I  unzip a file  toto.zip  in  test

Before doing the action 2, I would to check if the file toto.zip is not in use.

 

Thank you

 

 

 

PROC Star
Posts: 1,567

Re: Checking using an external file in use

The easiest way to do this is to try and rename the file. If the rename action works, then the file is not locked.

Another way is try and FOPEN() or MOPEN() the file.

Super User
Posts: 6,972

Re: Checking using an external file in use


ChrisNZ wrote:

The easiest way to do this is to try and rename the file. If the rename action works, then the file is not locked.

Another way is try and FOPEN() or MOPEN() the file.


Won't work on UNIX. Since in UNIX, file metadata (location on disk, permissions, timestamps) is stored in the inode, and the filename(s) in the directories, a rename can be done while a file is in use. One can even remove (unlink) a file that is in use, something I use to avoid "file is locked by another user" issues.

In UNIX, one should use the fuser commandline tool to determine if processes have a file handle on the file (inode) in question.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
PROC Star
Posts: 1,567

Re: Checking using an external file in use

@KurtBremser I assume we have a windows user here, but you are right, Unix is different. The functions should work on unix too though, shouldn't they?
Super User
Posts: 6,972

Re: Checking using an external file in use

The functions will work on UNIX, but you would need to specify at least APPEND mode for FOPEN/MOPEN to force an error if the file is opened by another process.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 4 replies
  • 231 views
  • 0 likes
  • 3 in conversation