topic Re: PROC COPY efficiency in Mathematical Optimization, Discrete-Event Simulation, and OR

PROC COPY efficiency

deleted_user — Thu, 13 Sep 2007 03:22:35 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 almost 100% and took > 30 min to copy 7M files. 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

Matthew_Galati — Thu, 13 Sep 2007 15:32:15 GMT

Is this question related to SAS/OR or Optimization?

Re: PROC COPY efficiency

deleted_user — Fri, 14 Sep 2007 15:59:03 GMT

I see, this forum is for SAS/OR. Sorry.