Dynamic Drive DHTML Scripts- Drop Down Tabs demos


 
 







 
 

All Conference Years 


About SESUG


About SESUG


Sponsored by

SAS
 
 
  
CONFERENCE WORKSHOPS


Conference Workshops offer the bonus of additional educational experiences for SESUG Conference attendees.  We have talented, recognized, and experienced instructors prepared to share their knowledge in these 4-hour sessions.

SESUG is scheduling seven workshops this year with one on Saturday, October 13th, six on Sunday, October 14th, and one on Wednesday, October 17th!! See the times in the table below.

The workshops cover a wide variety of topics and skill levels. These 4-hour workshops will appeal to everyone interested in exceptional in-depth training. Please note that workshops are an extra fee event at SESUG.

Saturday, October 13, 2018
Building Reusable Tools with the SAS Macro Language Kirk Paul Lafler 1pm-5pm
Sunday, October 14, 2018
Think Like a Data Storyteller Tricia Aanderud 8am-12pm
Driving Miss Data: Data-Driven Techniques Richann Watson 8am-12pm
Custom Reporting with PROC REPORT and the ODS Excel Destination Kirk Paul Lafler 8am-12pm
Fifty-Five Functions to Supercharge your SAS Code Josh Horstman 1pm-5pm
Manipulating Data With DO Loops, Arrays and Numeric Functions Ben Cochran 1pm-5pm
To Be Decided To Be Decided, SAS 1pm-5pm
Wednesday, October 17, 2018
What can PROC SQL Do for You? Stephanie Thompson 1:30pm-5:30pm

Early Online Registration Fee $175 ($150 each if registering for 2+ for the same person)
Regular Onsite Registration $175
Administrative Fee for Workshop Only $25 (no conference registration)

 

For information on registering for a workshop or the conference, please see Registration Information.

 

  
Saturday, October 13, 2018



Building Reusable Tools with the SAS® Macro Language

Scheduled Time:  
Saturday, October 13th, 1:00 pm - 5:00 pm

Intended Audience:  Introduction to Macro Course or 1 year SAS programming experience

Instructor:  Kirk Paul Lafler, Software Intelligence Corporation

Abstract:  The SAS® Macro Language is a powerful feature for extending and customizing the capabilities of the SAS System. This workshop 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 how to build functional macros that process statements containing SAS code; learn basic design principles in the development of reusable macro tools; create macros containing keyword and positional parameters; utilize and implement defensive programming techniques; build a library of macro utility tools; interface the macro language and the SQL procedure to create single-value and/or value-list macro variables; develop efficient and portable macro language code; and debug and troubleshoot code errors, warnings, and other special messages.

Instructor Bio:   Kirk Paul Lafler is entrepreneur, consultant and founder at Software Intelligence Corporation, and has been programming with SAS® software since 1979. Kirk is a SAS certified professional, application developer, programmer, mentor, provider of SAS consulting and training services, advisor and adjunct professor at the University California San Diego Extension, emeritus sasCommunity advisory board member, and educator to SAS users around the world. As the author of six books including Google Search Complete! (Odyssey Press. 2014) and PROC SQL: Beyond the Basics Using SAS, Second Edition (SAS Institute. 2013); Kirk has written hundreds of papers and articles; served as an invited speaker, trainer, keynote and section leader at SAS user group conferences / meetings around the world; and is the recipient of 25 "Best" contributed paper, hands-on workshop, and poster awards.

 

  
Sunday, October 14, 2018



Think Like a Data Storyteller

Scheduled Time:  
Sunday, October 14th, 8:00 am - 12:00 pm

Intended Audience:  Any level of data analysts or managers. It's more about presenting data than specific programming techniques

Instructors:  Tricia Aanderud & Jaime D'Agord

Abstract:  What happens when we think like a storyteller? One of the hardest parts about data is capturing people's attention. Numbers may prove your point, but how do you get others to care about them? Data storytelling allows you to mix interesting narratives with data so that you can maximize your impact. This is accomplished through a mixture of data visualization and storytelling theories and best practices. Whether you're an analyst crunching numbers or a manager needing to communicate in a data-driven way, this paper introduces the skills needed to create effective data stories. We will review data storytelling methods, learn what stories motivate which audiences, learn how to best display data, and create messages that resonate. The topics are focused on general best practices and features techniques using SAS Visual Analytics. Note to Organizers: This course is not tool based we just show how we did it in SAS VA.

