topic Re: How to transfer sas datasets from windows server to linux server in New SAS User

How to transfer sas datasets from windows server to linux server

SachinKM — Thu, 13 Jun 2019 06:14:10 GMT

Hi all,

Our SAS environment is moving from windows to linux.

Data set size: 1 TB

Need your suggestions.

Thanks,

Sachin Mahabale

Re: How to transfer sas datasets from windows server to linux server

Kurt_Bremser — Thu, 13 Jun 2019 06:59:00 GMT

Since the hardware will be the same (Intel or Intel-based), byte order won't change, so you should be fine with just copying your datasets and SQL views.

Data step views and catalogs should be tested before migration; you might have to use cport/cimport for this.

Re: How to transfer sas datasets from windows server to linux server

SASKiwi — Thu, 13 Jun 2019 07:03:16 GMT

If you have SAS/CONNECT on both servers then PROC UPLOAD run on the target server is another way of transferring both SAS datasets and other SAS file types like catalogs.

Re: How to transfer sas datasets from windows server to linux server

andreas_lds — Thu, 13 Jun 2019 07:14:25 GMT

You can use the datasets created on windows, but SAS will use CEDA (cross environment data access) slowing down all jobs. Using SAS/Connect as mentioned by @SASKiwi is the best way to convert the datasets.

Re: How to transfer sas datasets from windows server to linux server

Kurt_Bremser — Thu, 13 Jun 2019 07:16:15 GMT

Regarding performance: on any current LAN (1 Gbit), you should achieve a consistent throughput of 50MB/s or above (with sftp), which translates to roughly 20 seconds for a GB, or ~6 hours for the whole job.

Re: How to transfer sas datasets from windows server to linux server

SachinKM — Thu, 13 Jun 2019 10:09:06 GMT

Thanks SASKiwi

Re: How to transfer sas datasets from windows server to linux server

SachinKM — Thu, 13 Jun 2019 10:09:34 GMT

Thanks andreas_Ids

Re: How to transfer sas datasets from windows server to linux server

SachinKM — Thu, 13 Jun 2019 10:10:06 GMT

Thanks KurtBremser