BookmarkSubscribeRSS Feed

Important Considerations for Moving Your Data and Formats into CAS

Started ‎07-07-2020 by
Modified ‎07-07-2020 by
Views 1,756

Now that your SAS® Cloud Analytic Services (CAS) environment is available, you are ready to start moving your SAS data sets and formats from SAS® 9.4 to CAS. However, there are a number of considerations to think about before, during, and after you move your data and formats. This paper, written for the beginner CAS user, focuses on three main considerations in the context of examples that illustrate how to load SAS data sets and formats. These considerations include character encoding, parallel data loading, and finally the CAS table size considerations. All is covered in the video below by SAS' Kevin Russell @saskir.



Video highlights

0:36 - Three main consideration for the paper

1:14 - First consideration:  character encoding

6:45 - Second consideration:  parallel loading

7:05 - Serial data transfer explained

7:54 - Parallel data transfer explained

10:16 - Parallel vs serial load comparison

11:18 - Third consideration:  size of CAS table vs the source data set

12:06 - Data structure alignment

12:51 -  VARCHAR variable type

15:55 -  Putting it all together with an example



Read the Paper


Related resources

SAS 9 to SAS Viya Data migration -  SAS Support site on migrating data from SAS 9 to SAS Viya

Planning for Migration from SAS 9.4 to SAS Viya - 2019 SASGF paper

Migrating from SAS 9.4 to SAS Viya - 2020 SASGF video

Version history
Last update:
‎07-07-2020 01:42 PM
Updated by:



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags