Copying data from XML library to other permanent library

[Sandyz]

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

[ballardw]

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).

[Saranya_Sub]

hi , did the problem resolve ,am facing the same issue now

copy from XML engine to SAS is taking huge time