Move dataset from one library to other

[David_Billa]

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?

[PaigeMiller]

PROC COPY

[David_Billa]

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

[PaigeMiller]

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?

[David_Billa]

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?

[SASKiwi]

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.

[Patrick]

---

@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.

[David_Billa]

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

[Patrick · Accepted solution]

---

@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.