Instructor Bios:  
Tricia Aanderud, Director, Data Visualization and Data Science Practice at Zencos Consulting, provides consulting services to organizations that need assistance understanding how to transform their data into meaningful dashboards or data stories. She has co-authored three books with her most recent title "Introduction to SAS Visual Analytics". She regularly shares data visualization tips and data stories knowledge and is frequently invited to speak at industry conferences. Tricia has a background in technical writing, process engineering, and customer service. Born in Kentucky, she now lives in Raleigh, N.C., with her husband and four bratty Javanese cats.

Jaime D'Agord is a Data Visualization consultant at Zencos Consulting where she has worked since 2010 with a wide variety of SAS tools. She is a certified SAS programmer and specializes in data visualization. She enjoys working with customers who need support understanding their business processes' and finding useful ways to perform data analysis. She is an active contributor to the Data Visualization sector of the Zencos Consulting blog and has presented at Southeastern SAS Users Group (SESUG), as well as SAS Global Forum conferences.

 


Driving Miss Data: Data-Driven Techniques

Scheduled Time:  
Sunday, October 14th, 8:00 am - 12:00 pm

Intended Audience:  All levels, from novice to advanced. Pace will allow for questions throughout to allow for interaction.

Instructor:  Richann Watson

Abstract:  We have all been there. We write a program based on the data we have. Then, we get new data and we must update the program. Making these updates can be time consuming. Not only must you update the production version of the program, but someone must also update any associated validation or QC programs. Wouldn’t it be nice if there were ways around this? This is where data-driven techniques come in handy. Using detailed examples, you will learn how to write robust code that is ready to handle an unexpected bend in the road! This half-day course will cover advanced techniques such as: discovering and using information about data sets and variables even if it's not known in advance; generating dynamic formats that are based on the data instead of hard-coded into your program; using complex looping structures to control your program flow based on the data; building code on the fly, even from within a DATA step; and much more!

Purpose: The purpose of this course is to highlight the issues necessary for the discipline of Test-Driven Development (TDD), an aspect of Agile and Extreme Programming.

Instructor Bio:   Richann Watson is an independent statistical programmer and CDISC consultant. She has been using SAS since 1996. She is also a member of the CDISC ADaM team and various sub-teams. In addition, she is the chairperson for the local SAS user group in her area and is actively involved with SAS Global Forum, PharmaSUG, MWSUG and other SAS User Groups.

 


Custom Reporting with PROC REPORT and the ODS Excel Destination

Scheduled Time:  
Sunday, October 14th, 8:00 am - 12:00 pm

Intended Audience:  All SAS users

Instructor:  Kirk Paul Lafler

Abstract:  This new and popular workshop teaches SAS® users an assortment of techniques to create custom reports and specialized output using PROC REPORT and the ODS Excel destination. Attendees learn how to create detail and summary reports 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 an analysis variables; apply conditional logic to control summary output rows; add background images; add traffic lighting scenarios to Excel workbooks; and build drill-down (interactive) custom reports and Excel workbooks.

Instructor Bio:   Kirk Paul Lafler is entrepreneur, consultant and founder at Software Intelligence Corporation, and has been programming with SAS® software since 1979. Kirk is a SAS certified professional, application developer, programmer, mentor, provider of SAS consulting and training services, advisor and adjunct professor at the University California San Diego Extension, emeritus sasCommunity advisory board member, and educator to SAS users around the world. As the author of six books including Google Search Complete! (Odyssey Press. 2014) and PROC SQL: Beyond the Basics Using SAS, Second Edition (SAS Institute. 2013); Kirk has written hundreds of papers and articles; served as an invited speaker, trainer, keynote and section leader at SAS user group conferences / meetings around the world; and is the recipient of 25 "Best" contributed paper, hands-on workshop, and poster awards.

 


Fifty-Five Functions to Supercharge your SAS Code

Scheduled Time:  
Sunday, October 14th, 1:00 pm - 5:00 pm

Intended Audience:  All levels of SAS programmers, from novice to advanced. Pace will be moderate, allowing plenty of time for Q&A as we go. I like to keep my classes as interactive as possible

