Next Steps: Important Considerations for Moving Your Data and Formats into CAS

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. The first consideration that is discussed is the likely change in character encoding from LATIN1 or WLATIN1 to UTF-8 and how to prevent possible truncation of data. Next, the advantages of loading data into CAS in parallel versus serially is discussed. After you load your data, you might see that the size of the loaded table is larger than the source data set. This paper explains how the increase in size affects memory and how to reduce the size of a loaded table. The most effective way to discuss these considerations is to put them in the context of examples that show how to move your SAS data sets and formats to CAS. This paper covers two main examples. The first example shows how to use the CASUTIL procedure to load a data set. The second example illustrates how to move a format catalog to CAS by using the CNTLOUT= and CNTLIN= options in the FORMAT procedure statement. This example also shows how to save the format so that the format is available for subsequent CAS sessions.

Presenter: Kevin Russell, SAS
Session ID: 4546
Topic: Programming
Industry: Non-Industry Specific
Audience: IT, SAS Administrator, Programmer
Skill Level: Novice

Additional resources
View Proceedings –
Resource Hub for Data Professionals –

Learn more about SAS Software
Free SAS Online Training –
Contact SAS® –


SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF





ABOUT SAS

SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.



CONNECT WITH SAS
SAS ►
SAS Customer Support ►
SAS Communities ►
SAS Analytics Explorers ►
Facebook ►
Twitter ►
LinkedIn ►
Blogs ►
RSS ►

Programming,SAS Cloud Analytic Services (CAS),IT,SAS Administrator,Programmer,moving your data and formats to cas,moving your data to cas,moving your formats to cas,sas data to cas,sas formats to cas,cas,cloud analytic services,sas cloud analytic services,SAS CAS,sas,sas global forum,sas global forum 2020,sas technology,virtual sas global forum,virtual sas global forum 2020,