Watch this Ask the Expert session to learn the new data management capabilities in SAS Viya 2021.x.
Watch the webinar
You’ll learn about the interactive development environment and modern data catalog. We’ll take a close look at SAS Studio and SAS Information Governance. We’ll also cover how to transition from SAS 9 flow builders, such as SAS Enterprise Guide or SAS Data Integration Studio, to SAS Viya 2021.x. You will learn:
- SAS Studio and SAS Information Governance and their features.
- How to search and find data assets within SAS Viya 2021.x.
- How to transition to SAS Studio on SAS Viya 2021.x from SAS Enterprise Guide or SAS Data Integration Studio.
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
Can you please comment on your integration with SingleStore?
We do deliver connectivity to SingleStore (MemSQL) through SAS/ACCESS Interface to MySQL.
Is the information catalog tool part of SAS Viya or is that a separate license?
SAS Information Catalog is delivered on all SAS Viya 4 bundles except SAS Data Science Programing. SAS Information Governance, which adds additional capabilities such as semantic type assignment, data privacy classification, Egeria integration, graphdb backend, is proposed as an addon on SAS Visual Analytics and SAS Visual Statistics, and is included with SAS Visual Machine Learning, SAS Visual Data Science and SAS Visual Data Science Programing.
Does it allow defining a flow before you have the actual data, using metadata?
For now, SAS Viya 4 is not as metadata driven as SAS 9.4. For getting metadata into SAS Information Catalog you must create a discovery agent. Discovery agents are crawlers. You select the library and there is a job there that runs to calculate all the different metrics. See minute 56:30 of the recording.
How is SAS Studio different from Alteryx?
SAS Studio is web based and proposed both SAS coding experience and data pipeline design. We aimed at proposing bot data preparation for analytics for Data Scientists and data integration capabilities for Data Engineers, integrated with all the SAS products like SAS Visual Analytics and SAS Model Studio.
Does this mean Python can open a SAS dataset like Lua does?
Did say no during the session … but that’s almost a “Yes”. You don’t open the dataset, it is moved behind the scene to a data frame.
|
proc lua;
submit;
local dsid = sas.open("sashelp.class")
for row in sas.rows(dsid) do
print(row.name, row.age)
end
sas.close(dsid)
endsubmit;
quit;
|
proc python;
submit;
dfin = SAS.sd2df("sashelp.class")
dfin.head()
endsubmit;
quit;
|
How will you migrate to SAS Viya from actual develops in DI 4.902?
Since June 2021, we are starting to support SAS DI Job migration to SAS Studio Flows. Today, we do support migration to SAS program steps in Flow, and work on adding one to one support for the most used DI transformations.
We are interested in have a specific demo for integration of SAS Viya with Python. Is possible to have a specific workshop for this?
We have an Ask the Expert webinar coming up on August 24 on this topic: How Do I Use SASPy to Interface With SAS From My Python Code? Below are some of the resources we’ll point to during that webinar. If this webinar and these resources don’t answer your questions, please reach out to your Account Rep to schedule something.
Support on SASPy
SASPy on GitHub
SASPy Documentation on GitHub
SASPy Examples
The History and Evolution of SASPy
If your request is specific to the support of Python from SAS (PROC Python), you can contact me directly on LinkedIn.
I see when you assign libname you used two libreference on SAS Studio, why is that so?
There were 2 libnames, one for Snowflake and another one for Google Big Query.
Can we use numpy/pandas in SAS Viya?
Yes, through PROC Python as soon as these packages are available in the Python environment you use with SAS Viya.
Is SAS Enterprise Miner incorporated in SAS Studio (standard or licensed)?
SAS Enterprise Miner replacement on SAS Viya is SAS Model Studio.
How was PROC python enabled in Viya?
PROC Python requires a Python Environment (meaning binaries). It launches a sub process, on the SAS compute server pod.
How could I get the SAS training and certification?
We currently have some free training available. You can find that here: https://www.sas.com/en_us/training/offers/free-training.html.
You can learn about certification here: https://www.sas.com/en_us/certification.html
Recommended Resources
SAS Tutorial | Getting Started with SAS Studio on SAS Viya
How to Use the SAS Information Catalog
SAS® STUDIO - An interactive development environment
SAS Viya Monthly Release Highlights Videos
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.
Click image to register for webinar