Custom Reports, Spreadsheets, and Dashboards Using PROC REPORT, ODS, SGPLOT

Kirk Paul Lafler is a globally recognized data scientist, consultant, educator, programmer, author, and speaker with more than 40 years of experience delivering practical, real-world analytics training. His expertise spans SAS, SQL, Python, R, databases, big data, AI, machine learning, and cloud technologies. Known for transforming complexity into clarity, Kirk helps learners build confidence and proficiency through hands-on, applied instruction.

Kirk Paul Lafler - Python, AI, SQL, & SAS Trainer

Learn how to build amazing "custom"  reports, spreadsheets, and dashboards using SAS® software from a leading expert.

Iowa Department of Education

<h3><strong>Course Description:</strong></h3><p>SAS® users everywhere turn to the REPORT procedure, Output Delivery System (ODS), and PROC SGPLOT to produce and customize their detail / summary reports, spreadsheets, dashboards, and specialized output needs and requirements. This popular course explores an assortment of programming techniques using the powerful features found in PROC REPORT, ODS, and PROC SGPLOT. </p><p>Attendees learn valuable programming techniques on how to use PROC REPORT, ODS, and PROC SGPLOT; combine PROC REPORT with the powerful features found in ODS PDF, HTML, and Excel destinations, and PROC SGPLOT to produce amazing detail and summary reports, spreadsheets, dashboards, and specialized results quickly and easily; customize output and results with PROC REPORT formatting features and SAS-supplied styles; compute subtotals and totals at the end of a report using COMPUTE Blocks; calculate percentages; produce descriptive statistics for analysis purposes; apply conditional logic to control summary output rows; add background images, logos, and watermarks; build custom autofilter techniques to subset (or filter) reports and Excel workbooks; freeze row and column headers for “frame-of-reference” vantage points while scrolling in Excel workbooks; add traffic lighting scenarios; and build “custom” 1x1, 1x2, 2x1, 2x2, 2x3, 3x2, and 3x3 (row x column) dashboards.</p><p></p><h3><strong>I﻿nstructor Bio:</strong></h3><p>Kirk Paul Lafler is a SAS, SQL, RDBMS, Excel, and Python educator, developer, programmer, consultant, and data analyst; and works as an adjunct professor at San Diego State University; an advisor and adjunct professor at the University of California San Diego Extension; and an educator teaching SAS, SQL, Python, Excel, and cloud-based technology courses, workshops, and webinars to users virtually around the world. Kirk has nearly 50 years of programming experience and specializes in SAS software, SQL, RDBMS technologies (Oracle, SQL-Server, Teradata, DB2), Python, and other languages and productivity tools. As an author, Kirk’s most recent books include Exploratory Data Analysis (EDA) By Example (PB&J Press. Summer 2023), Python ETL By Example (PB&J Press, Spring 2024), PROC SQL: Beyond the Basics Using SAS, Third Edition (SAS Press. 2019), and other books along with numerous papers and articles on a variety of SAS, SQL, and Python topics. Kirk is actively involved with international, regional, and local SAS, SQL, and Python user groups and conferences as an Invited speaker, educator, keynote, and section leader; and is the recipient of 27 “Best” contributed paper, hands-on workshop (HOW), and poster awards.</p><h3><strong>L﻿inkedIn Profile:</strong></h3><p>https://www.linkedin.com/in/kirkpaullafler/</p><p></p><h3><strong>Course Date:</strong>
</h3><p>Wednesday, May 24, 2023</p><h3><strong>Training Location:</strong></h3><p>Iowa Department of Education, 400 E. 14th St., Des Moines, IA 50319, USA.</p><h3><strong>Intended Audience:</strong></h3><p>Programmers, Data Analysts, Data Scientists, Statisticians, Reporting Analysts, and Others wanting to Learn PROC REPORT, Output Delivery System (ODS), and PROC SGPLOT programming techniques.</p><h3><strong>Prerequisites:</strong></h3><p>No previous PROC REPORT, ODS, and/or PROC SGPLOT programming experience required.</p><h3><strong>Delivery Method:</strong></h3><p>Instructor-led workshop with PROC REPORT, ODS, and PROC SGPLOT code examples.</p><h3><strong>Course Length:</strong></h3><p>3.5 Hours (1:00 PM – 4:30 PM).</p><h3><strong>Course Material:</strong></h3><p>Course Notes will be provided to each attendee as a PDF document. PROC REPORT, ODS, and PROC SGPLOT code is provided to each attendee.</p><h3><strong>Q﻿uestions:</strong></h3><p>Contact Kirk Paul Lafler, KirkLafler@cs.com</p><p></p><p>S﻿AS is the registered trademark of SAS Institute Inc., Cary, NC, USA.</p>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}