Date:         Wed, 1 Nov 2006 18:39:42 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: rename data in a a sequential library

On Tue, 31 Oct 2006 15:36:14 -0800, Yi <eiwenchang@HOTMAIL.COM> wrote:

>Hi,
>
>I have to copy data to a sequential library (tape) and rename the data.
> Since change statement in proc datasets doesn't work, I used to copy
>the data to an temp non-sequential library, rename the data, then copy
>the data to the final sequential library.  Since there are more than
>100 data sets and most of them are big, it took long time to get it
>done.
>
>Is there a more efficient way to do it?  Thanks.

Two ideas ...

1. Forget about PROC DATASETS. Just use DATA steps or SQL to transcribe, as in

   proc sql;
   create table target.first  as select * from source.first ;
   create table target.second as select * from source.second;
   ...
   quit;

You may lose certain metadata however.

2. Use PROC DATASETS a lot. Change all of the names in the source library.
Copy everything to the target library. Change all of the names back to the
orginals in the source library.

This could cause other jobs running at the same time, and using the source
library, to fail.