topic Re: rename data set in work library into data set in permanent library in SAS Programming

rename data set in work library into data set in permanent library

Ronein — Tue, 20 Jul 2021 08:28:13 GMT

Hello

This code rename data set A (in library Work) to data set B (in library work).

I want to rename data set A (in data set work) into data set B in library RRR.

What is the way to do it please?

proc datasets library=WORK;
   change A=B;
run;

Re: rename data set in work library into data set in permanent library

Kurt_Bremser — Tue, 20 Jul 2021 08:39:59 GMT

Data step.

Renaming might only work if

it is done in the operating system (external command, XCMD required)
the permanent library is on the same physical volume as WORK; otherwise, the mv command (if on UNIX) will do a copy followed by delete

Make sure that options (COMPRESS!) are replicated.

Re: rename data set in work library into data set in permanent library

ChrisNZ — Tue, 20 Jul 2021 08:58:21 GMT

You can't. Renaming a file works if the file doesn't move (I know @Kurt_Bremser, the mv command thinks otherwise :).

Here the data set is going to a different library, so you must move (or copy) it, not rename it.

Re: rename data set in work library into data set in permanent library

Astounding — Tue, 20 Jul 2021 09:49:29 GMT

Rather than using a DATA step, a faster method would be to use PROC COPY.

Re: rename data set in work library into data set in permanent library

Ronein — Tue, 20 Jul 2021 10:41:50 GMT

Can you show the full code please with PROC COPY that rename data set work.A into data set RRR.A ?

Re: rename data set in work library into data set in permanent library

Kurt_Bremser — Tue, 20 Jul 2021 10:45:39 GMT

I will not insult your intelligence by spoon-feeding you this very-easy-to-use procedure.

Just find your way from the documentation.

If you run into an unsolvable problem, post your log.

Re: rename data set in work library into data set in permanent library

PaigeMiller — Tue, 20 Jul 2021 11:17:13 GMT

It's not a rename, it's not a move, it's a copy. Once you do this, you now have two exact identical copies of the data set, one in library WORK and one in library RRR. The documentation is here.

proc copy in=work out=rrr;
    select a;
run;
quit;