Backup dataset to another server path

[Alex91]

Hello there.

I have a task to backup some datasets like .sas7bdat into some local directory.

Now its needed to backup datasets to another server (test environment) from prod server. How i can mount local path from test server?

Here is the macro variables with current path as /sas_work/backup/  :

%global OUTPUT_LIBNAME STATUS_TABLE OUTPUT_PATH;

%let OUTPUT_LIBNAME=output;
%let STATUS_TABLE=output.status_table;
%let OUTPUT_PATH=/sas_work/backup/;

[Kurt_Bremser]

Mounting a resource on a server (at least a UNIX server) requires superuser permissions, so have your server admin do it.

Or use a simpler tool (sftp) to copy the files. That only needs a user that can write to the target directory.

[Alex91]

Thanks, KurtBremser!

Does that mean i backup my tables in current server and then using sftp access copy them to an another server, right?

[Patrick]

You don't need a separate copy on the source side. SFTP Put/Get will copy files and leave the source unchanged. 

If you've got SAS/Connect installed then using proc download/upload would be another option.

But: In many organisations Prod is separated from Test and Dev so may be there are some barriers which you can't that easily overcome.

[Kurt_Bremser]

---

@Alex91 wrote:

Thanks, KurtBremser!

Does that mean i backup my tables in current server and then using sftp access copy them to an another server, right?

---

No, you just copy the .sas7bdat files to the other server, from the current location.