HASUG Meeting Nov 20, 2014 Announcement and Directions

[Charles Patridge]

NEXT HASUG MEETING

ANNOUNCEMENT

 

Our next meeting is on:

Thursday, November 20, 2014

At

Yale  

IFE Auditorium (Ground Floor) – Suite 157

300 George Street

New Haven, CT 06511

 

Hosted by Yale Program on Aging

 

from 9:00 am to noon

 

The HASUG website is currently unavailable for updating.  Therefore,

please register for the meeting via email to Mike Mancini:   MMan...@foxwoods.com

Refreshments to be served, & time for conversation, beginning at 8:30.

 

Our topics and Speakers are:                                                                                                          

 

Data Mining with SAS Enterprise Miner

Robert Class, Cigna

 

1)      Overview (What is EM and Where does it fit)

2)      The SEMMA Methodology

3)      An Example of building a model

a)      Getting in the data

b)      Sampling

c)      Exploring

d)      Manipulation (creating variables, transformations)

e)      Modeling (creating multiple models)

f)       Analyzing the model (including comparing different models)

g)      Scoring Code (exporting the model)

4)      Review of flow in the Diagram

5)      Other features & Questions

 

Bob Claus is a hands-on Business Analytic Professional with extensive experience partnering with all levels of management to understand business direction, mine complex data, deliver actionable information for decision making in the P&C Insurance, Healthcare, Banking and Utilities Industries.  He is known for technical depth and breadth coupled with a unique ability to drive projects through to implementation

Bob introduced Enterprise Miner into Fleet bank in 2000 to develop an automated Loan Origination system, by creating Credit Risk Scoring Models.  He is currently using EM to develop a series of risk & other models to support health evaluation & improvement programs and a Customer Life Time Value analysis. He has over 25 years of experience using SAS products and now uses SAS, EG and EM in conjunction with Teradata.

 

Coder’s Corner

How to do a Text Search across many EG Projects

Charles Partridge, PDPC, Ltd.

 

 

Chuck Patridge is an IIA Data Manager since June 2008.  His expertise is using the SAS software since 1979 in a variety of business environments such as HR, Technical Support, Claims, Actuarial, Reinsurance, Government, Education, Transportation, Relocation Services , Marketing, Financial, Pharmaceutical and Insurance (Life, Health and P&C) with most career experience in the Property Casualty Insurance arena.  He has presented a number of papers to various SAS user groups including  SAS Global Forum and publishing a white paper on “Fuzzy Match/Merge“ in conjunction with SAS Institute.  Chuck also started the first local SAS User Group – Hartford Area SAS User Group (www.hasug.org) – HASUG in 1983 as well as created and maintains another SAS user website – www.sconsig.com (SAS Consultant Special Interest Group) since 1994.

 

How to do an iterative data pull for a specified list from a very large database

Robyn Guimont, Optum

This presentation will discuss code for an iterative data pull process that can be used to extract data for a specified list of members (or whatever your selection value is) from a very large database.  For those people who do not have the luxury of being able to set up a temporary table to use to pull data directly from a database, this is an alternative that can help to limit the amount of data to just what is needed.

 

Robyn Guimont is an Associate Director of Business Analysis with Optum, which is part of UnitedHealth Group, dealing mainly with claims, membership and provider analysis.  She has been coding in SAS for around 20 years, most of her skills learned from OJT.  Her motto is, 'A Good programmer codes, a Great programmer steals', so that's why she is willing to share this code with the Great programmers of HASUG!

 

PRELOADFMT comes to your rescue, it brings missing categories to life in summary reports

Niraj Pandya, Element Technologies Inc.  

In clinical trials data analysis and reporting, one always comes across producing categorical tables used for analysis.  Provided with lots of different kind of data types such as labs, adverse events, physical examination, concomitant therapies etc. and multiple categories for several categorical variables, it becomes difficult sometimes to impute 0 values for categories which are missing altogether for a particular variable. SAS provides multiple options to handle such cases and produce output with all the categories even if some don’t exist in the data. This paper concentrates on different work around methods and will discuss details of implementing each technique.

 

Niraj Pandya is a lead statistical/clinical programmer with BMS. Prior to joining BMS, he worked with Pfizer for 5 years. He has authored many technical papers on the use of SAS programming for clinical trials data analysis.

 

Data looping macro example.

James C. Whanger 

This presentation will show examples of code used to prepare, clean, and analyze survey data.  Code makes use of PROC SQL and macros.

 

James C. Whanger has an eclectic background which includes a previous career in medical sales, graduate work in I/O Psychology where he first began learning SAS, applied psychological research for SAIC in a military research lab where he primarily used SPSS and most recently has worked in the Database Marketing Dept at Foxwoods Resort Casino where he has, in part, worked on Customer Satisfaction Survey data.

 

 

 

DIRECTIONS:                                                                                                                                 

YALE

300 George Street

Suite 157, IFE Auditorium (Ground Floor)

New Haven 06511

 

Due to construction parking can vary day by day.   Please allow time to find parking and get to the meeting.

 

There are a number of public parking lots close to 300 George Street. Temple Medical Garage is closest and is connected to Temple Medical Building.  Enter garage on George Street just after College Street. The rate is $4.00 an hour, maximum is $16.00.

 

Kirks public parking is on Crown Street, 1 block north (towards the New Haven Green) of George Street, between College and High Street, and right next To Louis Lunch.  The rate is $7.00 per day.

 

Street parking can be a problem and depending on the location costs 25¢ for 20 minutes.

 

 

 THE HASUG Steering Committee

The HASUG.org website is updated with the most current FLASH, announcements and directions to next meeting.

[Charles Patridge]

Just a reminder about this Thursday HASUG meeting.

We only have 14 or so people registered thus far.

HASUG Steering Committee

 

---

From: Charles Patridge <charles_s...@prodigy.net>
To: Members HASUG <ha...@googlegroups.com>
Cc: HASUG-L Steering Committee <hartford-area-...@googlegroups.com>
Sent: Tuesday, November 11, 2014 5:26 PM
Subject: HASUG Meeting Nov 20, 2014 Announcement and Directions

Suite 157 , IFE Auditorium (Ground Floor)

New Haven 06511

 

Due to construction parking can vary day by day.   Please allow time to find parking and get to the meeting.

 

There are a number of public parking lots close to 300 George Street . Temple Medical Garage is closest and is connected to Temple Medical Building .  Enter garage on George Street just after College Street . The rate is $4.00 an hour, maximum is $16.00.

 

Kirks public parking is on Crown Street , 1 block north (towards the New Haven Green) of George Street , between College and High Street, and right next To Louis Lunch.  The rate is $7.00 per day.

 

Street parking can be a problem and depending on the location costs 25¢ for 20 minutes.

 

 

 THE HASUG Steering Committee

The HASUG.org website is updated with the most current FLASH, announcements and directions to next meeting.

--
You received this message because you are subscribed to the Google Groups "Hartford Area SAS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hartford-area-sas-us...@googlegroups.com.
To post to this group, send email to hartford-area-...@googlegroups.com.
Visit this group at http://groups.google.com/group/hartford-area-sas-user-group.
For more options, visit https://groups.google.com/d/optout.