Renaming a dataset during a proc copy

[MeganE]

Hi,

I need to move a dataset from one libname to another, but i don't want to use a data/set statement because they can be large and i have no reason to read the observations.

But i want to rename the dataset in the new location.  I was using proc copy until the rename issue came up, and i can't find anything online that shows how to do that.

proc copy in=kcurr out=knew;
    select k4_29jun16;
run;

I want to rename it to just K4 in the knew location.

Thanks,

Megan

[MeganE · Accepted solution]

Well, i have this working.  Anyone know how to get it all done in one step though instead of two?

proc copy in=kcurr out=knew;
    select &k4.;
run;
proc datasets library=knew;
    change &k4.=k4;
run;
quit;

[Reeza]

Ome suggestion would be that you can use proc datasets to copy as well as rename. 

Another, which I would test for speed, is to use PROC Append, it uses a block copy method as well and doesn't require the base data to be pre-existing. Not sure if it's as fast as proc copy though. 

[Ksharp]

you could try. But I don't know if it could work:

proc datasets library=kcurr ;

   change &k4.=k4;

run;

   copy out=knew;
run;
quit;

[andreas_lds]

Use proc datasets and "change"-statement to rename the dataset after/before it is copied. Unfortunately proc copy has no rename option.

Well, i am to slow today 😐