Posted by: btadams | February 8, 2011

Welcome to VaSUG

Tuckahoe Public Library, 1901 Starling Drive, Richmond, VA

Our Summer 2015 meeting will be on June 30th at the Tuckahoe Public Library: Join us for a full day of in-depth presentations with Andrew Karp from Sierra Data Science

9am – 4pm June 30th, 2015

  • 09:00 – 09:30 Morning Networking Meet & Greet
  • 09:30 – 11:45 Working with Dates and Times in SAS Software: The Basics and Beyond – Andrew Karp, Sierra Data Science
  • Among the topics we will cover are:
    1) Core concepts for SAS date, time and datetime variable handling
    2) Using Formats to display the values of date and time data in your
    SAS-generated reports/analyses
    3) Grouping/aggregating your data using internal and custom SAS Formats
    4) Extracting rows of data from a larger file based on date and/or time
    values for inclusion in another file
    5) Creating customized formats for non-standard date ranges, such as
    fiscal years and quarters
    6) Calculating the number of time intervals between two dates using SAS
    7) Determining a future date (e.g., 30 weekdays) from an existing SAS date
  • 12:00 – 01:00 Networking Lunch with Pizza
  • 01:00 – 03:45 PROC SGPLOT – Andrew Karp, Sierra Data Science
  • 1) PROC SGPLOT concepts
    2) PROCs EXPAND and SGPLOT: The Dynamic Duo of Time Series Data Display
    3) Using PROC SGPLOT with PROC MEANS-generated Data Sets

For those who do not know Andrew, he is an independent trainer and SAS
consultant who has provided training for a number of corporations as well as
state governments and federal agencies and on occasion teaches and lectures
abroad. He has been selected by SAS Institute for its Circle of Excellence, recognizing his long-term expertise with SAS Software along with his many contributions to the SAS user community. We are extremely lucky to have him offer to do these presentations at no charge to VASUG. Without considering travel, attending two classes like these would ordinarily be expensive so we are very fortunate to have him offer to present them free of charge.

The handout for each of these presentations will be over a hundred pages so we will need a very good idea of how many copies to print. Printed copies of the handouts will only be available to those who register in advance. Please register for this meeting at the link below

Register for VaSUG Summer Meeting

Details are not yet final but since printing costs will be significant, we
may ask for a small donation to defray some of the expense.

NOTE: The intersection of Parham and Starling Drive has changed quite a bit. The Topeka’s Steakhouse has been replaced by an Aldi’s Food Market.

Special thanks to our Corporate partner TEK Systems for sponsoring this meeting!
VaSUG Sponsors

Tuckahoe Public Library, 1901 Starling Drive, Richmond, VA


Our Winter 2014 meeting will be on December 4th at the Tuckahoe Public Library: Join us for a FREE LUNCH and Board Member Elections!

9am – 4pm December 4th, 2014

  • 09:00 – 09:30 Morning Networking Meet & Greet
  • 09:30 – 9:45 Board Member Elections
  • 09:45 – 10:00 Report on the SAS User Group Summit
  • 10:00 – 10:45 Getting the Warm and Fuzzy Feeling with Inexact Matching – Nat Wooding, J. Sargeant Reynolds Community College
  • 11:00 – 11:55 Oh, The Places You’ll Go: A Primer for SAS Resources, Tips and Hints – Lynn Thompson,
  • 12:00 – 01:00 Free Lunch! Networking with Pizza
  • 01:00 – 01:45 SAS Macro Variables: Symbol Tables, Scope and Documentation – John Meyers, Virginia Commonwealth University
  • 02:00 – 02:45 Time Series Mapping with SAS®: Visualizing Geographic Change over Time in the Health Insurance Industry – Barbara Okerson, Wellpoint
  • 03:00 – 03:45 Census Bureau’s ACS Summary File Retrieval Tool – Ally Burleson-Gibson, U.S. Census Bureau

Please RSVP by email if you intend to attend so we can make a better estimate on how many pies to order. Thanks!

Special thanks to our Corporate partner TEK Systems for sponsoring this meeting!
VaSUG Sponsors


Our Spring 2014 meeting was another great hands-on workshop at VCU on Tuesday March 11th, 2014.



VCU Engineering Esat Hall

  • Morning Session


How to build a macro library using %include, Autocall Library or Stored Compiled Macro Library
Presenter: John Meyers, VCU
While many users take advantage of the SAS® Macro Language, few take full advantage of its capabilities to build and maintain libraries of macros. Macro libraries allow you to control and manage the proliferation of your macros. Macro libraries are extremely useful, and not really all that complicated. %INCLUDE, AUTOCALL LIBRARY or STORED COMPILED MACRO FACILITY will be explained step by step, and examples will simplify the process of how to use these methods.

Taming a Spreadsheet Importation Monster
Presenter: Nat Wooding, J. Sargeant Reynolds Community College
As many programmers have learned to their chagrin, it can be easy to read Excel spreadsheets but problems can arise when one needs to concatenate the data from two or more sheets. Unlike SAS®, Excel does not require that a column have only data of one type so as it scans the columns in a spreadsheet, SAS uses rules to decide the nature of the data in each column. Problems will occur if in one spreadsheet a column is read as characters while in other spreadsheets the data are read as numeric. If there are legitimate character data in the column, then the user will have to decide how to handle them. However, if SAS sees too many blank cells at the start of a column, the incoming variable will be in character format. This paper uses information in dictionary tables to generate SAS code that examines all of the columns (variables) in the workbook and determines which are seen in both formats. Then, data steps read in the “bad” spreadsheets using a data set option to force the problematic columns to be treated as numeric.

  • 12:00 – 01:00 Networking Lunch



  • Afternoon Session


