topic Re: Backup dataset to another server path in SAS Programming

Backup dataset to another server path

Alex91 — Fri, 20 Mar 2020 14:30:41 GMT

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/;

Re: Backup dataset to another server path

Kurt_Bremser — Fri, 20 Mar 2020 14:48:05 GMT

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.

Re: Backup dataset to another server path

Alex91 — Mon, 23 Mar 2020 09:21:22 GMT

Thanks, KurtBremser!

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

Re: Backup dataset to another server path

Patrick — Mon, 23 Mar 2020 09:34:59 GMT

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.

Re: Backup dataset to another server path

Kurt_Bremser — Mon, 23 Mar 2020 10:13:32 GMT

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