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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.