Academic Sections
   Back to Basics

Chairs:   Maya Barton
             Abbas Tavakoli

Back to Basics section is designed to sequentially guide new SAS users through the basics of SAS programming.  Presentations introduce the basic concepts of using DATA and PROC steps.  All presentations are given by experienced users with expertise in the specific area being presented.  Topics will include, but are not limited to, the use of these SAS components to address basic analytical, reporting, and data management applications.

Author(s) Title
Jack Shoemaker Ten Things You Should Know About PROC FORMAT
Bill Parman Tailoring Proc Summary for More Efficient Summarizations
William Cade Basketball Analytics: Optimizing the Official Basketball Box-Score (Play-by-Play)
Milorad Stojanovic A Few Usefull Tips When Working with SAS®
Dessa Overstreet Help! I Need to Report a Crime! Why is PROC REPORT So Hard to Use?
Richard Addy Repetitive Tasks and Dynamic Lists: Where to Find What You Need and How to Use It
Jennifer Waller and Maribeth Johnson Chi-Square and T-Tests Using SAS®: Performance and Interpretation
Brian Varney Transitioning from Batch and Interactive SAS to SAS Enterprise Guide
Shane Rosanbalm and Sam Gillett A Quick and Gentle Introduction to PROC SQL
Alexandra Buck Lost in Translation: A Statistician’s (Basic) Perspective of PROC LIFETEST
Rachel Straney Going from Zero to Report Ready with PROC TABULATE
Vince DelGobbo Submitting SAS® Code on the Side
David Shubert Data Entry in SAS® Strategy Management: A New, Better User (and Manager) Experience
Maya Barton and Rita Slater Looking for an Event in a Haystack?

   Beyond the Basics

Chair:   Bill Benjamin

Beyond the Basics addresses advanced programming concepts for intermediate level programmers.  These presentations will push your skills to the next level.  The section will cover topics ranging from ODS techniques, Macro concepts, efficient PROC and DATA step programming features, SAS Enterprise Guide functionality, integration with 3rd party software and databases, innovative applications, data integration, to reporting or analytics solutions available using the SAS Business Intelligence suite.

Author(s) Title
Sally Walczak 5 Simple Steps to Improve the Performance of your Clinical Trials Table Programs using Base SAS® Software
Ronald Fehd Data Review Information: N-Levels or Cardinality Ratio
Sarah Woodruff Data in the Doughnut Hole: Using SAS® to Report on What is NOT There
Bruce Albriton EG and SAS: WORK-ing together
Josh Young Use SAS® to create equal sized geographical clusters of people
Carol Martell PEEKing at Roadway Segments
John Bentley Reading Data from Microsoft Word Documents: It's Easier Than You Think
Peter Eberhardt and Matt Malczewski Your Opinion Counts: Using Twitter to Poll Conference Attendees
Nat Wooding Taming a Spreadsheet Importation Monster
Anna Kurtz and Andrew Dwyer Small Sample Equating: Best Practices using a SAS Macro
David Abbott Computing Counts for CONSORT Diagrams: Three Alternatives
Kendra Jones and Kyla Shelton Averaging Numerous Repeated Measures in SAS Using DO LOOPS and MACROS: A Demonstration Using Dietary Recall Data
Mai Nguyen, Katherine mason and Shane Trahan A Novel Approach to Code Generation for Data Validation and Editing using Excel and SAS
Brian Varney Same Data Different Attributes: Cloning Issues with Data Sets
David Dickey Finding the Gold in your Data - an Introduction to Data Mining
Jiangtang Hu List Processing With SAS: A Comprehensive Survey

   Black Belt

Chair:   Jason Brinkley

Session attendees will find that the Black Belt section highlights some of the most unique SAS® programming innovations.  Advanced topics and techniques will be illustrated with a focus on spreading their utilization to a wider audience.  While not generally for SAS beginners, this session hopes to highlight some of the best original work of users in this region who are finding innovative ways to tackle unusual problems.

Author(s) Title
John R Gerlach Solving Samurai Sudoku Puzzles – A First Attempt
Ronald Fehd Pre-conference seminar: Advanced Macro Design
Ted Shelly Big Data in the Warehouse – Quality is King and SAS Can Do It All
Troy Martin Hughes Binning Bombs When You’re Not a Bomb Maker: A Code-Free Methodology to Standardize, Categorize, and Denormalize Categorical Data
Weijie Cai Introducing the New ADAPTIVEREG Procedure for Adaptive Regression

   Hands On Workshops