Instructor:  Josh Horstman

Abstract:  The SAS System includes an extensive collection of nearly five hundred DATA step functions that can provide great utility and convenience for the programmer. Many of these are relatively new and unknown. In this halfday course, we'll look at some SAS functions that should be in every programmer's toolbox. Each function will be presented with concrete examples so you'll be able to take what you've learned and put it to use right away. We will cover functions from a broad range of categories such as string manipulation functions, functions for controlling program logic, functions for handling dates and times, mathematical functions, and much more. This course is suitable for beginning SAS programmers, but even seasoned veterans will probably find something new!

Instructor Bio:   Josh Horstman is an independent statistical programmer based in Indianapolis with 20 year's experience using SAS in the life sciences industry. He specializes in analyzing clinical trial data, and his clients have included major pharmaceutical corporations, biotech companies, and research organizations. A SAS certified programmer, Josh loves coding and is a frequent presenter at SAS Global Forum and various regional and local SAS users group. Josh holds a bachelor's degree in mathematics and computer science, and a master's degree in statistics from Colorado State University.

 


Manipulating Data With DO Loops, Arrays and Numeric Functions

Scheduled Time:  
Sunday, October 14th, 1:00 pm - 5:00 pm

Intended Audience:  All SAS Users

Instructor:  Ben Cochran

Abstract:  This course is divided into four chapters: Introduction, Numeric Functions, Do Loops, and Arrays. The detailed outline is as follows:

  • Introduction
    • Introduction to Data Manipulation
    • Introduction to Numeric Functions
  • Manipulating Values with Numeric Functions
    • Date Functions
    • The LAG Functions
    • Other Numeric Functions
    • Using Postal Codes FIP and ZIP Functions
    • Workshop
  • Iterative Processing
    • Introduction to DO Loops
    • Reading Data with DO Loops
    • Generating Data with DO Loops
    • Workshop
    • Other Useful DO Loop Applications
  • Array Processing
    • Introduction to array processing
    • Array Applications
    • Workshop

Instructor Bio:   After more than 11 years with SAS Institute in the Professional Services (as an Instructor) and Marketing Departments (as Marketing Manager for the SAS/EIS product), Ben Cochran left to start his own consulting and SAS Training business in the fall of 1996 - The Bedford Group. As a Silver member of SAS Institute's Alliance Partner Program, Ben has been involved in many teaching and consulting projects over the last 20+ years. Ben has authored and presented several papers at SUGI, SGF, and regional user groups on a variety of topics since 1988.

 


To Be Decided

Scheduled Time:  
Sunday, October 14th, 1:00 pm - 5:00 pm

Intended Audience:  To Be Decided

Instructor:  SAS Instructor (TBD)

Abstract:  To be Decided

Instructor Bio:   To Be Decided.

 


What can Proc SQL Do for You?

Scheduled Time:  
Wednesday, October 17th, 1:30 pm - 5:30 pm

Intended Audience:  Beginner to Intermediate level with a steady pace to cover material with time for questions throughout

Instructor:  Stephanie Thompson

Abstract:  PROC SQL can be a powerful tool in your programmer's toolkit. There are things that can be done easily using SQL that can be a little more challenging with other PROCS. This workshop will walk you through the basics of PROC SQL as well as highlight the differences to other approaches in SAS. Syntax, creating tables, types of joins, generating new variables, and using summary functions will be covered. The workshop will also go over some of the more advanced features of SQL such as using the HAVING clause and sub-queries. A discussion of the benefits of using PROC SQL to access external databases and the benefits of SQL pushback will be presented as well.

Instructor Bio:   Stephanie Thompson has over twenty years of experience in applying statistical and modeling techniques to solve business problems in various commercial and academic environments. Strong understanding of data structures, a variety of analytical tools, and operating environments.Views problems (opportunities?) in a broad context by examining the interrelations between issues and the local and broader operational framework. Demonstrated skill at effectively communicating and working across multiple functional areas and at all organizational levels. Stephanie has made dozens of presentations at local, regional, and international meetings and conferences to technical and non-technical audiences.

 

 

 
Copyright © 2018 SouthEast SAS Users Group. All Rights Reserved.