topic Re: gracefully handling locked sequential files when reading in SAS Procedures

gracefully handling locked sequential files when reading

BenConner — Mon, 22 Jun 2015 17:49:48 GMT

Hi,

I seem to do a fair amount of processing multiple log files in a folder, and typically use the infile ... filevar= approach using a DO loop. Once in a while one of the files being read is opened in exclusive mode by another application, which throws an error and causes the data step not to finish.

Is there a graceful way to continue processing the rest of the files while skipping the locked one?

Thanks!

--Ben

Re: gracefully handling locked sequential files when reading

LinusH — Tue, 23 Jun 2015 06:54:00 GMT

FOPEN() might be a way:

SAS(R) 9.4 Functions and CALL Routines: Reference, Third Edition

Re: gracefully handling locked sequential files when reading

Patrick — Tue, 23 Jun 2015 08:40:07 GMT

System option "FILELOCKWAIT" could be of interest to you.

SAS(R) 9.4 Companion for UNIX Environments, Fourth Edition

SAS(R) 9.4 Companion for Windows, Third Edition

Re: gracefully handling locked sequential files when reading

jakarman — Tue, 23 Jun 2015 10:48:45 GMT

Do not process the logfiles that active written to.You are not having a technical problem you are having a logical one.

At the moment you are reading writing is not allowed and vice versa. That is a generic prerequisition locking is a solution to synchronize actions.

Re: gracefully handling locked sequential files when reading

BenConner — Tue, 23 Jun 2015 11:51:35 GMT

Hi Patrick,

Unfortunately the filelockwait option applies to SAS files only. These are sequential ones. Good choice for SAS files, though!

--Ben

Re: gracefully handling locked sequential files when reading

BenConner — Tue, 23 Jun 2015 11:55:05 GMT

Hi Linus,

That looks like it would work, with a filename()/fopen() combination. Thanks!

--Ben