topic Re: Read log file while it is still being written in SAS Programming

Read log file while it is still being written

VAMA — Tue, 20 Jul 2010 16:41:51 GMT

When I am reading sas log(using program below) file created by some sas program I am getting error message - "ERROR: File is in use," when executing program mentioned below using sas9.2, whereas if I execute below mentioned program using sas9.1.3 I am not getting any error. log file is created using sas9.2. in both cases sas program creating log file was executing..
Can somebody let me know what is happening.

data tmp;
do i=1 to 100;
x="log file path";
output;
end;
run;

data _null_;
set tmp;
infile tmplog filevar=x filename=check2 end=done2 length=_lenvar truncover;
input _logrec_ $varying300. _lenvar;
run;

Re: Read log file while it is still being written

sbb — Tue, 20 Jul 2010 17:16:20 GMT

Lots of free and helpful Internet resources (hosted DOC, supplemental technical and conference topic-related papers) at the SAS support website http://support.sas.com/ -- consider using the Google search mentioned below.

Also, if necessary, suggest you most your SAS log output with the diagnostic messages (and code) leading up to the error, particular about the INFILE and that file which you must have allocated elsewhere?

Also, for future reference, helpful info about your SAS version, OS platform, whether the program has or has not worked previously (is it new function), whether SAS is installed locally on your machine or on a remote server.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic / post:

+"file in use" site:sas.com

Re: Read log file while it is still being written

Bernie_iMS — Fri, 23 Jul 2010 18:10:47 GMT

I have the very same issues between 9.1.3 amd 9.2... Did you get any real helpfull replies yet?

Re: Read log file while it is still being written

Bernie_iMS — Tue, 27 Jul 2010 16:41:05 GMT

Problem solved by using Options FILELOCKS= ('/xxxxx/xxx' NONE);. Behaviour in 9.2 has changed as it also locks External files.