Multiple server conexion end exchange data between them

[MarianaG]

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.

[JuanS_OCS]

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

[Kurt_Bremser]

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.

[SASKiwi]

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.

[joeFurbee]

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