MWSUG 2007 Conference Proceedings

Des Moines, Iowa
October 28-30, 2007

Download the entire 2007 conference proceedings as a ZIP file (11.4MB)

Individual Paper PDFs:

Application Development

A01. SAS®-with-Excel Application Development Tools and Techniques, Expanded Edition
LeRoy Bessler, Assurant Health, Milwaukee, WI

A02. Passing Data Set Values into Application Parameters
Lingqun Liu, The University of Michigan, Ann Arbor

A03. Table Lookups...You Want Performance?
Rob Rohrbough, Rohrbough Systems Design, Inc., Omaha, NE

A04. Simple Rules to Remember When Working with Indexes
Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA

A05. FreqLibname: A Data Review Routine For All Memnames in a Libname
Ronald J. Fehd, Centers for Disease Control and Prevention, Atlanta, GA

A06. Converting From a Legacy Reporting System to Data Warehouse Reporting Utilizing SAS® BI Tools
Kate Glover, Sinclair Community College, Dayton, OH

A07. Design and Implementation of Operational Dashboards on SAS® Information Delivery Portal
Grace Jiang, RCI, Carmel, IN
Jeremy Terbush, RCI, Carmel, IN

A08. Collaborate with SAS® Users Around the World with sasCommunity.org
Kirk Paul Lafler, Software Intelligence Corporation
Charles Edwin Shipp, Shipp Consulting

A09. How to Implement Security Systems Using SAS®
David P. Wells, Sinclair Community College, Dayton, OH

A10. Develop, Create and Deploy Sample Custom Tasks in SAS® Enterprise Guide
*** BEST PAPER ***
Steve Gunawan, Resort Condominiums International, Carmel, IN

A11. Writing Testing-Aware Programs that Self-Report when Testing Options are True
Ronald J. Fehd, Centers for Disease Control and Prevention, Atlanta, GA

Data Visualization & Graphics

D01. Chart Smart: Design and Build SAS® Graphs That Inform and Influence
LeRoy Bessler, Assurant Health, Milwaukee, WI

D02. A Macro for Producing Graphs used in Assessing a Spectrum
David W. Meek, USDA-ARS-MWA National Soil Tilth Laboratory, Ames, IA

D03. SAS® Graphs for BlackBerry, iPhone, PowerPoint, Word, Web/HTML, PDF, or RTF
LeRoy Bessler, Assurant Health, Milwaukee, WI

D04. SAS/GRAPH® Annotate Macro Tutorial
*** BEST PAPER ***
Kathy Shelley, Department of Statistics, Iowa State University, Ames, IA

D05. Multi-Media Wizardry: How To Make ODS Outputs That “Dance and Sing”
LeRoy Bessler, Fox Point, WI

D06. Two Macros for Producing Graphs to Assess Agreement Between Two Variables
David W. Meek, USDA-ARS-MWA National Soil Tilth Laboratory, Ames, IA

Hands-On Workshops

HOW05. List Processing Basics: Creating and Using Lists of Macro Variables
Ronald J. Fehd, Centers for Disease Control and Prevention, Atlanta, GA
Art Carpenter, CA Occidental Consultants, Vista, CA

HOW06. Dynamic Projects in SAS® Enterprise Guide®: How to Create and Use Parameters
Lora D. Delwiche, University of California, Davis, CA
Susan J. Slaughter, Avocet Solutions, Davis, CA

HOW07. Creating Multi-Sheet Excel Workbooks the Easy Way with SAS®
Vincent DelGobbo, SAS Institute Inc., Cary, NC

SAS Presents

SAS01. Identifying and Overcoming Common Data Mining Mistakes
Doug Wielenga, SAS Institute Inc., Cary, NC

SAS02. Best Practices for Managing Predictive Models in a Production Environment
Robert Chu, SAS Institute Inc., Cary, NC
David Duling, SAS Institute Inc., Cary, NC
Wayne Thompson, SAS Institute Inc., Cary, NC

SAS04. User-Written DATA Step Functions
Jason Secosky, SAS Institute Inc., Cary, NC

SAS06. Getting Started with the DATA Step Hash Object
Jason Secosky, SAS Institute Inc., Cary, NC
Janice Bloom, SAS Institute Inc., Cary, NC

Statistics & Data Analysis

S01. Analyzing Survey Data Using Decision Trees
Morgan Wang, Department of Statistics, University of Central Florida

S02. RANDOM and REPEATED statements - How to Use Them to Model the Covariance Structure in Proc Mixed
*** BEST PAPER ***
Charlie Liu, Eli Lilly & Company, Indianapolis, IN
Dachuang Cao, Eli Lilly & Company, Indianapolis, IN
Peiqi Chen, Eli Lilly & Company, Indianapolis, IN
Tony Zagar, Eli Lilly & Company, Indianapolis, IN

S03. Fit Your Data into the FREQ Procedure and More
Dachao Liu, Northwestern University, Chicago, IL

S05. Using Data Mining Techniques to Predict Student Development and Retention
Morgan Wang, Department of Statistics and Actuarial Science, University of Central Florida

S06. Using the WHO Drug Dictionary for Reporting Clinical Trials
Thomas E Peppard, deCODE Genetics, Brighton, MI

Tutorials and Solutions

T01. Exploring DICTIONARY Tables and SASHELP Views
Kirk Paul Lafler, Software Intelligence Corporation, Spring Valley, CA

T02. SAS® Macros for Quick Summary Reporting and Uppercasing of All Variables
Craig Balog, Cleveland Clinic, Cleveland, OH

T04. Advanced PROC REPORT: Doing More in the Compute Block
Arthur L. Carpenter, California Occidental Consultants, Vista, CA

T05. Using SAS® to Control and Automate a Multi SAS Program Process
Patrick Halpin, dunnhumby USA, Cincinnati, OH

T06. “Backup Early, Backup Often”: Backup Your SAS® Programs using SAS Display Manager®
Paul D. McDonald, MBA, Overland Park, KS

T08. 44 Tricks with the 4mat Procedure
Ben Cochran, The Bedford Group, Raleigh, NC

T09. How To Use Proc SQL select into for List Processing
Ronald J. Fehd, Centers for Disease Control and Prevention, Atlanta, GA

T10. Using 22 Easy Tricks with ODS to Generate Colorful Reports
Ben Cochran, The Bedford Group, Raleigh, NC

T11. “Backup From The Startup”: Keep a Constant Backup Your SAS® Logs and Listing Output From SAS Display Manager® in Microsoft Windows
*** BEST PAPER ***
Paul D. McDonald, MBA, Overland Park, KS

T13. Translating Microsoft Character Date-Time Strings to SAS DATETIME Variables: Reading Microsoft Date-Time Stamped Logs in SAS
Paul D. McDonald, MBA, Overland Park, KS