05-30-2016 05:38 AM
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;
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.
05-31-2016 11:27 AM
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).