November 2016 Meeting

November 2016 Meeting

Our November meeting is shaping up to be another informative and engaging time.

Please Note: Registration for the meeting will be closed on Thursday, November 10th at noon. We need to provide a list of attendees to campus security ahead of time, so we cannot accept any late or on-site registrations. Sorry for any inconvenience.

Time & Date

Friday, November 11, 2016
9:00 AM to Noon


The Hartford
1 Hartford Plaza (mailing address)
145 Cogswell St (approx. use for GPS)
Hartford CT 06155

Room TA.0024


Generating useful data structures from parent child tables
Bryan Barbera, Eversource
Develop horizontal and vertical structures that can be used to consolidate information for SAS reports and exports to Excel pivot tables for non-SAS analysts.  This presentation will go over the program used to generate the structures, anatomy of the structures and various ways that the structures have been used.
Bryan Barbera is a Performance Manager at Eversource and uses SAS to solve various analytical and data consolidations needs.

Geographical Maps in SAS with Annotations
Mike Frish, The Hartford
Colorful, informational pictures attract attention when presenting data, particularly maps.  They also can communicate the message more directly than bullets or words.  This presentation will show basic mapping code, with explanations of the code and the goal of the different display types.  Also discussed will be some tricks and interesting things maps can do, including how to generate an animated .gif map.
Mike Frish has worked at the Hartford for a little more than 4 years. He has held roles in Commercial Auto Rate Implementation and Property Reserving, and is currently a member of Auto Reserving. Mike graduated from UConn in 2010 with a B.A. in Actuarial Science (Mathematics).  He has been using SAS for most of these 4 years.

Automation of Date Macro Variable
Pujan Shah, The Hartford

Code which runs at regular intervals can be made easier to support and maintain through the addition of automating date logic.  Using the system date and minimal macro code, this presentation will give an example.

Pujan Shah has a bachelor of science from Ohio State University with a major in actuarial science and a minor in economics. He was as pension analyst at Towers Watson before joining The Hartford in May of this year.  At The Hartford he works as claims actuarial analyst for auto physical damage claims.

SAS at The Hartford – a brief overview of the technology at use
Dennis Rihm, The Hartford


Leave a Reply