Using SAS to Move Data Between Servers

Published on
9,572 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Join & Write a Comment

This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month