topic Re: Copy a data table to Local lib from Server lib in SAS Enterprise Guide

Copy a data table to Local lib from Server lib

Harveyyang1 — Thu, 19 Sep 2019 08:22:44 GMT

As subject,

With SAS EG, I am accessed to two server, first is SASapp which is connected to a database that I can read data, and calculate it.

After I finish the work, I want to use that data table at second server (Local server), but I can not get the data table when I switch to the local server. The only way now is export the data table from SASapp server to my desktop. Then, switch to local server and import the data.

I would like to ask that is there any solution that I can copy the data table from SASapp server to Local server work lib (or any other lib I can create) by code. If so, I don't need to export data then import it.

Thank you guys, my poor English may make my article be difficult to understand.

Re: Copy a data table to Local lib from Server lib

Kurt_Bremser — Thu, 19 Sep 2019 08:34:24 GMT

You can use the Copy Files task to copy the .sas7bdat file to your desktop.

Re: Copy a data table to Local lib from Server lib

Harveyyang1 — Thu, 19 Sep 2019 08:53:20 GMT

Thanks for the reply, if there is any other way that I do not need to export the file to my desktop?

Re: Copy a data table to Local lib from Server lib

Kurt_Bremser — Thu, 19 Sep 2019 09:50:01 GMT

@Harveyyang1 wrote:

Thanks for the reply, if there is any other way that I do not need to export the file to my desktop?

If both your desktop and server SAS have SAS/CONNECT licensed, you could use that.

Or you can (if XCMD is set) use any external (s)ftp utility to copy files.

Or you define a network share on the directory of your server library, so you can mount it on your desktop and define a similar libref there.

Re: Copy a data table to Local lib from Server lib

ChrisHemedinger — Thu, 19 Sep 2019 13:07:40 GMT

Actually, there is a special task for this. It's the Download Data Set from Server task, in the Tasks->Data area (or use task browser to search "Download". It will copy any data set (even from a database) and download into a local SAS7BDAT file. You can then assign a library in your Local server to read it.

There is an Upload Data Set from PC task too, which copies a SAS7BDAT file from your PC to any library on your remote server.

Chris