MWSUG 2006 Conference Proceedings

Detroit, Michigan
October 22-24, 2006

Download the entire 2006 conference proceedings as a ZIP file (13.3MB)

Individual Paper PDFs:

Application Development

AD01. Futrix V5 – Integration with the SAS BI Server for OLAP Cubes
D.J. Penix, Pinnacle Solutions, Inc., Indianapolis, IN

AD02. Pruning the SASLOG – Digging into the Roots of NOTEs, WARNINGs, and ERRORs
Andrew T. Kuligowski, Nielsen Media Research

AD03. That's the Signpost Up Ahead— Your Next Stop, SAS IML
Gary Allen, Senior Database Analyst, Wunderman Brands

AD04. Creating a Windows Service using SAS® 9 and VB.NET
David Bosak, COMSYS, Kalamazoo, MI

AD05. Modifying The LogParse PassInfo Macro to Provide a Link between Product Usage in Rtrace Log and Time Used in Job Log
Ronald J. Fehd, Centers for Disease Control and Prevention, Atlanta, GA

AD06. SAS® Enterprise Guide® custom tasks
Alex Dmitrienko, Ph.D., Eli Lilly and Company, Indianapolis, IN

AD07. A SAS/AF® Utility for Managing Stored SCL Lists
Derek Morgan, Washington University Medical School, St. Louis, MO

AD08. A Picture is Worth a Thousand Data Points: Using SAS Arrays, LAG Functions and ODS to Create a Flexible Survey Interviewer Tracking Chart
Joe Murphy, RTI International, Research Triangle Park, NC
Adam Safir, RTI International, Research Triangle Park, NC
Susan Myers, RTI International, Research Triangle Park, NC
Christy Hottinger, RTI International, Research Triangle Park, NC

AD09. Parsing Variable Lists: A Macro Function for Macros
Jimmy Z. Zou, Michigan State University, East Lansing, MI

AD10. Leveraging SAS® Portal: Developing an Executive Dashboard with Customizable Data Source
Elibeth R. Carpenter, Comsys, Kalamazoo, MI

AD15. Enhancements to Maps using the Annotate Dataset
David Corliss, Marketing Associates, Bloomfield Hills, MI

Coders' Corner

CC01. An Effective CLEANWORK.SAS® for Windows
John M. Wildenthal, JPMorgan Chase

CC02. Joining Wide Tables With PROC SQL
John M. Wildenthal, JPMorgan Chase

CC03. Data Transposition with Proc Report
Lingqun Liu, The University of Michigan, Ann Arbor, MI

CC04. Accuracy or Efficiency in Merging
Cindy Liu, Wells Fargo Bank, West Des Moines, IA
Dongmei Lan, Cincinnati Children’s Hospital, Cincinnati, OH

CC05. Dynamic Titles and Footnotes Tool in a Clinical Study Report
Hangtao Xu, Eli Lilly and Company
Mario Widel, Eli Lilly and Company
Jyoti Rayamajhi, Eli Lilly and Company

CC06. Inline Formatting + Long Character Variables = “WOW! That’s SAS®?”
Derek Morgan, Washington University Medical School, St. Louis, MO

CC07. Some Common and Not So Common Uses of Pipes in a Windows Environment
Brian Varney, COMSYS IT Partners, Inc., Kalamazoo, MI

CC08. Journeymen’s Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops
Ronald J. Fehd, Centers for Disease Control and Prevention, Atlanta, GA

Data Mining and Warehousing

DM01. The Metadata Survey Method, Phase II: Tools For General Use
Derek Morgan, Washington University Medical School, St. Louis, MO

Pharmaceuticals and Healthcare

PH07. Deploying SAS® as the Cornerstone of a Stability Monitoring Program: A Case Study
Jeff Gardner, Abbott Laboratories, Abbott Park, IL

Statistics & Data Analysis

SD01. Using Biweights for Handling Outliers
George W. Dombi, PhD., Karmanos Cancer Center, Detroit, MI

SD02. Illustrating generation of MSWord tables via HTML with the %cattable and %contable macros
Matthew T. Karafa, PhD., Cleveland Clinic Foundation, Cleveland, OH

SD03. How to Use Summary Statistics as Raw Data to Do Basic Statistical Analysis
Dachao Liu, Northwestern University, Chicago, IL

SD04. Dependent Scores within KAI and MBTI Instruments
Marie Risov, University of Louisville, Louisville, KY

SD05. Matched Case-Control Techniques: A Data Manager’s Case Study
Matthew P. Shevrin, MM, Department of Veterans Affairs, Ann Arbor, MI
Maria J. Silveira, MD, MA, MPH, Department of Veterans Affairs, Ann Arbor, MI
Anamaria Segnini Kazanis, MA, MA, Department of Veterans Affairs, Ann Arbor, MI

SD07. Time to Failure in UPS Data Collector and UPS Thermal Printer
Rebecca Dennison, University of Louisville, Louisville, KY

SD08. Checking Assumptions in the Cox Proportional Hazards Regression Model
Brenda Gillespie, Ph.D., University of Michigan

SD10. A SAS® Macro for Performing Backward Selection in PROC SURVEYREG
Qixuan Chen, University of Michigan, Ann Arbor, MI
Brenda Gillespie, University of Michigan, Ann Arbor, MI

SD11. Nonparametric Inference for Ordered Alternatives in a One-Way Layout Using the SAS® System
Paul Juneau, Pfizer Global Research & Development, Ann Arbor, MI

SD14. All Possible Mixed Model Selection - A User-friendly SAS Macro Application
George C J Fernandez, University of Nevada - Reno, Reno, NV

SD15. Association of Computer Operator Errors and Lunar Phases
David Corliss, Marketing Associates, Bloomfield Hills, MI

Tutorials and Solutions

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

TU04. Best practices for implementing a BI strategy with SAS
Mike Vanderlinden, COMSYS IT Partners, Portage, MI

TU09. How to Incorporate Old SAS® Data into a New DATA Step, or “What is S-M-U?”
Andrew T. Kuligowski, Nielsen Media Research

TU10. Creating and Exploiting Information Maps and Filters on Clinical Data
Brian Varney, COMSYS IT Partners, Inc., Kalamazoo, MI

TU11. Avoiding Blind Dates with SAS®
Derek Morgan, Washington University School of Medicine, St. Louis, MO

TU12. SAS Macros for Statistical Analysis and Data Management
Brandy R. Sinco, Research Associate, School of Social Work, University of Michigan, Ann Arbor, MI

TU13. The Projman Application: Allowing SAS to Manage Your Project
Jon Patton, Miami University, Oxford, OH