Chairs:   Michael Sadof
             Erik Larsen

Need to get the sand out from between your fingers & toes?  Then the Hands-on Workshops, HOW, is where you want to be.  Attendees will get real-world hands-on (or feets-on, if you prefer) experience using SAS and/or JMP.  Hands-on Workshops are a blend of insightful lectures and exercises that demonstrate fresh new approaches in the use of SAS or JMP.  If you enjoy learning by doing, then the HOW is for you!

Author(s) Title
Rupinder Dhillon SAS® Enterprise Guide® 5.1: A Powerful Environment for Programmers, Too!
Andrew Kuligowski and Charu Shankar Know Thy Data: Techniques for Data Exploration
Christianna Williams A Row is a Row is a Row, or is it? A Hands-on Guide to Transposing Data
Paul Dorfman How To DOW
Jennifer Waller How to Use ARRAYs and DO Loops: Do I DO OVER or Do I DO i?
Michael Sadof and Louis Semidey Introduction to Interactive Drill Down Reports on the Web
Peter Eberhardt The Armchair Quarterback: Writing SAS® Code for the Perfect Pivot (Table, That Is)
William Benjamin Extend the Power of SAS® to Use Callable VBS and VBA Code Files Stored in External Libraries to Control Excel Formatting Routines
William Benjamin Give the Power of SAS® to Excel Users Without Making Them Write SAS Code

   Planning and Administration

Chairs:   Kristen Harrington
             Gary Schlegelmilch

As SAS® professionals, we tend to primarily focus on the quality of the programs we write and the results we provide.  However, in order for us to achieve our day-to-day goals, a lot of work has to be done behind the scenes – the initial Planning and Administration aspect of programming.  This section will shine the spotlight on those skills!

Among the topics of interest are:

  • Recruiting, Hiring, and Maintaining qualified staff
  • Training and skill development
  • SAS Certification
  • SAS Server deployment planning and administration
  • Project Management


Author(s) Title
Jack Shoemaker Survey of Big Data Solutions using SAS(r) Technologies
Ranjit Singh Rebuilding SAS Web Application for Web Report Studio 4.3
Jennifer Parks The Many Hats of a SAS Administrator: An Insider’s Guide on Becoming an Indispensable Asset in Your Organization
Jiangtang Hu The Hitchhiker's Guide to Github: SAS Programming Go Social
Adam Hood and Martin Young Your Analytics project is going to fail... Ask me why
Viraj Kumbhakarna A Practical Approach to Process Improvement Using Parallel Processing
Viraj Kumbhakarna Parallel processing techniques for performance improvement for SAS processes: Part II
Joanne Ellwood I heart SAS Users
Darryl Putnam The Disk Detective: A Tool Set for Windows SAS© Administrators
Viraj Kumbhakarna A Hitchhiker's guide for performance assessment & benchmarking SAS® applications
Harjanto Djunaidi and Monica Djunaidi Increasing College Tuition and Its Impacts on Student Loans
Jenni Parks SAS Enterprise Business Intelligence Deployment Projects in the Federal Sector

   Reporting and Information Visualization

Chairs:   Linda Sullivan
             Barbara Okerson

SAS tools and products for reporting and information visualization include BI tools and Enterprise Guide as well as traditional products like Base SAS, SAS/GRAPH, and ODS.  Here's your opportunity to see how others visualize and present data in their applications and reports.  Presentations will include a display of the results as well as programming code.

