topic Re: Renaming a dataset during a proc copy in SAS Programming

Renaming a dataset during a proc copy

MeganE — Thu, 30 Jun 2016 13:46:45 GMT

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

Re: Renaming a dataset during a proc copy

MeganE — Thu, 30 Jun 2016 13:50:31 GMT

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;

Betreff: Renaming a dataset during a proc copy

andreas_lds — Thu, 30 Jun 2016 13:53:20 GMT

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 😐

Re: Renaming a dataset during a proc copy

Reeza — Thu, 30 Jun 2016 13:58:49 GMT

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.

Re: Renaming a dataset during a proc copy

Ksharp — Fri, 01 Jul 2016 01:54:13 GMT

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;