SAS SPD Datasets Migration

Reply
Contributor
Posts: 22

SAS SPD Datasets Migration

Hi,

 

One of our projects running in SAS is getting migrated fromUNIX 7.1 to Linux. The entire data is in SPD datasets.  I think these datasets can not be migrated as other sas datasets or catalogs.  

 

What are the available ways in which this can be acheived.

 

Thanks,

 

Valued Guide
Posts: 533

Re: SAS SPD Datasets Migration

Posted in reply to vijayanand

Hi @vijayanand,

 

The one time I had this task at hand I used SAS/Connect to pump the data from one environment to the other. Proc download takes care of all translations that are needed, including index creation.

 

Performance may be a challenge if you have really large tables (which you probably do). To address that I used the programming technique called MPConnect (some good examples in this forum and the SAS Knowledge Base) to create multiple parallel download stream so I could download multiple tables in one go. And some of the larger tables were transferred in parallel chunks based on timestamp ranges. This was especially beneficial as it turned out that a single download would not saturate our network connection. So performance scaled up nicely.

 

Hope this helps,

-- Jan.

Super User
Posts: 10,249

Re: SAS SPD Datasets Migration

Posted in reply to vijayanand

Alternatively, use proc cport, sftp, and proc cimport.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 37 views
  • 0 likes
  • 3 in conversation