Kirk Paul Lafler recently presented his popular presentation, Google Search for SAS Users, for DCSUG.
Google (www.google.com) is the world’s most popular and widely-used search engine. As the premier search tool on the Internet today, SAS® users frequently need to identify and locate SAS content wherever and in whatever form it resides. Topics include learning how Google search works by illustrating relevant search examples, tips, and techniques for finding content of interest, including examples, reference works, information tools, directories, PDFs, images, SAS communities and user groups announcements / examples / solutions, current news stories, and various techniques on how you can quickly and easily improve / optimize your Google searches to satisfy your every need.
In this post, you'll find the recorded meeting, plus his slides and his original paper with Charlie Shipp. Thank you, Kirk, for another informative presentation!
... View more
Final stop on our Canadian User Group Meeting tour. Finishing with a bang! 💥
Thank you everyone for joining us for a morning of great presentations and discussions. It was amazing to connect with everyone. We're already excited for fall!
Here is the agenda:
8:30am
Registration and Light Refreshments
9:00am
Welcome and Introduction @desikar, Canada Revenue Agency
9:10am
SAS News Alice Yuan, SAS Canada
A quick look at new developments in the world of SAS.
9:20am
SAS Innovate Debrief @joeFurbee, SAS US
This session will provide an update on the latest news from SAS Innovate, which took place in April 2024.
10:00am
Wrangling Excel Sheets @TomKari, Tom Kari Consulting
A comprehensive fix for all your Excel import needs.
10:30am
Break, Networking, and Job Exchange Table
10:45am
SAS Viya and Open Source: Better Together Thomas Hindle, SAS Canada
This presentation will cover two of the main ways that open-source programmers can integrate with SAS Viya.
11:25am
Modernizing 1,000 SAS® Users on Multiple Legacy SAS Solutions @PierreDupuisD, Desjardins
Desjardins' modernization journey to SAS® Viya® on Azure - Sharing challenges, successes and lessons learned.
11:55am
Closing Remarks and Prize Draw
The presentations are attached for your reference. Note: The presentation, Modernizing 1,000 SAS Users, is not available to share.
See you at the next one! 😎
... View more
What a fun day for our Halifax community! The sun was shining and we were in a historic venue that was perfect for a day of learning. 😎📜
We had a presentation by @JaredLinck about R integration with SAS Viya. 👨💻👩💻
A presentation and live demonstration of how SAS and R can be used together to optimize how you work with data and analytics. We will begin with a brief overview of the various integration points between SAS and open source tools like R, Python, and web apps using APIs. This integration includes both directions of communication: from SAS out to open-source tools, and from open-source tools into SAS. We will then provide a live demonstration of specific methods for integrating R with your existing and future SAS workflows. Time will be reserved for questions and discussion of strategies and tips to take advantage of the best of both SAS and R in your daily work.
Then, we split into 3 teams and tested our SAS knowledge with a game of Jeopardy. 🎮 We found out how much we know about Procs, informats, graphs, and dates. Great job to Team No, winning in a tight race! 🏆
In this post, you will find the presentations for your reference. We hope you had fun, found it valuable, and able to reconnect with other users in the community. See you again at the next one! 🤗
... View more
And that's a wrap for our spring edition of ESUG! 👏
What a great day of learning, knowledge exchange, and connecting with new and old friends. Here's what we had in store for everyone.
8:30am - 9:00am
Registration and Light Breakfast
9:00am - 9:05am
Welcome Remarks @dougd , ESUG President
9:05am - 9:15am
SAS Updates Alice Yuan, SAS Canada
A quick look at new developments in the world of SAS.
9:15am - 9:45am
A Snapshot of Quantile Regression Anamaria Savu, University of Alberta
Quantile regression is a type of regression that models the conditional quantiles of a response variable on predictor variables. Unlike ordinary least squares (OLS) regression, which models the conditional mean of the response variable given the predictor variables, quantile regression allows to model separately different quantiles (such as the median, quartiles, or any other percentile) of the response variable.
She will discuss the advantages of quantile regression through examples. At the same time I will demonstrate how PROC QUANTREG can be used to perform quantile regression.
9:45am - 10:15am
Tips & Tricks
A Forest of Decisions: Navigating Complexity with Random Forest using SAS 9.4 Anthony Wu, Government of Alberta
Random Forest is a powerful ensemble learning technique widely used in machine learning for classification and regression tasks This presentation will explore some practical implementations of Random Forest in SAS 9.4, showcasing its effectiveness in predictive analytics and model building across various domains.
10:15am - 10:40am
Networking Break
10:40am - 11:10am
Automated Processing of Web-Based Research Data Using Proc HTTP and Macro Variable Lists @rickwatts , Women and Children's Health Research Institute
Rick and team use a web based system called REDCap to collect medical research data from study participants. A single REDCap system houses many thousands of projects, each of which can be designed and modified by individual researchers. This is a very dynamic data environment with project level data structures continually changing. Any such change is reflected in data extracts resulting in frequent re-writes of existing SAS code.
To address this challenge Rick has written a large lump of ugly SAS code that uses PROC HTTP to extract project data via REDCap’s RESTFUL API. System metadata allows REDCap concepts to be mapped to SAS data types, variable names, labels and formats before data is extracted and processed into individual, study specific data sets.
11:10am - 11:55am
Integrating Synthetic Data Generation in Machine Learning Modeling Pipelines @BrettWujek & @Sundaresh , SAS
Synthetic data generation is increasingly important for augmenting existing data sets, mitigating imbalance in data sets with rare events and enabling data science tasks without having to share sensitive real data. In this presentation, we show how to use SAS® analytical capabilities to efficiently generate high-quality synthetic data. We demonstrate the use of SAS procedures, a REST API in Python, related pre-processing and post-processing steps, as well as assessment metrics.
11:55am - 12:00pm
Closing Remarks
If you have a presentation idea for our next meeting, please let us know. See you at the next one! 😃
... View more
Thank you for joining us for another great CSUG Meeting! 💃 We had a great time meeting you (again) in-person and exchanging knowledge and experiences. 🤓
Here was the agenda:
8:30am - 9:00am
Registration and Light Breakfast
9:00am - 9:15am
Welcome Remarks and SAS News Alice Yuan, SAS Canada
9:15am - 10:00am
Integrating Synthetic Data Generation in Machine Learning Modeling Pipelines @BrettWujek & @Sundaresh , SAS US
Synthetic data generation is increasingly important for augmenting existing data sets, mitigating imbalance in data sets with rare events and enabling data science tasks without having to share sensitive real data. In this presentation, we show how to use SAS® analytical capabilities to efficiently generate high-quality synthetic data. We demonstrate the use of SAS procedures, a REST API in Python, related pre-processing and post-processing steps, as well as assessment metrics.
Note: this was a virtual presentation.
10:00am - 10:20am
Programming Tips & Tricks @andrei17 , FRG Risk
10:20am - 10:50am
Networking Break
10:50am - 11:40am
SAS and Open Source @nicosigal & @DeepJariwala027 , SAS Canada
11:40am - 11:50am
Closing Remarks
Thank you to our speakers! 👏
If you would like to ask more questions or just connect with the Western Canada team:
Sales Director: Christine Jackson
Customer Success Manager: Nick Sandy
Sr Systems Engineer: Nicolas Sigal
Account Executive: Ivan Scheverman
Thank you for a great day and we hope we'll see you at our next one.
... View more