Did you miss the Ask the Expert session on Accessing and Manipulating Data in SAS Viya? Not to worry, you can catch it on-demand at your leisure.
If you missed this webinar don't worry, you can see it on demand at your convenience.
You may have heard of SAS Viya, a modernization of the SAS platform, but you might not be familiar with how to access and manage your data in SAS Viya.
During this session, you’ll learn how to:
Here are some highlighted questions from the Q&A segment held at the end of the session for ease of reference.
Can you share snippets with others?
Yes, you can share snippets. Take a look here.
SAS isn't a full fledged database. How easy is it to move the manipulated data back into SQL server in Azure?
Currently there is no SQL Server support in SAS Viya in CAS, therefore you would not be able to manipulate the data and move it back into SQL server. Only Hadoop and Teradata are supported.
Can you create a SASHDAT file in a single machine SAS Viya session?
SASHDAT is for distributed Hadoop environments and you can create .SASHDAT files in a single machine environment in SAS Viya. In the demo a single machine environment was used to create the .SASHDAT file.
So can we build visual analytics reports from SAS Viya?
Yes, you can build visual analytic reports with SAS Visual Analytics 8.1 on SAS Viya. To learn more about this exciting new offering:
What if you want to process the data using a SAS procedure with BY groups- can you still do that with a Caslib?
For the SAS procedures that are currently supported in SAS Viya with the CAS server, BY-group processing works as you would expect whether they run “in” CAS or pull data out of CAS with an engine. Which means CAS will group or order the data on the fly and given to multiple threads to process and return. You are not guaranteed the final order based on the BY-groups because the results are returned by the thread that completes process the fastest?
For a list of supported SAS procedures in CAS, please see our documentation here.
Contrast CAS to LASR in terms of memory usage and failover issues
The CAS server is the next step for SAS in the evolution of SAS Analytics high-performance distributed processing. Our documentation does a great job highlight the differences between the CAS server and the SAS LASR Analytics server. Please take a look here.
Want more tips? Be sure to subscribe to the Ask the Expert Community Library to receive follow up Q/A, slides and recordings from other SAS Ask the Expert webinars. From the Ask the Expert Library, just click Subscribe from the orange bar underneath the list of the recent articles.
NOTE: For best results when opening the attached slides, click on the “download” icon.