topic Re: Cant run same program twice. ERROR: File is in use (ODS PDF) in SAS Procedures

Cant run same program twice. ERROR: File is in use (ODS PDF)

morglum — Fri, 05 Sep 2014 19:07:47 GMT

Hi everyone,

I am currently having issues writing to a PDF when running a program for the second time (after, say, some minor edits) because SAS starts an instance of AcroRD32.exe (acrobat reader) the first time that I have to kill using ctrl-alt-delete. If I dont, I get "ERROR: file is in use".

Below is a minimal working example under SAS 9.2 2M3. It will work fine once, but I get "ERROR: file is in use" when trying to run it the second time. Any idea what I can do? Thanks,

Simon

-------------

title;

data test;

do i=1 to 10;

output;

end;

run;

ods pdf file="c:\test.pdf";

proc print data=test; run;

ods pdf close;

-------------

Re: Cant run same program twice. ERROR: File is in use (ODS PDF)

ballardw — Fri, 05 Sep 2014 19:39:32 GMT

You likely have the PDF open in a viewer. Make sure it is not in a viewer before running the code.

This also happens with RTF output and is basically the result of the VIEWER locking the file while open.

Re: Cant run same program twice. ERROR: File is in use (ODS PDF)

morglum — Fri, 05 Sep 2014 19:46:53 GMT

Hi Ballard,

It is open,but in SAS's result viewer. I didnt actually open the file myself.

Opening a fresh copy of SAS, then clicking the running man twice will get me an error the second time.

I've added a routine of ctrl-alt-del + killing every AcroRD32.exe process started by SAS before running my program, but it's a pain that I wish I could programatically get rid of.

Re: Cant run same program twice. ERROR: File is in use (ODS PDF)

jakarman — Fri, 05 Sep 2014 19:50:01 GMT

ods noresults?

Re: Cant run same program twice. ERROR: File is in use (ODS PDF)

ballardw — Fri, 05 Sep 2014 19:51:09 GMT

The ODS results viewer is a viewer and has this behavior except for HTML output.

Re: Cant run same program twice. ERROR: File is in use (ODS PDF)

jakarman — Fri, 05 Sep 2014 20:11:35 GMT

My intention is to stop the popping up of the results after the process has run.

31789 - ODS output automatically opens in the Results Viewer window even when specifying ODS NORESULTS or ODS RESULTS OFF

In Eguide there also an option of the same kind

No automatic open, no lock, no problem