Hi All,
I have a requirement to convert a ODM xml file to sas dataset. i have used below method to do that, but the execution time is more as it is a 25MB file. Is there any way to do it faster.
filename NHL "/path/ODM.xml";
filename map "/path/odm_map.map";
libname NHL xmlv2 xmlmap=map;
proc copy in=nhl out=work;
run;
ODM.xml is a 25 mb file so when i try to copy those datasets present in NHL to work library, it's taking allmost 10 min, is there any way to reduce the execution time.
Thanks& regards,
Sandeep Reddy
First thing would be to check if the path to the source file is on a network. You may be getting a bottleneck in network performance and might run faster when the data is local to the machine running SAS (SAS server or your computer if local install).
hi , did the problem resolve ,am facing the same issue now
copy from XML engine to SAS is taking huge time
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.