All of the great technical content that you saw (or somehow missed) from SAS Explore 2022 is now available here in the SAS Explore hub on SAS Communities. Over 80 presentations -- including SAS training, User Presentations, Super Demos, R&D Breakout sessions and more -- can be found in the SAS Explore Presentations library.     You can also find these sessions along with select plenary presentations on the SAS Video Portal. And watch/subscribe to the SAS Users YouTube channel -- selected presentations are coming there to live alongside regular programming of hundreds of SAS tutorials and other SAS user-focused shows. ... View more

  Presenter: Brittany Jones   We know that we can create a flexible report with SAS using macro variables, but what about when it comes to multiple reports? What about sending the report to Microsoft Excel? This presentation focuses on using %if/%then logic and %do loops to enable you to create multiple Excel reports. The macro definitions that create the reports are flexible, customizable, and, best of all, able to be run repeatedly without your needing to manually change anything! ... View more

  Presenter: Charu Shankar   Microsoft Excel, SQL and SAS are all equally loved for their unique strengths. Excel has been a go-to for a long time. Database workers live in SQL. SAS Viya is a cloud-enabled, in-memory analytics engine that provides quick, accurate, and reliable analytical insights. What would it be like to stay in the comfort of SAS while beckoning Excel in to join data using PROC SQL. If you have wondered how this is possible, then come to this session. Watch this incredible trio in action. You will learn to bring in data from excel to SAS Viya using SAS engines, join multiple excel spreadsheets, summarize data within SAS Viya using proc SQL, and send the results to excel. And you do all these things within SAS. Charu will show you a great way to build a bridge between SAS coders and colleagues who never code. All levels welcome! ... View more

  Presenter: Dominique Weatherspoon   This presentation covers techniques to build advanced, flexible dashboards that empower users to filter information according to their specific needs. Dominique Weatherspoon will demonstrate these techniques through a real-world case study of a dashboard that allows the managers of an international online learning platform to analyze course evaluations submitted by past students. Through this example, viewers will witness how the following SAS Visual Analytics features can enhance their reports/dashboards: joining and aggregating tables, mapping data items across multiple data sources, using parameters, using prompt and object containers, formatting objects, and hiding pages. In addition, Dominique will give tips for inheriting and exploring unfamiliar reports. ... View more

Presenter: Peter Styliadis   Unite the Python language with the analytic power of SAS. In this presentation, you learn how to use the SWAT (SAS wrapper for analytics transfer) package to take advantage of the SAS cloud analytic services (CAS) engine in SAS Viya for massively parallel processing (MPP). We begin with a quick overview of SAS Viya and the CAS engine and then discuss how to leverage the strengths of the CAS engine and your local Python client, how to connect Python to CAS, and how to access and load data into CAS's MPP environment. Then we dive into exploring, preparing, and analyzing data using the CAS server, taking advantage of the CAS server's distributed processing power using familiar Pandas API and CAS actions from the SWAT package. Lastly, we learn how to unite traditional Python packages such as Pandas and matplotlib with the summarized results from the CAS server for additional processing and visualization. ... View more