If you're a SAS programmer who now uses SAS Viya and CAS, it's worth your time to optimize your existing programs to take advantage of the new environment. This post is a continuation of my SAS Global Forum 2020 paper Best Practices for Converting SAS® Code to Leverage SAS® Cloud
Author
Is there programmatic way to reduce memory requirements of a CAS table in SAS® Viya®? Yes! SAS' Steven Sober shows you how.
Someone asked SAS' Steven Sober if the PROC SQL example noted first in this post could be refactored into PROC FedSQL so it could run faster by leveraging SAS Viya’s in-memory engine CAS? Yes. Here's how.
In this post, you'll learn how to parallel load and compress a SAS® Cloud Analytic Services (CAS) Table in one pass of the CAS table.
The SAS DATA Step's DESCENDING option on BY variables quickly reveals a data set's largest value.
Prior to distributed DATA Step, DATA Step programmers never had to think about achieving repeatable results because DATA Step ran single-threaded and the source SAS7BDAT dataset was stored on disk. But if you need to obtain repeatable results in DATA Step code that runs distributed in CAS, this post provides a workaround that you'll want to keep handy.
To reference CAS tables using a one-level name we will issue two statements that alter which libref houses the tables referenced as one-level names.
DESCENDING BY Variables in DATA Step Code that Runs Distributed in SAS Viya
SAS Viya provides a robust, scalable, cloud-ready, distributed runtime engine. This engine is driven by CAS (Cloud Analytic Services), providing fast processing for many data management techniques that run distributive, i.e. using all threads on all defined compute nodes. Note: SAS Viya 3.5+ now supports the data set option APPEND=YES.
Editor’s note: This is the third in a series of articles to help current SAS programmers add SAS Viya to their analytics skillset. In this post, Advisory Solutions Architect Steven Sober explores how to accomplish distributed data management using SAS Viya. Read additional posts in the series. In my last article I
Editor’s note: This is the second in a series of articles to help current SAS programmers add SAS Viya to their analytics skillset. In this post, Advisory Solutions Architect Steven Sober explores how to accomplish distributed data management using SAS Viya. Read additional posts in the series. This article in the SAS