topic Re: Multiple server conexion end exchange data between them in Administration and Deployment

Multiple server conexion end exchange data between them

MarianaG — Tue, 13 Oct 2020 10:16:43 GMT

Hello guys,

I would like to understand if its possible to connect to more than one server at the same time for example, we have our principal server SASMain and there is another one SAS_Name and I would like to make some operations with data from both. Is that possible? The only way I see is import the data from both to SAS Local and make the operations there, but if there are big amounts of data this is not possible.

Thanks a lot.

Re: Multiple server conexion end exchange data between them

JuanS_OCS — Tue, 13 Oct 2020 10:21:26 GMT

Hi @MarianaG ,

it is possible with SAS/CONNECT sessions, when you want to run SAS code in the other servers besides the one you are connected to. If it is about just data from other servers, you don't need to bring data from several locations to SAS local, you only need to bring that to one of the SAS servers, the one you are connected to. File shares and mounts are great for that.

Does it help?

Best regards,

Juan

Re: Multiple server conexion end exchange data between them

Kurt_Bremser — Tue, 13 Oct 2020 10:29:32 GMT

If these SAS application servers work on the same physical machine, then you can define your libraries to the paths needed with LIBNAME statements, and do all the work from one server session.

Re: Multiple server conexion end exchange data between them

joeFurbee — Wed, 28 Oct 2020 13:50:13 GMT

Hi @MarianaG,

I wanted to check if the guidance from @JuanS_OCS and @Kurt_Bremser answered your inquiry? If so, can we mark this thread resolved? If not, let us know, so we can continue the conversation.

Also, I'm moving this thread to the Admin community.

Thanks,

Joe

Re: Multiple server conexion end exchange data between them

SASKiwi — Wed, 28 Oct 2020 18:58:37 GMT

Even if the two SAS servers are on different physical servers as long as they run on the same OS, folder-sharing of SAS data is easy to set up.