Copying data from XML library to other permanent library

Reply
New Contributor
Posts: 4

Copying data from XML library to other permanent library

 

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

Super User
Posts: 11,343

Re: Copying data from XML library to other permanent library

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

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 187 views
  • 0 likes
  • 2 in conversation