BookmarkSubscribeRSS Feed

Important Considerations for Moving Your Data and Formats into CAS

Started ‎07-07-2020 by
Modified ‎07-07-2020 by
Views 2,000

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

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

SAS AI and Machine Learning Courses

The rapid growth of AI technologies is driving an AI skills gap and demand for AI talent. Ready to grow your AI literacy? SAS offers free ways to get started for beginners, business leaders, and analytics professionals of all skill levels. Your future self will thank you.

Get started

Article Tags