Using SAS to Move Data Between Servers

d507201Database Marketing Consultant
Published:
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!

Using-SAS-to-Move-Data-Between-S.pdf
0
4,052 Views
d507201Database Marketing Consultant

Comments (2)

d507201Database Marketing Consultant

Author

Commented:
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.
d507201Database Marketing Consultant

Author

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

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.

Get access with a 7-day free trial.
You Belong in the World's Smartest IT Community