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;
Close both the filename and t1 references.
libname t1;
filename xsd clear;
you picked the right one. 🙂
Close both the filename and t1 references.
libname t1;
filename xsd clear;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.