Desktop productivity for business analysts and programmers

Working with 2 SASApp Servers Simultaneously

Reply
Occasional Contributor
Posts: 8

Working with 2 SASApp Servers Simultaneously

I am using SAS EG 5.1 to SQL query against a teradata server.  The final product is a SAS dataset hosted on the SASApp Server1 under SASUSER.

I have access to another SAS Server2 that has more powerful hardware for processing huge data sets and would like to MOVE the SAS dataset from Server1 to Server2 to manipulate further.

Is there a way to directly transfer the dataset to Server2 without using "download data set to PC" and then subsequently "upload data set to SAS Server" functionality?

Thank you

Super User
Posts: 3,233

Re: Working with 2 SASApp Servers Simultaneously

Do both servers have the same operating system and can you "see" the Server1 SAS data folders from Server2?

If so you could just assign a LIBNAME on Server 2 from your Server 2 EG connection pointing back at Server 1 to copy the data over:

libname S1SUSER '\\Server1\SASUsers\Username'; <== Windows directory location - change to match yours.

Occasional Contributor
Posts: 8

Re: Working with 2 SASApp Servers Simultaneously

Server 1 is SAS operating using Teradata, I am unsure of Server 2's configuration.

When I am connected to Server 2, my server list displays only Local and SASApp, I believe (in my limited experience) that this means I cannot "see" the Server1 SAS data folders from Server2 per your question.

Thank You

Super User
Posts: 3,233

Re: Working with 2 SASApp Servers Simultaneously

When I said "see" the Server1 SAS data folders from Server2 I meant this from an operating system perspective not inside SAS.

For example, where I work all of our SAS Servers work under the Windows operating system so I can go into Windows Explorer on my desktop and navigate to all of the SAS server data folders and list all of the SAS datasets stored.

Since your understanding of these concepts appears a little confused (Teradata is a database, not an operating system that SAS would run in) I suggest you ask one of your IT administrators what operating system your SAS servers run under and whether you are able to access the data folders on one SAS server from the other from an operating system perspective.

Super User
Posts: 5,383

Re: Working with 2 SASApp Servers Simultaneously

And if you don't have for some reason the rights to direct libname across servers, you could investigate if SAS/CONNECT is licensed. Then you could use PROC UPLOAD to move the data.

I assume that you can't access Teradata from Server2?

Data never sleeps
Occasional Contributor
Posts: 8

Re: Working with 2 SASApp Servers Simultaneously

Are you referring to SAS/Connect aka prodnum15 aka saszrlnk?

I DO have it licensed on my Local server, but I do NOT have it licensed on my SASApp servers; will this work?  I will investigate PROC UPLOAD further on my end.

Lastly, yes, I believe I can't access Teradata from Server2; however this may be incorrect.  I will follow up with our research analytics admins to see if it is possible.

Thank You

Valued Guide
Posts: 3,208

Re: Working with 2 SASApp Servers Simultaneously

That is looking a very weird installation you are having. Teradata is designed for big data (that is in the name). It is sometimes necessary to copy parts to a local SAS environment. But using the SASuser for that is not normal and should be avoided.

Could be your analytics staff is assuming data is never going to SAS and all work is done by Teradata. By that also did the implementation that way with a less powerfull machine.

You can use several appservers to the same machine with good reasons. One is for example using different encodings. You can use one for utf8 and another for latin1 with that.

Parallel processing has become a standard feature with Eg 5.1. That is no reason anymore.

Having several appservers on the same machine you can easily share the data between those.

Using SAS connect is one of the best for sharing data. It can also use RLS services. When you are going to do that do not use the parallel processing with Eguide for setting up the connection (asynchronous mode).  By that you can see all things coming back in your Eguide session and you can give follow up processings. The disadvantage is that it will cause networktraffic and IO for an additional (big?) copy. 

You have to contact you analytics admins.        

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 6 replies
  • 423 views
  • 6 likes
  • 4 in conversation