Proc Copy efficiency

Reply
N/A
Posts: 0

Proc Copy efficiency

Hi,

Task: I want to copy all SAS datasets/files/catelog from one library/view to another library.
Solution:
PROC COPY IN=OLD OUT=NEW;
RUN;

The performance is extremely slow if source is XML view. CPU usage is fine, around 30-40%, but memory usage up to 2.4G, and SAS prompts error message and shut down system. I had to stop it, and used DATA STEP instead.

Question: why? how to solve it or not use PROC COPY in XML view at all?

Thanks in advance!
David
SAS Super FREQ
Posts: 8,716

Re: Proc Copy efficiency

Hi,
This really is a question for Tech Support, as they can go directly to the XML engine support folks to determine whether this is something unique that you are experiencing with your particular data or not.

Here are some resources and links that may be relevant to your question:
http://support.sas.com/techsup/unotes/SN/007/007300.html
http://support.sas.com/techsup/unotes/SN/009/009231.html
http://support.sas.com/techsup/unotes/SN/002/002897.html

http://support.sas.com/rnd/base/index-xml-resources.html (click on XML and XML Engine FAQ)
cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 289 views
  • 0 likes
  • 2 in conversation