topic Re: how to copy and rename a spde dataset from lib1 to lib2 with zero observations. in SAS Enterprise Guide

how to copy and rename a spde dataset from lib1 to lib2 with zero observations.

alepage — Fri, 11 Jun 2021 13:15:08 GMT

Hello,

Here's the task I would like to do.

I would like to copy let's say a spde dataset named datasetA , from library sasdata_staging to library sasdata, with zero observation in it and rename it datasetB.

I have started with this code:

options obs=0 msglevel=i;
proc copy in=sasdata_staging out=sasdata;
select datasetA (rename=(datasetB=datasetB));
run;

but I am not sure for the rename possibility with proc copy

Does someone has a suggestion to make

Regards,

Re: how to copy and rename a spde dataset from lib1 to lib2 with zero observations.

Kurt_Bremser — Fri, 11 Jun 2021 13:41:59 GMT

Why so complicated?

data sasdata.datasetb;
set staging.dataseta (obs=0);
run;

sasdata_staging is an invalid name for a SAS library (more than 8 characters).

Re: how to copy and rename a spde dataset from lib1 to lib2 with zero observations.

yabwon — Fri, 11 Jun 2021 13:54:01 GMT

Maybe:

data sasdata.datasetb;
stop;
set staging.dataseta;
run;

B-)