Hi all,
Our SAS environment is moving from windows to linux.
Data set size: 1 TB
Need your suggestions.
Thanks,
Sachin Mahabale
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.
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.
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.