topic Re: Error: File is in use in SAS Programming

Error: File is in use

michaeltro — Mon, 20 Mar 2017 01:59:54 GMT

I've written a program to import a CSV and export an xml file to a SharePoint folder. All works well except that I get an "Error: File is in use" error the next time I run the program. I have to restart EG and I get a sas.exe error when closing the program. Below is the code. Any suggestions? It's annoying that I have to restart the program everytime I make a change as I test edits to the program.

libname t1 xml '\\xxx.net\corpsys\assessment-testing-program\XML Files\req_candidates.xml' xmltype=MSACCESS xmlmeta=schemadata xmlschema=xsd XMLENCODING='UTF-8';
filename xsd '\\xxx.net\corpsys\assessment-testing-program\XML Files\req_candidate.xsd';
data t1.auto_req_candidates;
set WORK.auto_req_candidates;
run;

Re: Error: File is in use

ArtC — Mon, 20 Mar 2017 02:09:40 GMT

Have you tried clearing the T1 libref?

Re: Error: File is in use

Reeza — Mon, 20 Mar 2017 02:12:29 GMT

Close both the filename and t1 references.

libname t1;
filename xsd clear;

Re: Error: File is in use

michaeltro — Mon, 20 Mar 2017 02:43:02 GMT

Looks like clearing t1 was the issue, but cleared xsd to be safe. Works fine now. Thanks!

Re: Error: File is in use

michaeltro — Mon, 20 Mar 2017 02:45:33 GMT

This worked. Also cleared xsd to be safe. Program works fine now. Thanks! Too bad you can't mark both replies as a solution.

Re: Error: File is in use

ArtC — Mon, 20 Mar 2017 18:01:54 GMT

you picked the right one. 🙂