Custom Reporting with PROC REPORT and ODS Excel (Hands-On)
Presented: Friday September 6, 2019, 1:30pm-5:00pm
Kirk Paul Lafler is an entrepreneur and founder at Software Intelligence Corporation, and has used SAS software since 1979 as a consultant, application developer, programmer, SAS solutions provider, data analyst, data manager, infrastructure specialist, performance tuner, educator and author. As a SAS Certified professional, mentor, and educator at Software Intelligence Corporation, and an advisor and adjunct professor at the University of California San Diego Extension, Kirk has taught SAS courses, seminars, workshops, and webinars to thousands of users around the world.
Kirk is also 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 topics; has been selected as an Invited speaker, educator, keynote and section leader at SAS conferences and meetings worldwide; and is the recipient of 25 “Best” contributed paper, hands-on workshop (HOW), and poster awards.
SAS® users everywhere turn to the REPORT procedure to customize and satisfy their reporting needs as they create and deliver quality “custom” detail and summary reports, and specialized output for management, end users, and customers. This popular course explores an assortment of techniques to create custom spreadsheets, reports and specialized output using PROC REPORT and the powerful ODS Excel destination.
Attendees learn how to create detail and summary spreadsheets, reports and output using PROC REPORT; acquire useful Output Delivery System (ODS) skills; combine PROC REPORT and the powerful ODS Excel destination to produce quick and formatted detail and summary Excel workbook results; customize output and results with SAS-supplied styles; compute subtotals and totals at the end of a report using a COMPUTE Block; calculate percentages; produce statistics for analysis variables; apply conditional logic to control summary output rows; add background images; build custom autofilter drill-down (interactive) reports and Excel workbooks; and add traffic lighting scenarios to Excel workbooks.