Help using Base SAS procedures

gracefully handling locked sequential files when reading

Accepted Solution Solved
Reply
Regular Contributor
Posts: 169
Accepted Solution

gracefully handling locked sequential files when reading

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


Accepted Solutions
Solution
‎06-23-2015 02:54 AM
Super User
Posts: 5,256

Re: gracefully handling locked sequential files when reading


All Replies
Solution
‎06-23-2015 02:54 AM
Super User
Posts: 5,256

Re: gracefully handling locked sequential files when reading

FOPEN() might be a way:

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

Data never sleeps
Regular Contributor
Posts: 169

Re: gracefully handling locked sequential files when reading

Hi Linus,

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

--Ben

Respected Advisor
Posts: 3,889

Re: gracefully handling locked sequential files when reading

Regular Contributor
Posts: 169

Re: gracefully handling locked sequential files when reading

Hi Patrick,

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

--Ben

Valued Guide
Posts: 3,208

Re: gracefully handling locked sequential files when reading

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.

---->-- ja karman --<-----
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 284 views
  • 0 likes
  • 4 in conversation