Join SAS and the New Jersey SAS User Group (NJSUG) for an immersive experience where data mastery meets reporting excellence! Discover the art of seamlessly reading and writing Excel data with SAS, unlocking a realm of possibilities. From Excel data ingestion to crafting dynamic reports in Excel using SAS, this session empowers you to navigate the convergence of SAS and Excel. Learn efficient SAS techniques to harness the power of both tools, ensuring a seamless workflow for comprehensive data analysis and reporting. Elevate your skills and gain the expertise needed to unleash the full potential of SAS in creating impactful Excel reports.
Presenter:
Rich Papel Rich Papel first encountered SAS in a 1985 programming class. So inspired by the language, he began teaching at SAS in 1997 and now teaches most of SAS’ foundation programming and Advanced topics course, including Macro and Advanced Macro Programming, SQL, all aspects of Enterprise Guide, Office Analytics, JMP ANOVA & Regression, JMP Custom Design of Experiments, SAS Studio, and Statistics 1 class, bilingual in both English and Spanish. Rich's diversified work experience includes Transportation planning, Economic Research and electric load forecasting for the electric utility industry. But he happily admits that nothing has been as enjoyable as his 27 years as a SAS teacher.
Register Today!
Ever catch yourself reading the nutrition label on those cookies or potato chips you're eating? Well, if you are one of those people (or even if you're not), you'll certainly be interested in Model Cards for SAS Model Studio Models, the nutrition labels for models. We're excited to introduce you to model cards and we're dedicating the October edition of the SAS Bowl to it.
Game Details
The SAS Support Community trivia event, SAS Bowl XLIV, Model Cards is scheduled for Wednesday, October 16, at 10 AM ET.
Register for the event and receive an invite to a Microsoft Teams meeting and a calendar event.
On game day, join the Teams meeting and access the game here.
More on Model Cards for SAS Model Studio Models
Model Cards for SAS Model Studio Models makes use of descriptive visuals, to make model cards accessible to all personas involved in the analytics process, including data scientists, data engineers, MLOPs engineers, managers, executives, risk managers, business analytics, end-users, and any other stakeholder with access to the SAS Viya environment. Additionally, most of our model card populates automatically as the model is developed, managed, and deployed in SAS Viya.
Model card detail an AI model’s training data, development process, accuracy, model drift, fairness assessments and governance. Model cards in SAS are available for both SAS and Python models.
Below are portal-related resources we'll use to create questions for the game.
Creating a Model Nutrition Label: Model Cards for SAS Model Studio Models - SAS Communities Library article
Creating a Model Nutrition Label: Model Cards for Python ModelsSAS launches a revamped developer portal - SAS Communities Library article
A Nutrition Label for AI Models: SAS Model Cards Now Available - SAS Blog post
Model cards: The AI transparency label you need - SAS Blog post
Model Card: Nutrition Label for an AI Model - Introductory video
Fostering Trustworthy AI Using a Model Card - Ask the Expert webinar
SAS Bowl and event details
For those who may be new to the SAS Bowl, you can find game history and specifics in this Community memo. There you'll also find links to previous events, which include recordings.
Register for the event and receive an invite with game details and a Teams meeting link. On game day, Join the TEAMS meeting to play, and show off your SAS and worldly knowledge while competing for bragging rights and SAS Community game gear.
BASUG is thrilled to announce our IN-PERSON SAS Blowout!
Pre-registration by Oct 15 is required. No on-site registration or walk-ins.
The meeting will be held on Friday, October 18, at the Microsoft New England Research and Development Center in Kendall Square, Cambridge. The full-day meeting, co-hosted by SAS® and BASUG, features presenters from SAS, presenting on a range of SAS 9 programming topics. There will be plenty of time for socializing during breakfast, breaks, lunch, and an early evening mixer with appetizers and a cash bar. We can't wait to see you! Abstracts are listed below. If you have questions, feel free to email us: registrations@basug.org.
The meeting will not be recorded, and will not be live-streamed. We hope to see you in-person.
BASUG welcomes students with a 50% discount if they register by Friday, October 4. Please email an image of your current student ID to registrations@basug.org to request the coupon code.
Thank you to Microsoft for providing tech non-profits with access to the beautiful NERD facilities.
PRESENTATIONS
I ♥ SAS 9 and Other Nerd Confessions!
Susan Owenby (Senior R&D Director of Engineering, SAS Institute Inc.)
Join Susan for a trip down memory lane as she shares anecdotes from her 18-year SAS journey, including what canon events led to investing her career supporting SAS 9 users as a Senior R&D Director of Engineering. We will tie it off with some information about the future support of SAS 9 and our next maintenance release, SAS 9.4M9.
Major ODS Destinations: Quirks
Jane Eslinger (President and CEO, Eslinger Enterprises)
We all know that each of the commonly used ODS destinations is different. While most of the syntax you need to create your output is the same, it is helpful to know when that syntax should be modified, or other code included because of the file type you are trying to generate. This presentation explores the quirks, good and bad, of the PDF, RTF, HTML, Excel, and PowerPoint destinations.
Building Complex Graphics from Simple Plot Types
Dan Heath (Principal Software Developer, Data Visualization R&D, SAS Institute Inc.)
There are many types of graphics, such as survival plots, adverse event plots, and forest plots, used to report clinical data. However, many of these graphics might not be available as a simple request. Even if they are available, there can be many variations on these graphics, and the reporting requirements can be different from one company to another. In this presentation, I want to show you how to construct these types of graphics by combining simple plot types, sometimes in very creative ways. We will discuss how to think about a graph as the sum of its parts. This will empower you to create these types of graphics in whatever form you need.
Data Cleaning Using SAS Programming
Jacqueline Johnson, DrPH (Principal Analytical Training Consultant, SAS Institute, Inc.)
Cleaning your data is one of the first steps in any analysis. And- it is often an exciting step because it helps you better understand your data! We will explore some tips and tricks for cleaning your data using SAS programming. In particular, we will discuss how to:
• Use Perl regular expressions to detect data errors in character variables.
• Use SAS formats and functions to standardize data.
• Create integrity constraints to restrict data values allowed in a data set.
Tips for Navigating SAS Documentation
Jane Eslinger (President and CEO of Eslinger Enterprises)
The amount of documentation for SAS products is mindboggling. Searching – and finding – what you need can be difficult at times. This presentation provides tips for getting to the desired documentation quickly and navigating the pages once you get there.
Job Opportunities with SAS Skill
Jacqueline Johnson, DrPH (Principal Analytical Training Consultant, SAS Institute, Inc.)
SAS Academic Programs partners with labor analytics company Lightcast to understand demand for SAS skill in the marketplace. Join us to look at trends in SAS jobs in Boston as well as the greater Northeastern United States! We will explore companies, job titles, occupations (and more!) hiring for SAS skill. Statistics provided in this talk will be accessible for SAS job hopefuls of varying education and length of work experience.
Panel Discussion
Michael Salé, DPS (Chairperson, Department of Management & Business Analytics, Stonehill College)
Michael Salé will moderate an engaging panel discussion featuring all of the presenters from the meeting, with time for audience questions as well.
Be sure to register!
DCSUG presents: R Made Easier for SAS Users
R offers SAS statistical programmers an opportunity to expand their programming skill set by applying new trending R language in data input, management, analysis and presentation. Many of the typical clinical trials workflow programming tasks can be accomplished in R. Making the migration to R can be challenging, unless you follow a path that ignores traditional data science trials and focus on SQL and database programming concepts. Smarter organizations and SAS programmers follow a guided journey to learn and apply best practices based on basic R base and tidyverse functions. Direct comparison of SAS data step and procedures helps to better understand how R processes data and data frame concepts.
Presented by Sunil Gupta
Sunil Gupta, MS, is an international speaker, best-selling author of five SAS books, and a global SAS/R Developer and CDISC SME and corporate trainer. Sunil is an advocate of CDISC automation and standardization with over thirty years of experience in the pharmaceutical industry. Most recently, Sunil is teaching Practical R for SAS Programmers and a CDISC online class at the University of California at San Diego at UCSD Extension. In 2019, Sunil published his fifth book, Clinical Data Quality Checks for CDISC Compliance Using SAS and in 2011, Sunil launched his unique SAS mentoring blog, SASSavvy.com, for smarter SAS searches and R-Guru.com for R Self-Study Class and Mentoring programming. Sunil has MS in Bioengineering from Clemson University and a BS in Applied Mathematics from the College of Charleston.
Register