A Better Way to Read the Columns Dictionary Table
Presenter: Dylan Ellis, Senior Programmer Analyst, Mathematica Policy Research
Dictionary tables are an essential tool for the Base SAS programmer. I will give a brief introduction for new users and then demonstrate a helpful transformation that will be valuable for all users – indeed, it has become my de facto step 1 on every assignment. I will also show a simple PROC FCMP function that will help to generalize the approach. Time permitting, I will give a quick demo of using DOSUBL to iterate over the dictionary table to drive macro processes.

Cary at the Bat: When SAS Summary Procedures Strike Out
Presenter: Dylan Ellis, Senior Programmer Analyst, Mathematica Policy Research
Mighty as our Proc Freq, Means and Tabulate may be, there are some tables they just cannot produce. However if we post-process the output data set using a few string and array functions on the _TYPE_ variable, more tables can become a reality – while still being completely automated. The example I will use is a frequency table structured for filtering by variable and value in Excel. With an additional step, this approach can also yield a concise summary of survey data.

Duplicates Unite! Combining Records to Get the Best of Both Worlds
Presenter: Dylan Ellis, Senior Programmer Analyst, Mathematica Policy Research
In my opinion PROC SORT NODUPKEY is tremendously overused. It provides limited information on the types of duplicates and no control over which values are kept from each record. For example, we may want to keep any non-missing information, or other more complex decision rules. I will present a simple utility involving SQL and Proc Report that provides a Stata-like summary of duplicates. Then we will compare strategies for deduplication including SQL and arrays.

NOTE: If you would like a copy of the materials for these hands-on workshops, please send us a note at at


Our Fall 2013 meeting was on November 13th at the Tuckahoe Public Library:

9am – 4pm November 13th , 2013

  • 09:00 – 09:30 Morning Networking Meet & Greet



  • 09:30 – 10:30 New Features in JMP 11


– Mike Drake, SAS Institute


– Andrea Zimmerman, CapitalOne

  • 12:00 – 01:00 Networking Lunch




– Joe Urbi, Wellpoint


– Robert Williams, Wellpoint


– Barbara Okerson, Wellpoint

P.S. download a 30-day evaluation copy of JMP 11 so you can play along with Mike!

Tuckahoe Public Library
1901 Starling Drive
Richmond, VA



Our Summer 2013 meeting was another great hands-on workshop at VCU! Thanks again to Joan Einsman and the VCU IT staff for all their help in arranging this workshop!

9am – 4pm August 28th, 2013
Cabell Library, Room 320
Virginia Commonwealth University
901 Park Ave.
Richmond, VA



  • 02:45 – 4:00 Coder’s Corner Tips & Tricks




VCU Cabell Library

Special thanks to our Corporate Sponsor Randstad for sponsoring this meeting!
VaSUG Sponsors

Calling all SAS Geeks! Join us for a home brew and come ready to discuss the new features of SAS 9.4 and Enterprise Guide 5.1!


Location: Legend’s Brewery
Date: Tuesday, August 27th, 2013 at 5 PM

Our Last Meeting: July 14th, 2011 Special Event. Handouts for the workshop can be downloaded below.


Title: An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way With SAS®

Abstract: Transferring SAS data and analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This workshop provides basic information on how to use Base SAS®9 software to create multi-sheet Microsoft Excel workbooks (for Excel versions 2002 and later). You will learn techniques for quickly and easily creating attractive, multi-sheet Excel workbooks that contain your SAS output using the ExcelXP ODS tagset. The techniques that are presented in this talk can be used regardless of the platform on which SAS software is installed. You can even use them on a mainframe! More in-depth information on this topic will also be presented as time permits.

Bio: Vince DelGobbo is a Senior Systems Developer in the Web Tools group at SAS. This group is responsible for developing the SAS/IntrNet Application Dispatcher and SAS Stored Processes. He is the developer for the HTML Formatting Tools and the SAS Design-Time Controls, and is developing other new Web- and server-based technologies, as well as integrating SAS output with Microsoft Office. He is also involved in the development of the ExcelXP ODS tagset. Vince has been a SAS Software user since 1982, and joined SAS in 1992.


The hand-outs for the Hands-on Workshop can be downloaded below:
Powerpoint Presentation

Introduction to ExcelXP Tagsets Handout

Vince DelGobbo’s ExcelXP Tagset Paper Index

You can view a recording of a previous presentation by clicking the “View Now” link on this page:
An Introduction to Creating Multi-Sheet Microsoft Excel Workbooks the Easy Way with SAS®

Special thanks to our Corporate Partners SunTrust, Smith Hanley, and TEK Systems for sponsoring this meeting!
VaSUG SponsorsVaSUG Sponsors


SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. (r) indicates USA registration.



Posted by: btadams | February 8, 2011

The Joy of Stats

Hans Rosling brings sexy back to the world of statistics:

Posted by: btadams | September 25, 2010

Peter Donnelly shows how stats fool juries

Peter Donnelly shows how stats fool juries

Oxford mathematician Peter Donnelly reveals the common mistakes humans make in interpreting statistics — and the devastating impact these errors can have on the outcome of criminal trials

Posted by: btadams | August 24, 2010

David McCandless: The beauty of data visualization

Another interesting talk on data visualization:

Posted by: btadams | March 4, 2010

Is Pivot a turning point for web exploration?

Another amazing innovation for web data analysis:

Posted by: btadams | September 10, 2009

New: Opportunities Page

If you know of any SAS employment or training opportunities, please post them on the Opportunities page (on the right-hand sidebar under About)

Posted by: btadams | September 10, 2009

Let my dataset change your mindset

A truly inspiring, must-watch presentation that makes me proud to be a number-crunching geek:

Hans Rosling



Get every new post delivered to your Inbox.