This presentation is a collection of stories from projects I've contributed to over the years in the data for good space. Because most of the data for good examples focus helping with natural disaster recovery, climate change, or working to prevent child abuse, I end with some a few lighthearted examples of working on data (Star Wars and World of Warcraft) that was just fun and fit in with some of my personal passions. ... View more

Sorting in SAS® is an expensive process in terms of both time and resources consumed. In this session, prepare to explore some of the common and lesser known sorts that SAS provides. Become like the sorting hat in Harry Potter! Instead of waiting with baited breath for your team (or data) to be sorted, get the inside scoop and learn about the dynamic processes that go on behind the scenes during sorting that will enable you to pick the very best sort for your circumstances. Learn about some fantastical, magical SAS sorting teams: bubble sort, quick, threaded and serpentine. Behold the effervescent bubble sort! In a hurry? Take a look at the quick sort. Looking for superior efficiency? Consider the threaded sort. See how the hissing serpentine sort in SAS, like the slithering serpent Nagini sliding surreptitiously through walls, can come in handy! Which sort will you choose – or which sort will choose you? ... View more

New Platform, New Servers, New Engines. This paper attempts to discuss updates for programmers migrating to SAS 9.4. It also is an awareness exercise for those already in SAS 9.4 and wishing to leverage updates. ... View more

New Platform, New Engines, New servers. This paper will discuss lots of updates for programmers migrating to SAS 9.4. It also attempts to create awareness for users already in SAS 9.4 to leverage the new updates. ... View more

Get to know the #1 rule for data specialists: Know thy data. What are the common keys for joins? Are there data type conflicts? How to locate changed variable names? How to reorder variables in the dataset without physically typing in all the names but instead using metadata to perform this action. In this session, you will learn to employ powerful PROC SQL’s dictionary tables to easily explore aspects of your metadata. Data, code, paper for this presentation available for download on Github  ... View more