Bay Area SAS Users Group Training Classes
This page is reserved for announcements of local Bay Area SAS related
courses. If you have a class which you would like to inform the group,
please send it to firstname.lastname@example.org.
Make sure the subject says "BASAS Classes Posting".
- San Francisco Bay Area SAS(R) Training Event - February 20th, 2018 by Kirk Paul Lafler!
Three popular SAS® training courses are being taught by Kirk Paul Lafler in the San Francisco Bay area on Tuesday, February 20th, 2018 at the Holiday Inn Express Suites - Belmont, in Belmont, California. I hope you will plan to attend one, two, or all three instructor-led courses to help expand your SAS knowledge. A brief description, along with a registration form, is enclosed for each course, below.
Course 1: Building High-Impact Dashboards Using Base SAS® Software (Tuesday Morning; February 20th, 2018; 9:00 am - 12:00 pm)
Building High-Impact Dashboards Using Base SAS® Software PDF
This 3-hour instructor-led course provides attendees with valuable programming techniques on how to build high-impact and powerful dashboards that display essential “point-in-time” information with a purpose. Attendees learn essential dashboard design techniques that extract data from available data sources; strategies on the placement and display of essential data, information, reports, tables, statistics, metrics, and images; and basic design principles for creating custom content that displays on a single screen.
Essential design and programming techniques are presented to build highly visual, exciting, and high-impact 1-, 2-, 3- and 4-panel static and interactive dashboards using Base SAS® software. Attendees learn how to create high-impact dashboards with a purpose using the DATA step; PROC FORMAT; PROC PRINT; PROC REPORT; PROC MEANS; PROC SQL; Output Delivery System (ODS); SAS macro language; Statistical Graphics procedures: PROC SGPLOT, PROC SGSCATTER, PROC SGPANEL, and PROC SGRENDER; PROC TEMPLATE; and Graphics Template Language (GTL).
Course 2: SAS® Fuzzy Matching Programming Techniques (Tuesday Afternoon; February 20th, 2018; 1:00 pm - 4:00 pm)
SAS® Fuzzy Matching Programming Techniques PDF
Data comes in all forms, shapes, sizes and complexities. Stored in files and data sets, SAS® users across industries know all too well that data can be, and often is, problematic and plagued with a variety of issues. One issue, in particular, stems from the complexities associated with linking, or matching, observations from two or more data sets where a common unique identifier, referred to as the key, is not reliable or does not exist. But, what happens when a unique identifier such as a subscriber name, mailing address, and/or email address is misspelled, has one or more characters transposed, or is partially and/or incorrectly recorded?
This 3-hour instructor-led course introduces attendees with what fuzzy matching is, the variety of data issues users have to deal with, popular data cleaning and organization techniques, the application of functions such as SUBSTR, SCAN, INDEX, COMPRESS, COMPBL, COMPARE, TRANSLATE, CAT, SOUNDEX (for phonetic matching), SPEDIS, COMPLEV, COMPGED, and an assortment of programming techniques used to resolve key identifier issues and to successfully merge, join and match less than perfect or messy data.
Course 3: ODS EXCEL® Programming Techniques By Example (Tuesday Evening; February 20th, 2018; 5:30 pm - 8:30 pm)
ODS EXCEL® Programming Techniques By Example PDF
This 3-hour instructor-led course provides attendees with valuable programming techniques on how to build high-impact Excel® files and workbooks with a purpose using SAS® Base software. SAS software is the “gold” standard for robust and reliable data access, manipulation, analytics, analysis, reporting, and data discovery. Microsoft Excel® is the most widely used software in the world.
This popular course illustrates how to leverage the Output Delivery System (ODS) Excel destination to create customized, and exciting, output and results in Microsoft Excel; apply ODS Excel options; customize output and results with SAS-supplied styles; add background images and traffic lighting to Excel files and workbooks; build interactive drill-down Excel workbooks; and construct SAS and ODS Excel code to share data, tables, statistics, images, reports, and results to create robust Microsoft Excel files and workbooks.
The location for all three instructor-led training courses is the: Holiday Inn Express Suites Belmont, 1650 El Camino Real, Belmont, California 94002.
The cost for each instructor-led course is $189.
About the Instructor, Kirk Paul Lafler
Kirk Paul Lafler is an entrepreneur and founder of Software Intelligence Corporation. Kirk has worked with 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, educator at Software Intelligence Corporation, and advisor and SAS programming adjunct professor at the University of California San Diego Extension, Kirk has taught SAS courses, seminars, webinars and workshops to thousands of users around the world.
Kirk has written six books including Google® Search Complete (Odyssey Press. 2014) and PROC SQL: Beyond the Basics Using SAS, Second Edition (SAS Press. 2013); hundreds of papers and articles on a variety of SAS topics; selected as an Invited speaker and educator at SAS International, regional, special-interest, local, and in-house user group conferences; and is the recipient of 25 “Best” contributed paper, hands-on workshop (HOW), and poster awards.
Attachments for all three courses along with a registration form are attached. Please feel free to let others know about the training event and to share the brochures with colleagues. Seats are limited, so please RSVP to reserve your seat in one, two or all three courses by February 14th, 2018 by sending an email to KirkLafler@cs.com.
Kirk Paul Lafler
Perform better Internet searches with the book the pros use, Google Search Complete!
SAS is the registered trademark of SAS Institute Inc., Cary, NC USA.
- SAS® Programming Tour!
SAS Training is taking
our programming courses on tour, and we are making a stop in San Francisco!
- Choose from Programming 1, 2 or 3.
- Take advantage of our bundle offers
and take more than one!