Author(s) Title
Nancy Landreville Analytical modeling and content analysis mapping with SAS
Jamelle Simmons Not Enough Time To Catch Extreme Observations? Flag and Report with Macros and Arrays
Forrestt Severtson Automating Visual Data Mining Using Bihistograms, the SAS Annotate Facility and SAS Macros
Sheryl Weise Seven Steps to a SAS EBI Proof-of-Concept Project
DJ Penix Seamless Dynamic Web (and Smart Device!) Reporting with SAS®
Daniel Ralyea Instant Disaggregation: Using the macro language to provide reports with parallel structure across different subsets of the data set
Joseph Urbi Case Study: Migrating an Existing SAS Process to Run on the SAS Intelligence Platform
Carlos Piemonti Mobile Reporting at University of Central Florida
Evangeline Collado and Michelle Parente Experiences in Using Academic Data for BI Dashboard Development
Meera Venkataramani Uncovering Patterns in Textual Data with SAS Visual Analytics and SAS Text Analytics
Sharon Avrunin-Becker How to Replicate Excel Stacked Area Graphs in SAS
Barbara Okerson Creating ZIP Code-Level Maps with SAS®
Nat Wooding A Map is Just a Graph Without Axes
Darrell Massengill "Google-like" Maps in SAS
Emma Frazier, Shuyan Zhang and Ping Huang SAS Macros to Produce Publication-ready Tables from SAS Survey Procedures
Daniel Clark, Pradeep Podila, Edward Rafalski and George Relyea Hospital Readmissions: Characteristics of readmits within 30 days and beyond 30 days

   JMP

Chairs:   Linda Sullivan
             Barbara Okerson

JMP®, the statistical discovery software from SAS®, provides users with the ability to explore and discover hidden stories and trends in data while easily converting this information into visual displays to share with end users.  Hear how JMP has been used across a variety of industries to answer questions and facilitate discovery!

Author(s) Title
Melvin Alexander When Little Objective Data Are Available, Find Root Causes and Effects with Interrelationship Digraphs and JMP®
Michael Hecht From Raw Data to Beautiful Graph using JSL
Barbara Okerson I'm a SAS Programmer. Why should I JMP?
Mira Shapiro Using JMP® Partition to Grow Decision Trees in Base SAS®

   Pharma & Healthcare

Chairs:   Mike Molter
             Steve Noga

Papers in the Pharma & Healthcare section will focus on using SAS® technologies to find solutions for analysis and reporting as it relates to drug/device discovery, disease prevention, patient care, the needs of insurance providers, as well as local and national healthcare agencies.  Possible topics include:

  • Discussions of the use of SAS® Drug Development, SAS Clinical Data Integration and SAS Patient Safety.
  • Various aspects of implementing CDISC standards such as the Study Data Tabulation Model (SDTM) and the Analysis Data Model (ADaM).
  • Solutions to common problems that can surface during a clinical trial such as those that occur in clinical programming and biostatistics.
  • The use of healthcare data to evaluate quality of care in any healthcare setting.
  • The use of SAS to provide optimization of clinical research or analysis of healthcare data.
  • The impact of health policy changes and solutions for providers or insurers.
Author(s) Title
Mike Molter Coding For the Long Haul With Managed Metadata and Process Parameters
John R Gerlach and Igor Kolodezh Imputing Dose Levels for Adverse Events
Pradeep Podila, George Relyea and Daniel Clark Identifying patient characteristics towards reducing hospital readmissions: Propensity Score Matching using JMP Pro
Sanjay Matange Patient Profile Graphs Using SAS®
John Fulda Using SAS to read, modify, copy, and create comments on a Case Report Form in .pdf format
Peter Eberhardt and Wei Liu The Baker Street Irregulars Investigate: Perl Regular Expressions and CDISC
Satish Garla What Do Your Consumer Habits Say About Your Health? Using Third-Party Data to Predict Individual Health Risk and Costs
Madhi Saranadasa Kaplan-Meier Analysis: A Practical Guide For Programmers
Johnita Byrd and Felix Fernandez Using the 7th Edition American Joint Committee on Cancer (AJCC) Cancer Staging Manual to Determine Esophageal Cancer Staging in SEER-Medicare Data
Jack Shoemaker Survey of Population Risk Management Applications Using SAS(r)

   Statistics and Data Analysis

Chairs:   Brian Varney
             Jeffrey Kromrey

Presentations in the Statistics and Data Analysis section address the transformation of raw data into useful information.  For SESUG 2013, this section will include topics that will be of interest to a wide range of SAS® users, including statistical analysts, statistical programmers, statisticians and DATA step programmers.  Papers do not need to present new statistical methods, although such topics are always welcome.  Innovative applications of established methods to new or unusual scenarios are also appropriate for this section.  In addition, presentations are sought that involve the application of methods that many users of SAS statistics may not commonly see, such as methods for categorical, longitudinal or censored data.  Methods to facilitate analysis of very large data arrays, such as those that result from genetic studies or national surveys, are also sought for this section.  It is important to keep in mind that the audience will represent a broad spectrum of users of statistical methods, so the presentations can range from basic applications to complex analyses.

