We’re smarter together. Learn from this collection of community knowledge and add your expertise.

Ask the Expert: Accessing and Manipulating Data in SAS Viya (Q&A)

by SAS Employee D_Dunlap on ‎07-10-2017 02:22 PM - edited on ‎07-12-2017 10:28 AM by Community Manager (2,098 Views)

Thank you for attending the Ask the Expert Series on the topic Accessing and Manipulating Data in SAS Viya!   Please find the answers to your wonderful questions.  I hope you enjoyed the presenation.  We look forward to sharing more exciting news about SAS Viya in the future!


If you missed this webinar don't worry, you can see it on demand at your convenience.  



Q&A SAS Ask the Expert: Accessing and Manipulating Data in SAS Viya


Q: ­Can you share snippets with others?­ A: ­Yes, you can share snippets. ­­Take a look at ­ http://go.documentation.sas.com/?cdcId=vdmmlcdc&cdcVersion=8.11&docsetId=webeditorug&docsetTarget=p1...

Q: ­SAS isn't a full fledged database. How easy is it to move the manipulated data back into SQL server in Azure?­

A: 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.


Q: ­Can you create a SASHDAT file in a single machine SAS Viya session?

A: ­ 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.

Q: So can we build visual analytics reports from SAS Viya?

A:  Yes, you can build visual analytic reports with SAS Visual Analytics 8.1 on SAS Viya.  To learn more about this exciting new offering:



Q: ­What if you want to process the data using a SAS procedure with BY groups- can you still do that with a Caslib?­

A: 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 at: http://go.documentation.sas.com/?cdcId=vdmmlcdc&cdcVersion=8.11&docsetId=proc&docsetTarget=titlepage...


Q: ­Contrast CAS to LASR in terms of memory usage and failover issues­

A:  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 at: http://go.documentation.sas.com/?docsetId=whatsdiff&docsetVersion=3.2&docsetTarget=p1gfaswb875orbn1x...


Your turn
Sign In!

Want to write an article? Sign in with your profile.