Error: File is in use

[michaeltro]

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;

[ArtC]

Have you tried clearing the T1 libref?

[michaeltro]

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

[ArtC]

you picked the right one. 🙂

[Reeza · Accepted solution]

Close both the filename and t1 references.

libname t1;
filename xsd clear;

[michaeltro]

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