Author(s) Title
Taylor Lewis PROC SURVEYSELECT as a Tool for Drawing Random Samples
Fengjiao Hu and Robert Johnson A SAS Macro for Finding Optimal k-Means Clustering in One Dimension with Size Constraints
Pei-Chen Wu, Patricia Rodriguez de Gil, Thanh Pham, Diep Nguyen, Jeanine Romano, Jeffrey D. Kromrey and Eun Sook Kim SAS® Macros CORR_P and TANGO: Interval Estimation for the Difference between Correlated Proportions in Dependent Samples
Kevin Coughlin, Jeffrey Kromrey and Susan Hibbard Using Predetermined Factor Structures to Simulate a Variety of Data Conditions
Erik Bowe and Steven Merritt Forecasting Enrollment in Higher Education using SAS Forecast Studio
Peter Wludyka Analyzing Multiway Models with ANOM Slicing
Dennis Beal Maximizing Confidence and Coverage for a Nonparametric Upper Tolerance Limit for a Fixed Number of Samples
Steve Fleming Dealing with Missing Data for Credit Scoring
Robert Seffrin Evaluating the Accuracy Assessment Methods of a Thematic Raster through SAS® Resampling Techniques and GTL Visualizations
Isaac Li, Yi-Hsin Chen and Jeffrey Kromrey Evaluating the Performance of the SAS® GLIMMIX Procedure for the Dichotomous Rasch model: A Simulation Study
Anh P. Kellermann, Jeanine Romano, Patricia Rodríguez de Gil, Than Pham, Patrice Rasmussen, Yi-Hsin Chen and Jeffrey D. Kromrey GEN_OMEGA2: A SAS® Macro for Computing the Generalized Omega-Squared Effect Size Associated with Analysis of Variance Models
Paulo Macedo Area under a Receiving Operating Characteristic (ROC) Curve: comparing parametric estimation, Monte Carlo simulation and numerical integration
Wayne Thompson You like What? Creating a Recommender System with SAS
Bethany Bell, Whitney Smiley, Mihaela Ene, Phillip Sherlock, Jr. and Genine Blue An Intermediate Primer to Estimating Linear Multilevel Models using SAS® PROC MIXED
Maura Stokes Modeling Categorical Response Data

   Coder's Corner

Chairs:   Sharon Avrunin-Becker
             Sarah Woodruff

Authors in Coders’ Corner ride the wave of a variety of SAS concepts with short 10-minute presentations, each focusing on a single topic.  Don’t want to have a boatload of your time tied up with any one idea?  Come and learn from up-and-comers as well as seasoned SAS captains.  These dips into SAS may include powerful but obscure syntax or coding suggestions, work-arounds for hard-to-correct errors, discussion of undocumented features, and algorithms or macros that may be widely applicable but underutilized.  Coders’ Corner is an oasis of ideas!

Author(s) Title
Robert Williams Let SAS® Do the Coding for You
Philip Busby Format Follows Function: User-Written Formats and User-Written Functions that talk to the SAS Metadata Server
Ronald Fehd Writing Macro Do Loops with Dates from Then to When
Ronald Fehd Database Vocabulary: Is Your Data Set a Dimension (LookUp) Table, a Fact Table or a Report?
Bill Parman Report Dates: %Sysfunc vs Data _Null_;
Priya Suresh and Elizabeth Heath Summarizing Character Variables Using SAS® Proc Report
Ted Shelly Proc Compare – The Perfect Tool for Data Quality Assurance
Stacey Slone The Power of Combining Data with the PROC SQL
Rachel E Patzer and Laura Plantinga Comparisons of SAS Mixed and Fixed Effects Modeling for Observed over Expected Count Outcomes in the Presence of Hierarchical or Clustered Data
David Abbott Selecting Earliest Occurrence: Watch Your Step
Elizabeth Leslie Handling data with multiple records per subject: 4 quick methods to pull only the records you want
Feng Liu Fit Discrete Distributions via SAS Macro
Andrew Kuligowski The BEST. Message in the SASLOG
Liang Wei, Laurie Barker and Paul Eke Array Applications in Determining Periodontal Disease Measurement
Forrestt Severtson Automating Data Vetting Using SAS Macros
Michael Leitson Using Arrays to Handle Transposed Data
Michael Leitson and Elizabeth Leslie How SAS Processes If-Then-Else Statements
Penny Eckert Don't Get the Finger... You Know the FAT Finger Creating a Modular Report Approach using BASE SAS
Elizabeth Schreiber PROC FORMAT in DATA Step mathematics
Sebastian Perez Using Heatmaps and Trend Charts to Visualize Kidney Recipients’ Post- Transplant Hospitalizations
Sheryl Weise Resistance is Futile: SAS Enterprise Guide Assimilates PC SAS
Carol Martell The Short-Order Batch
Spencer Childress How Many Licks to the Center of that Column?
Song Chen Using SAS to calculate Modularity of a Graph for Community Detection Problems
Ruiwen Zhang Explore RFM approaches using SAS

   Code Doctors

