Did you miss the Ask the Expert session on getting data into SAS® Viya®? Not to worry, you can catch it on-demand at your leisure.
Join SAS expert Rex Pruitt as he guides you through a discussion on the ease of data access, automation of the data load process and engineering the best solution for your SAS® Viya® environment. During this webinar, you will learn:
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.
Can data be pulled from Sybase in Viya? My org has not yet converted to a modern database, and we are also considering moving from SAS 9.4 to Viya, but will still need to access Sybase from Viya for a while?
For autoload, does SAS Viya support data preparation scheduling just like in Data Integration Studio where we define a flow?
Is there some sort of documentation to access ETL and SAS EG when scheduling a program?
Is there an auto refresh interval available for data that resides in an RDBMS that is mapped to a CASLIB, or does an ETL job need to load and refresh the in-memory data using a scheduler?
How can we schedule a program to run on SAS Studio?
I’m new to Viya (currently in the process of configuring servers; coming from a SAS 9.4 environment). We are loading data directly from Oracle to CAS via Environment Manager scheduled jobs. I have my library set up with a connection to Oracle. I will be exposing some of my data to the public, while most will be internal only. Would you recommend loading all of the tables into the same CAS library and handle security via authorizations, or would you recommend splitting the data into multiple libraries, with each library being secured?
Recommended Resources
Viya 3.5: CAS loading supported file types and platforms
How to create a path-based CASLIB to SASWORK for speedier analysis with SAS Viya
Six Easy Ways to Import Local SAS Data Sets into CAS (SAS Viya 3.5)
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Your Home for Learning SAS
SAS Academic Software
SAS Learning Report Newsletter
SAS Tech Report Newsletter