topic Re: How to move datasets in SAS Viya? in SAS Programming

How to move datasets in SAS Viya?

JianShen — Tue, 12 May 2020 13:14:40 GMT

Hi all,

For a project, I have to clean up a cas library in Viya. Specifically, the datasets in the public cas library have to be moved to another cas library that has restrictions. Since there are a lot of datasets (30+), I was looking for ways to move multiple datasets at the same time, as moving it set by set would take a lot of time.

Currently, I've looked at the following options:

- proc datasets

- proc copy

I've noticed that these options only work if the datasets are already loaded into memory. If the datasets are unloaded, the procs return a message saying the library is empty.

As such, I was wondering if there is a way to move the unloaded (but saved) datasets to a different library.

Best,

Jian

Re: How to move datasets in SAS Viya?

Carus — Tue, 12 May 2020 15:38:00 GMT

If the library you are moving the datasets is another path or dnfs library, then you might try using a tool like winscp to copy and paste the .sashdat files from the public library into the directory of the other library.

If you look at the details for the public caslib, you can find where it exists on the server:

Re: How to move datasets in SAS Viya?

JianShen — Wed, 13 May 2020 07:48:58 GMT

Hi Carus,

Thank you for the quick reply! Unfortunately, I do not have access to the server, so I'm afraid that I cannot use that option.