SAS expertise delivered to your desktop -- on-demand and free!

Join Now

Accessing and Manipulating Data in SAS Viya

by SAS Employee D_Dunlap on ‎07-10-2017 02:22 PM - edited Wednesday by SAS Employee john_bauman (2,160 Views)

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.  

Watch the webinar


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:

  • Connect to the platform using SAS Cloud Analytic Services.
  • Investigate the contents of a CAS lib.
  • Load SAS data into memory on the CAS server.
  • Save CAS in-memory data into a .SASHDAT file.
  • Manipulate the data in memory using the DATA step.

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:

  • Read more in our documentation here
  • Apply for a 14 day free trial of SAS Visual Analytics on SAS Viya here
  • Check out our free video tutorial library here (Type Visual Analytics 8.1 in the search field).



­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



Recommended Resources


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.