Proc Copy efficiency

deleted_user — Fri, 14 Sep 2007 16:00:24 GMT

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

Re: Proc Copy efficiency

Cynthia_sas — Fri, 14 Sep 2007 16:28:40 GMT

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

topic Proc Copy efficiency in SAS Health and Life Sciences

Proc Copy efficiency

Re: Proc Copy efficiency