“Doctor, Doctor give me the news” – the good news is the code doctors will be back to help you with your coding ills.  If you are struggling with a particular problem, bring the code and sample data on a memory stick and the code doctors will help you diagnose the problem.  If you have a general “how does this work” question drop by for an explanation.

   Posters

Chairs:   Dennis Beal
             Darryl Putnam

The Poster Section covers any area including: SAS® fundamentals; statistics; data analysis; data visualization; application of statistical graphics: business intelligence; medical research, data mining; survey/panel results; social networking; and industry applications for the pharmaceutical, finance, education and entertainment industries; and all uses of SAS software.  Ideally, a well-constructed poster is self-explanatory, achieving both coverage and clarity.  There will be a time to meet authors and to discuss their posters (“Meet the Presenter” session).

Author(s) Title
Abbas Tavakoli, Joan Culley, Hein Laura, Blake Frazier and Williams Amber Using SAS to Examine Social Networking Difference between Faculty and Students
Imelda C. Go and Abbas S. Tavakoli Getting Out of the PROC PRINT Comfort Zone to Start Using PROC REPORT
Dana Nickleach, Yuan Liu, Adam Shrewsberry, Robert Steven Gerhard, Kenneth Ogan, Sungjin Kim and Zhibo Wang SAS Macros to Conduct Common Biostatistical Analyses and Generate Reports
Zi Feng Let the Code Report the Running Time
Y. Christina Song Not just another macro
Rebecca Ottesen and Jamelle Simmons SAS Web Editor, is it the right choice for you?
Jamelle Simmons Does the Percentage of College Student and Military Personnel Group Quarters Affect Political Contributions per Zip Code? Visualization with PROC GMAP
Yi-Hsin Chen, Isaac Li and Jeffrey Kromrey GLIMMIX_Rasch: A SAS® Macro for Fitting the Dichotomous Rasch Model
Isaac Li and Jeffrey Kromrey POSTEQUATE: A SAS® Macro for Conducting Non-IRT Test Post-equating
Andrea Villanes Arellano Analytical Approach for Bot Cheating Detection in a Massive Multiplayer Online Racing Game
Srinivasa Madhavan, Steven Blair and Abbas Tavakoli Role of Fibrinogen, HDL Cholesterol and Cardio Respiratory Fitness in Predicting Mortality Due to Cardio-vascular Disease: Results From the Aerobics Center Longitudinal Study
Bruno Vizcarra and Amang Sukasih Comparing PROC MI and IVEWare callable software
Troy Martin Hughes Winning the War on Terror with Waffles: Maximizing GINSIDE Efficiency for Blue Force Tracking Big Data
Dhanashree Gadkari Stock Prices Analysis

   Bonus

Chair:   Andrea Zimmerman

The Bonus section is for those gems that almost slipped through the cracks and for any encore papers that you might have missed the first time. Please check the app for the encores that will be added to these two stellar talks.


Author(s) Title
Peter Eberhardt and Xiao Jin Qin ISO 101: A SAS® Guide to International Dating
Dylan Ellis RUN_MACRO Run! With PROC FCMP and the RUN_MACRO Function from SAS® 9.2, Your SAS® Programs Are All Grown Up

 
 
 
 
 
 
Copyright © 2013 SouthEast SAS Users Group. All Rights Reserved.