[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Using SAS to Move Data Between Servers

Published on
9,723 Points
Last Modified:
In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage environment.  For security reasons, our IT partners often do not make it easy for the servers to talk to one another.  So how do we transfer data between servers?  SAS provides a number of solutions. This paper shows ways to use Remote Compute Services, Data Transfer Services, and Remote Library Services with PROCs  and Data steps to move data between servers or process remote data in-place.  Code samples are provided.  All levels of SAS programmers will find the paper useful and it is relevant to SAS Enterprise Guide® users as well.

Let’s define a situation that’s common in financial institutions and probably most other places.  We’re running SAS on a UNIX server but our data file is on a different UNIX server.  This describes a very simple distributed computing environment.  There can be variations on our situation but a common theme is that the analytical software is on one server and the data is on another.

Now here’s the problem we have to solve:  We need a programmatic solution (no manual intervention) that will let our SAS program use the data located on another computer.  Maybe that sounds familiar?  As usual with SAS, there are multiple ways to solve the problem.  Some are more efficient than others in terms of resource usage and clock time, some are more robust than others, but all are probably appropriate for one situation or another.  

The attached paper (Using SAS to Move Data Between Servers.pdf) was presented at the 2011 SAS Global Forum in Las Vegas, April 6th 2011.  It was awarded Honorable Mention in the Best Paper competition for the Data Integration Section.  It begins with some background on how SAS handles distributed computing environments and creates client-server relationships.  From there it explores specific solutions and get into what everyone really wants… code!

  • 2

Author Comment

Yes, I am the author of the pdf.  My name is on the first page and contact information is on the last page.  The introduction is basically some exerpts from the article that I hope will get people to look at the pdf.

Author Comment

I guess it would be better to include the link to the SAS support page instead of attaching a pdf, right?

Featured Post

Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month