Boston Area SAS® Users Group

BASUG Quarterly Meeting Announcement

Please join us for these informative talks, and consider staying for the afternoon class (separate event), taught by Peter Eberhardt. For information on the training, please visit the training announcement.

After the meeting, we will provide an informal light buffet lunch for all attendees. We hope you can stay for this opportunity to network and socialize with your fellow SAS users.

Topic New Directions using SAS®: Try something different!
When Thursday, November 20th, 2014
8:15AM - Noon
Where Microsoft New England Reasearch and Developement Center (NERD)1
One Memorial Drive
Conference Center, First Floor
Cambridge MA 02142
Directions Please visit the meeting site directions page
How to Register Individual, on-line registration required
Payment $10 – if paid on-line by Monday 11/10/2014
$15 – if paid on-line by NOON on 11/19/2014
$20 – at the door (checks only – pre-registration required)
Contact If you have questions about the meeting, please contact the meeting organizers.

Agenda *

8:15AM - Sign-in and Breakfast
8:45AM - Opening Announcements
9:00AM - "The Armchair Quarterback: Writing SAS® Code for the Perfect Pivot (Table, that is)",
by Peter Eberhardt, Fernwood Consulting Group Inc.
9:50AM - Break
10:05AM - "New Performance Features in SAS® 9.4",
by Paul Grant, SAS Institute Inc.
10:45AM - Break
11:05AM - "I Object: SAS® Does Objects with DS2",
by Peter Eberhardt, Fernwood Consulting Group Inc.
Noon - Networking Lunch

* Note: Times (and sequence) are approximate and subject to change. Please re-visit the BASUG website for updated information.

Speaker biographies and abstracts

"The Armchair Quarterback: Writing SAS Code for the Perfect Pivot (Table, That Is)"

by Peter Eberhardt, Fernwood Consulting Group Inc.

“Can I have that in Excel?" This is a request that makes many of us shudder. Now your boss has discovered Excel pivot tables. Unfortunately, he has not discovered how to make them. So you get to extract the data, massage the data, put the data into Excel, and then spend hours rebuilding pivot tables every time the corporate data are refreshed. In this presentation, you learn to be the armchair quarterback and build pivot tables without leaving the comfort of your SAS environment. We cover the basics of Excel pivot tables and, through a series of examples, will learn how to augment basic pivot tables first in Excel, and then using SAS. No prior knowledge of Excel pivot tables is required.

"I Object: SAS Does Objects with DS2"

by Peter Eberhardt, Fernwood Consulting Group Inc.

The DATA step has served SAS programmers well over the years, and although it is powerful, it has not fundamentally changed. With DS2, SAS has introduced a significant alternative to the DATA step by introducing an object-oriented programming environment. In this paper, we share our experiences with getting started with DS2 and learning to use it to access, manage, and share data in a scalable, threaded, and standards-based way.

Peter Eberhardt

Peter Eberhardt is a long time SAS consultant; his company, Fernwood Consulting Group Inc., is a SAS Alliance partner. In addition to presenting at user groups locally and internationally, Peter also is also very involved in helping to organize and run user conferences. For several years he has been a section chair, and now part of the content advisory team, at SAS Global Forum. In 2008 and again in 2012 he was the Academic Chair for SESUG. In 2015 he is the Academic Chair for PharmaSUG China, to be held in Shanghai.

"New Performance Features in SAS 9.4"

by Paul Grant, SAS Institute Inc.

This presentation is an introduction to the three main performance features in SAS 9.4: DS2, FedSQL, and the High Performance Analytics PROCs. After reviewing the reasons why they were developed and describing the environment they were built to run on, we’ll take a brief look at each and discuss why they’re important to SAS programmers.

Paul Grant

Paul Grant is a Senior Technical Architect at SAS. He assists federal government agencies adopt SAS' new high performance technologies. He chaired SUGI 21 in Chicago in 1996 and co-chaired NESUG '94 in Philadelphia. He has been active in the Boston Area SAS Users Group for many years and was BASUG Chairperson from 1995 - 1998. He originated Coders’ Corner and the Sunday Workshops at SUGI and NESUG. Paul has been using SAS software in a variety of industries since 1981. He has been at SAS since 1998.

BASUG Contacts

Mailing Address:

Email Our Webmaster

1 The Microsoft New England Research & Development Center (NERD) is a research and software innovation campus located in the heart of Cambridge, Massachusetts. The NERD vertical campus spans two buildings with its primary presence and conference center located at One Memorial Drive and a recently renovated and expanded space located at One Cambridge Center. NERD is home to some of Microsoft’s most strategic teams including Microsoft Research New England, Microsoft Application Virtualization (App-V), SharePoint Workspace, Microsoft Technical Computing, Microsoft Advertising, Microsoft Lync, Microsoft Office 365 and more. NERD has become a hub of activity for the local tech community and has hosted more than 500 events and welcomed more than 40,000 visitors during the past two years.