topic Re: Move dataset from one library to other in SAS Data Management

Move dataset from one library to other

David_Billa — Mon, 29 Jun 2020 18:57:00 GMT

Is there a way that we can move the dataset from one library to other library?
In one of my DI job, I want to change the library of the source dataset. Any help?

Re: Move dataset from one library to other

PaigeMiller — Mon, 29 Jun 2020 18:59:17 GMT

PROC COPY

Re: Move dataset from one library to other

David_Billa — Mon, 29 Jun 2020 19:06:39 GMT

If I do PROC COPY via SAS EG, it will update the library in the respective
dataset which was being used in the job?

Re: Move dataset from one library to other

PaigeMiller — Mon, 29 Jun 2020 19:19:13 GMT

I don't understand the question.

PROC COPY takes a dataset(s) in one library and makes a copy in the other library. Is that what you want?

Re: Move dataset from one library to other

David_Billa — Mon, 29 Jun 2020 19:27:39 GMT

Yes.

I would like to know if I do proc copy from SAS EG, it will change the
library of the respective dataset which was being used in DI studio job
without updating metadata?

Re: Move dataset from one library to other

SASKiwi — Mon, 29 Jun 2020 19:39:55 GMT

Correct. A PROC COPY by itself will not change library metadata. If you want the copied dataset registered in metadata in the library it was copied to then you have to do that separately.

Re: Move dataset from one library to other

Patrick — Tue, 30 Jun 2020 00:54:00 GMT

@David_Billa wrote:
Is there a way that we can move the dataset from one library to other library?
In one of my DI job, I want to change the library of the source dataset. Any help?

In DIS assign the table metadata to the new library.

Redeploy all impacted jobs (impact/reverse impact analysis on the table will give you the list of jobs).

With EG use Proc Copy or Proc Datasets/Copy to also move the physical data. Consider using the MOVE option in the Proc if you don't want to just replicate (copy) the data but also remove it from the source.

Re: Move dataset from one library to other

David_Billa — Tue, 30 Jun 2020 02:52:39 GMT

In DIS, how to assign the table metadata to the new library?

Re: Move dataset from one library to other

Patrick — Tue, 30 Jun 2020 06:27:54 GMT

@David_Billa wrote:
In DIS, how to assign the table metadata to the new library?

The new library must also be defined in SAS Metadata. Then open the the table metadata properties where you can change the assigned library. And once done also move the table metadata object to the appropriate metadata folder.