Calling All Iowa SAS? Users!
Kirk Paul Lafler
A Data Scientist, Consultant, Educator, Developer, Programmer, and problem solver who transforms organizations and people with intelligent data-driven solutions and analytics.
Fellow SAS colleagues, the Iowa SAS? Users Group (IowaSUG ) is pleased to announce four (4) in-person training courses on Wednesday (5/15/2024) and Thursday (5/16/2024). This is a wonderful opportunity to learn, enhance your skills, share knowledge, and network with friends and SAS colleagues in beautiful downtown Des Moines, Iowa.
Course Registration (click Eventbrite link to register/pay for each training course):
Building Reusable Tools Using the SAS? Macro Language
The SAS? Macro Language is a powerful feature in the Base SAS? software for extending and customizing the capabilities of the SAS? System. This course presents a practical approach to macro tool design and development, along with a collection of techniques for constructing reusable and effective macros tools. Attendees learn basic design principles in the development of reusable macro tools; how to build functional macros that process SAS? statement code using efficient and portable code; the different methods of creating macro variables including using the macro – PROC SQL interface to create single-value and value-list macro variables; how to create user-defined macro routines that accept keyword and positional parameters; utilize and implement defensive programming techniques to make your macro routines smarter; explore how to build a library of macro utility tools; and macro debugging and troubleshooting code errors, warnings, and other special messages.
Intended Audience: All SAS users
Prerequisites: SAS Essentials course or 6-months SAS software experience
Delivery Method: Instructor-led with code examples
Length: 3.5-Hours
Cost: $200 per attendee
Course Material: e-Course Notes (PDF format), Code, and Course Certificate (PDF format) are provided to Attendees.
Date and Time: Wednesday, May 15, 2024 -- 8:30am - 12:00pm
Advanced PROC SQL Programming Concepts and Techniques
The power of PROC SQL as a database programming language is well known with SAS? users around the world. This course presents advanced PROC SQL concepts and programming techniques to exploit the power of SQL as a programming language to access, manipulate, restructure, and validate data. Attendees learn how to apply unique coding techniques including determining the number of rows in all input tables, identifying the tables with the most indexes, handling nearest neighbor problems, and identifying and accessing FIRST.row, LAST.row, and BETWEEN.rows while processing By-group; the application of rule-based and cost-based optimization strategies – influencing the SQL optimizer to choose from the available join algorithms; the application of “fuzzy” matching techniques; the application of “virtual” tables known as views; the strategies and techniques related to the design and implementation of simple and composite indexes; constructing table validation rules using table integrity constraints; and exploring query performance tuning techniques for big data environments.
Intended Audience: All SAS users
Prerequisites: SAS Essentials course or 6-months SAS software experience
Delivery Method: Instructor-led with code examples
Length: 3.5-Hours
Cost: $200 per attendee
Course Material: e-Course Notes (PDF format), Code, and Course Certificate (PDF format) are provided to Attendees.
Date and Time: Wednesday, May 15, 2024 -- 1:00pm - 4:30pm
SAS? Performance Optimization Techniques
In an era of big data and rapidly changing technologies, programmers and developers design software adhering to a specified set of functionalities and the assumption that their program code will run on processors with limited computational power. Adding to these issues, performance and/or efficiency aspects are often given little attention or simply ignored. To ensure that program code uses the fewest resources (i.e., CPU, I/O, storage, and memory) possible, this course presents valuable techniques to control, manage, and optimize and tune for performance. Scalable techniques to control program execution, I/O, memory, disk space, and code activities will be taught to deliver faster results while reducing the demand for limited resources.
Topics include SAS? optimization techniques to enable your code to run faster, reduce input/output (I/O) operations, and affect storage demands by utilizing efficient coding constructs and functions, removing redundant code, eliminating dead code, leveraging memory speeds, avoiding type conversions, assigning system options to optimize processing efficiencies, using arrays and user-defined formats for table lookup operations, organizing conditional statements by frequency of occurrence, optimizing looping scenarios, accessing data subsets sequentially or with indexes, and the application of other scalable techniques.
Intended Audience: All SAS users
Prerequisites: SAS Essentials course or 6-months SAS software experience
Delivery Method: Instructor-led with code examples
Length: 3.5-Hours
领英推荐
Cost: $200 per attendee
Course Material: e-Course Notes (PDF format), Code, and Course Certificate (PDF format) are provided to Attendees.
Date and Time: Thursday, May 16, 2024 -- 8:30am - 12:00pm
Data-driven Programming Techniques Using SAS?
Data-driven programming is a popular programming paradigm where the data, or data structures, control the flow of a program. Data-driven programming techniques can be applied to structured and unstructured data for filtering, aggregating, transforming, and calling other programs. Topics include using SAS? programming techniques to access NLEVELS (for By-group content); accessing SAS Dictionary tables (or SASHELP Views) content; determining the names of the tables available with a libref, if a dataset is empty, the number of observations in any dataset, the names and number of character versus numeric variables that exist in any dataset, and identifying variable attributes; using the SQL-macro interface to create single-value and value-list macro variables; using DATA step CALL EXECUTE statements; using metadata as input into a SAS code generator or a SAS macro to produce the desired results; applying specific DICTIONARY table and SASHELP view content in examples related to the creation of dynamic code; constructing an external control file to define relationships; using PROC FORMAT with the CNTLIN= option; and using iterative programming constructs and processes with PROC SQL and the Macro language to dynamically create data-driven programs.
Intended Audience: All SAS users
Prerequisites: SAS Essentials course or 6-months SAS software experience
Delivery Method: Instructor-led with code examples
Length: 3.5-Hours
Cost: $200 per attendee
Course Material: e-Course Notes (PDF format), Code, and Course Certificate (PDF format) are provided to Attendees.
Date and Time: Thursday, May 16, 2024 -- 1:00pm - 4:30pm
Note: If you would like to pay by check to save online processing fees, or have any questions, please contact John Xu.
515-778-4093
Instructor:
Kirk Paul Lafler is a consultant, developer, programmer, educator, and data scientist, and has been a SAS user since 1979. Kirk works as a lecturer and adjunct professor at San Diego State University; and teaches dozens of SAS, SQL, Python, and Excel courses, workshops, and webinars to users around the world. As the author of several books including PROC SQL: Beyond the Basics Using SAS, Third Edition (SAS Press. 2019) along with hundreds of papers and articles on a variety of SAS, SQL, Python, and Excel topics. Kirk currently serves as the Open-source Advocate and Coordinator for the Western Users of SAS Software (WUSS) organization, and has been selected as an Invited speaker, educator, keynote, and section leader at conferences and meetings worldwide; and is the recipient of 28 “Best” contributed paper, hands-on workshop (HOW), and poster awards.
Training Location:
Location: Iowa Department of Education, Basement level, Room B100, 400 E. 14th St., Des Moines, IA 50319
Parking: In front of the building on the west side.
Lunch: Provided if you enroll in a full day of (two) classes.
SAS is the registered trademark of SAS Institute Inc., Cary, NC, USA.
Senior Technical Architect, SAS
10 个月is there a SAS users group in the Iowa City area?
Analytiks International, Inc
11 个月Kirk is first rate, don’t miss out!
I have new employment
11 个月Keep up the good work Kirk!