Working With SAS® Viya® Data - Q&A, Slides, and On-Demand Recording
Watch this Ask the Expert session to explore the ways in which Viya turns your raw data resources into valuable assets.
You will learn:
- How to connect and use cloud data sources.
- Simple ways to continue to use on-premises legacy data.
- New methods to take advantage of the Viya massively parallel processing capabilities.
The questions from the Q&A segment held at the end of the webinar are listed below and the slides from the webinar are attached.
Q&A
What can Viya do with Generative AI and my data?
The first thing I would say is that we can make models better with generative AI for data, aka. synthetic data. That's a type of generative AI where we can create some synthetic data that’s hard to find in the real world, and then we can use that with in our predictive analytics and modeling to make those models better. The second thing is we can enable large language models, the API call. Within the SAS Studio flows that I was talking about earlier, there's a custom step. It's available on the public GitHub. If you go look for it, that custom step will allow you to download. You can install that, and then in your environment you can call the API from that custom step, call that LLM. We don't have a lot of customers doing that today, but we'll find some more use cases and examples of how that adds value as they do that. Also, I should mention that based on where you are, there's legislation in place that says you must practice trustworthy AI governance and business processes. In Canada, we have what's called the AIDA see The Artificial Intelligence and Data Act (AIDA) – Companion document (canada.ca). I'm sure wherever you are in the world, there's similar legislation. So, we've taken that to heart, and we've decided we want to become a leader in trustworthy AI. We ran a seminar on that recently with Reggie Townsend, who's one of our leaders in the AI space. He's also an advisor to the president the United States on that topic. See these links for more info:
https://www.youtube.com/watch?v=UfntNaxOlX0
https://www.youtube.com/watch?v=EWGDevmF3Yk
https://www.youtube.com/watch?v=MmzsCFQmanU
https://www.sas.com/en_ca/events/2023/q1/responsible-trustworthy-ai.html
Should I be worried about my data on the cloud?
Usually, cloud security is stronger than what you have in place on premises, in a general statement. Also, cloud security can rapidly evolve to new threats and stay on top of those new threats very quickly. Maybe you're in an organization where you have top notch security, so maybe that's not the case. In the end, I would say security is strong. But you should know your organization's policies, be smart on what you put in the cloud, and what the access control security policies you put in place there are. And finally, there are some organizations that have top secret implementations, like if you're RCMP or FBI. There are implementations that aren't connected to even the Internet. That's a different conversation though. But what my answer is that you shouldn't be that worried about data on the cloud.
What should I do with everything I have done on SAS 9?
I think you first want to start with just lift and shift to Viya, get it running, analyze what's taking the most time, then optimize where it's the most expensive to run and where you can make the biggest gains. I should say in that example we have with the big bank there, we only changed seven jobs and we got big performance improvements. But if we were to change the next seven jobs, we wouldn't have got it to make a performance improvement. There's diminishing returns. Just focus on the stuff that's costing you the most, improve that. After that you might want to reevaluate how much more time you want to spend on improving performance.
What is CAS?
CAS is the web-based version of SAS and it's the cloud version of SAS. It is architected to run the cloud and takes advantage of the cloud architecture. The objective is to do as much in memory as possible to improve performance.
How do I find local SAS representatives?
If you don’t know your local SAS representatives, start with the “Contact Us” page on the SAS website: https://www.sas.com/en_us/contact.html
How do you suggest clients use SAS Viya? Cost-wise, it’s very expensive.
If they are already SAS customers, then I'd say bigger, faster, stronger, do more with costing less money.
Everyone I know are using PySpark instead of SAS Viya.
There are some recent third-party benchmarks showing SAS Viya greatly outperforms competitors, including the open source options such as PySpark. See https://futurumgroup.com/sas-viya/
I need some hands-on experience with SAS Viya.
Talk to your local SAS representative and find out what they can do for you in terms of getting you a demo Viya environment or a test environment. I know for certain customers we have here we've spun up Viya environments for quick training and learning experiences. That's something we can do.
Most of my friends are telling me Viya is not faster when compared to Base SAS.
Well, we saw in those examples from that large banking customer, it was sometimes 34% faster, sometimes 29 times faster depending. It all depends on what? What the data is, how big the data is, what the code is, whether that code can gain some efficiencies by running all on memory. Sometimes it's 5% faster, sometimes it's 29 times faster. It all depends.
What is the suggested automatic way of scanning existing macros to convert SAS 9 macros/programs to SAS Viya in the most efficient way?
We have a whole set of tools for migrating code, and that's not the topic of today's webinar, but we have toolkits such as the SAS Content Assessment tool that can help you do that. (for an overview see the article at https://communities.sas.com/t5/SAS-Communities-Library/A-first-look-at-Migration-from-SAS-9-4-to-SAS...) I encourage you to talk to your local SAS representative and find out more. We can scan your existing code and see which of those pieces of code are migratable as-is and which need some attention to get them to migrate. But things have been improving so almost everything is easily migratable now and you want to use the tools that we have available to do that.
Does SAS Viya make Enterprise Guide obsolete?
We just announced at SAS Innovate in Las Vegas we are supporting SAS Enterprise Guide in Viya now. You can have Enterprise Guide connecting to SAS 9, Viya 3.5, and Viya 4. In fact, it's great for Enterprise Guide users who don't want to move. This is great if you have a very large investment in EG and the amount of time it would take you to change all those EG jobs in the SAS Studio flows is just prohibitive. In the end, I suggest somehow migrating into SAS studio flows to really take advantage and get the most benefit out of SAS Viya. But I understand that's a big lift, a lot of work for a lot of people. So that's why we just announced we're continuing to support Enterprise Guide and supporting it on Viya.
I am working with data I do not want anybody to see, is this granted in Viya cloud?
Yes, you can control in Viya who's allowed to see your data. There's a whole range of security that you can put on and the administrator will be able to help you with that.
Can SAS Viya query Azure Serverless On-demand pool to query parquet files on Azure Data Lake in place?
Yes, a SAS Viya (CAS) user can ADLS2 parquet data in both serverless and dedicated SQL pools. Users would use Synapse as an intermediary to read the parquet file and then SAS reads Synapse. See the article: SAS Viya and Parquet files – additional features
Recommended Resources
Preparing data with CAS compared to SAS 9 using Data Step.
LIBREFs and CASLIBs in SAS Viya
Moving from SAS®9 to SAS® Viya®
Please see additional resources in the attached slide deck.
Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from other SAS Ask the Expert webinars.
