BookmarkSubscribeRSS Feed
SachinKM
Fluorite | Level 6

Hi all,

 

Our SAS environment is moving from windows to linux.

 

Data set size: 1 TB

 

Need your suggestions.

 

Thanks,

Sachin Mahabale

7 REPLIES 7
Kurt_Bremser
Super User

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.

SASKiwi
PROC Star

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.

andreas_lds
Jade | Level 19

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.

Kurt_Bremser
Super User

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 1245 views
  • 3 likes
  • 4 in conversation