BookmarkSubscribeRSS Feed

Important Considerations for Moving Your Data and Formats into CAS

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

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:
Contributors

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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