topic Re: Copying data from XML library to other permanent library in SAS Programming

Copying data from XML library to other permanent library

Sandyz — Mon, 30 May 2016 09:38:49 GMT

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

Re: Copying data from XML library to other permanent library

ballardw — Tue, 31 May 2016 15:27:49 GMT

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

Re: Copying data from XML library to other permanent library

Saranya_Sub — Thu, 14 May 2020 18:42:35 GMT

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

copy from XML engine to SAS is taking huge time